Mysql

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. These are different DBs which all use SQL to manage the data.

56 votes
13 answers
784 views
Which MySQL data type to use for storing boolean values

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse&ap

avatar
Corey
0 1 0 9
asked 07 September, 2021
50 votes
30 answers
1.4K views
How can I output MySQL query results in CSV format?

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

avatar
Joseph
0 1 0 9
asked 07 September, 2021
54 votes
15 answers
1.7K views
How can I get a list of user accounts using the command line in MySQL?

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

avatar
Patsy
0 1 0 9
asked 07 September, 2021
52 votes
30 answers
922 views
Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP

avatar
Trudy
0 1 0 9
asked 07 September, 2021