Top "Mysql" questions

Truncate with condition

truncate ->this resets the entire table, is there a way via truncate to reset particular records/check conditions. …

sql mysql truncate

MySQL Creating tables with Foreign Keys giving errno: 150

I am trying to create a table in MySQL with two foreign keys, which reference the primary keys in 2 other …

mysql foreign-keys mysql-error-150

Timestamp with a millisecond precision: How to save them in MySQL

I have to develop a application using MySQL and I have to save values like "1412792828893" which represent a timestamp but …

mysql datetime timestamp milliseconds

Terminating idle mysql connections

I see a lot of connections are open and remain idle for a long time, say 5 minutes. Is there any …

mysql timeout kill wait python-idle

MySQL delete multiple rows in one query conditions unique to each row

So I know in MySQL it's possible to insert multiple rows in one query like so: INSERT INTO table (col1,…

mysql unique-constraint multiple-records

SQL (MySQL) vs NoSQL (CouchDB)

I am in the middle of designing a highly-scalable application which must store a lot of data. Just for example …

mysql sql nosql couchdb

How To have Dynamic SQL in MySQL Stored Procedure

How do you build and use dynamic sql in a MySQL stored procedure?

mysql dynamic

How and when to use SLEEP() correctly in MySQL?

In relation to my other question today I am wondering how to use MySQL's SLEEP(duration) correctly. From what I …

mysql sleep

Creating a procedure in mySql with parameters

I am trying to make a stored procedure using mySQL. This procedure will validate a username and a password. I'm …

mysql parameters procedure

MySQl Error #1064

I keep getting this error: MySQL said: #1064 - You have an error in your SQL syntax; check the manual that …

mysql mysql-error-1064