MySQL Archives - Page 37 of 38

I want to add a row to a database table, but if a row exists with the same unique key I want to ...

I can run this query to get the sizes of all tables in a MySQL database: show table status from myDatabaseName; I would ...

I’m trying to update the column visited to give it the value 1. I use MySQL workbench, and I’m writing the statement in ...

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not ...

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance? 8

Since MySQL doesn’t seem to have any ‘boolean’ data type, which data type do you ‘abuse’ for storing true/false information in MySQL? Especially ...

Is there an easy way to run a MySQL query from the Linux command line and output the results in CSV format? Here’s ...

I’m using the MySQL command-line utility and can navigate through a database. Now I need to see a list of user accounts. How ...