Top "Mysql" questions

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

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

I use the following command: mysql -u root -h 127.0.0.1 -p and the error message is : ERROR 2003 (HY000): Can't connect to …

mysql mysql-error-2003
Convert timestamp to date in MySQL query

I want to convert a timestamp in MySQL to a date. I would like to format the user.registration field …

mysql sql date-formatting
MySQL error 2006: mysql server has gone away

I'm running a server at my office to process some files and report the results to a remote MySQL server. …

mysql mysql-error-2006
Join vs. sub-query

I am an old-school MySQL user and have always preferred JOIN over sub-query. But nowadays everyone uses sub-query, and I …

sql mysql subquery join
How to get size of mysql database?

How to get size of a mysql database? Suppose the target database is called "v3".

mysql database
Search text in fields in every table of a MySQL database

I want to search in all fields from all tables of a MySQL database a given string, possibly using syntax …

mysql
What is the error "Every derived table must have its own alias" in MySQL?

I am running this query on MySQL SELECT ID FROM ( SELECT ID, msisdn FROM ( SELECT * FROM TT2 ) ); and it is …

mysql subquery mysql-dependent-subquery mysql-error-1248
How to stop mysqld

To find out the start command for mysqld (using a mac) I can do: ps aux|grep mysql I get …

mysql macos
MySQL: How to reset or change the MySQL root password?

How do I change the MySQL root password and username in ubuntu server? Do I need to stop the mysql …

mysql ubuntu phpmyadmin
How do I see all foreign keys to a table or column?

In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular …

mysql foreign-keys innodb