Top "Mysql" questions

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse' for storing true/false …

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After …

I am aware of this command: GRANT ALL PRIVILEGES ON database.* TO 'user'@'yourremotehost' IDENTIFIED BY 'newpassword'; But then it …

I have just installed Debian Lenny with Apache, MySQL, and PHP and I am receiving a PDOException could not find …

I've been trying to figure out how I can make a query with MySQL that checks if the value (string $…

I was given a MySQL database file that I need to restore as a database on my Windows Server 2008 machine. …

I am having a problem with BLOB fields in my MySQL database - when uploading files larger than approx 1MB …

I would like to know the following: how to get data from multiple tables in my database? what types of …

I'm a bit confused on how to order by date formats. For the format YYYY-MM-DD you would do this: ...ORDER …

Is the database query faster if I insert multiple rows at once: like INSERT.... UNION INSERT.... UNION (I need to …