MySQL DROP all tables, ignoring foreign keys?

Is there a nice easy way to drop all tables from a MySQL database, ignoring any foreign key constraints that may be ...

Access denied for user '[email protected]' (using password:NO)?

I'm new to MySQL, I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with W...

What is the replacement for uniqueidentifier in Mysql?

I have a query from SQL Server which I want to run in Mysql. but I cannot find any replacement for uniqueidentifier ...

Sequelize update with association?

In sequelize it's possible to create a row and all it's association in one go like this: return Product.create({ ...

What is the difference between count(0), count(1).. and count(*) in mySQL/SQL??

I was recently asked this question in an interview. I tried this in mySQL, and got the same results(final results). ...

How can I loop through all rows of a table? (MySQL)?

I have a table A and there is one primary key ID. Now I want to go through all rows in A. I found something like '...

LOAD DATA INFILE Error Code : 13?

In my remote MySQL, when I try to execute this query, I am getting the MySQL Error Code : 13. Query - LOAD DATA IN...

MySQL error 1241: Operand should contain 1 column(s)?

I am trying to Insert data from a table1 into table2 insert into table2(Name,Subject,student_id,result) select (Nam...

MySql: Tinyint (2) vs tinyint(1) - what is the difference??

I knew boolean in mysql as tinyint (1). Today I see a table with defined an integer like tinyint(2), and also other...

Incorrect integer value: '' for column 'id' at row 1?

I am trying to insert into my mySQL database. The first column is the 'id' column, since its an auto_increment field...

Cannot connect to MySQL Workbench on mac. Can't connect to MySQL server on '127.0.0.1' (61) Mac Macintosh?

Cannot connect to MySQL Workbench on mac. I get the following error: Could not connect, server may not be running. C...

MySQL: difference of two result sets?

How can I get the set difference of two result sets? Say I have a result set (just one column in each): result1: '...