Database Archives - Page 43 of 44

I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want to make the columns user, email, ...

How do you set a default value for a MySQL Datetime column? In SQL Server it’s getdate(). What is the equivalant for MySQL? ...

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 ...