Top "Mysql" questions

I'm trying to connect to mysql server command line from my windows prompt I write the next line in cmd …

I have a table with ~500k rows; varchar(255) UTF8 column filename contains a file name; I'm trying to strip out …

So I'm trying to add Foreign Key constraints to my database as a project requirement and it worked the first …

I've got a messages table in MySQL which records messages between users. Apart from the typical ids and message types (…

How can I best write a query that selects 10 rows randomly from a total of 600k?

How would I delete all duplicate data from a MySQL Table? For example, with the following data: SELECT * FROM names; +…

I asked a question and got this reply which helped. UPDATE TABLE_A a JOIN TABLE_B b ON a.…

I'm having a bit of a strange problem. I'm trying to add a foreign key to one table that references …

I want to keep a backup of all my MySQL databases. I have more than 100 MySQL databases. I want to …

I have two columns in table users namely registerDate and lastVisitDate which consist of datetime data type. I would like …