Top "Mysql" questions

Is there a MySQL command to convert a string to lowercase?

I have a MySQL database of keywords that are presently mixed-case. However, I want to convert them all to lowercase. …

php mysql

How do I show a MySQL warning that just happened?

I just ran a simple MySQL CREATE TABLE statement that produced the line "Query OK, 0 rows affected, 1 warning (0.07 sec)." It …

mysql

Example of how to use bind_result vs get_result

I would like to see an example of how to call using bind_result vs. get_result and what would …

php mysql mysqli prepared-statement

How to export data from SQL Server 2005 to MySQL

I've been banging my head against SQL Server 2005 trying to get a lot of data out. I've been given a …

mysql sql-server csv sql-server-2005 bcp

"IDENTIFIED BY 'password'" in MySQL

I often see in many MySQL tutorials that people use command IDENTIFIED BY 'password' both during user creation and granting …

mysql privileges grant

access denied for load data infile in MySQL

I use MySQL queries all the time in PHP, but when I try LOAD DATA INFILE I get the following …

mysql load-data-infile mysql-error-1045

Unable to start the mysql server in ubuntu

After running the command mysql -v in Ubuntu, I am getting the following error: ERROR 2002 (HY000): Can't connect to local …

mysql ubuntu-16.04

MySQL. Can't create table errno 150

I have to create a database with two tables in MySQL, but the script fails with errno 150 (foreign key problem). …

mysql mysql-error-1005

How to add column values in mysql

This is my table data Student And this is my query -- SELECT id, SUM( maths + chemistry + physics ) AS total, …

mysql sql logic sum

MySQL Utilities - ~/.my.cnf option file

I am trying to use 2 of the mysql utilities, mysqldiff and mysqldbcompare and want to avoid putting my password on …

mysql passwords utilities