Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Use LIKE %..% with field values in MySQL

I stumbled into a delicate SQL problem when I needed to use a value from a field inside a LIKE %..% …

mysql sql sql-like
php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

I am using php mysqli_connect for login to a MySQL database (all on localhost) <?php //DEFINE ('DB_USER', …

php mysql hash sha
How to get a list of MySQL views?

I'm looking for a way to list all views in a database. Initially I found and tried an answer on …

mysql
How can I properly use a PDO object for a parameterized SELECT query

I've tried following the PHP.net instructions for doing SELECT queries but I am not sure the best way to …

php mysql select pdo
Install mysql-python (Windows)

I've spent hours trying to make Django work on my computer. The problem is that I can't install the mysql-python …

python mysql django mysql-python
Table 'performance_schema.session_variables' doesn't exist

After upgrading MySQL to 5.7.8-rc and loging to server I got error: Table 'performance_schema.session_variables' doesn't exist I …

mysql upgrade
How to change the CHARACTER SET (and COLLATION) throughout a database?

Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it …

mysql sql collation
Grouping into interval of 5 minutes within a time range

I have some difficulties with mySQL commands that I want to do. SELECT a.timestamp, name, count(b.name) FROM …

mysql sql group-by
MySQL: ALTER TABLE if column not exists

I have this code: ALTER TABLE `settings` ADD COLUMN `multi_user` TINYINT(1) NOT NULL DEFAULT 1 And I want to alter …

mysql ddl alter-table
How to change value for innodb_buffer_pool_size in MySQL on Mac OS?

I am trying to increase the size of the innodb_buffer_pool_size in MySQL 5.1 as I keep running into …

mysql innodb