Top "Mysql" questions

Multiple select statements in Single query

I am generating a report in php (mysql), ex: `select count(id) as tot_user from user_table select count(…

mysql

Format number to 2 decimal places

I would like to know how can I output a number with 2 decimal places, without rounding the original number. For …

mysql formatting decimal

Auto Generate Database Diagram MySQL

I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool …

mysql database database-design diagram

How can I return pivot table output in MySQL?

If I have a MySQL table looking something like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A …

mysql sql pivot

Log all queries in mysql

Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all …

mysql logging

How to fix "Incorrect string value" errors?

After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched …

mysql

Select all columns except one in MySQL?

I'm trying to use a select statement to get all of the columns from a certain MySQL table except one. …

mysql select wildcard

Set value to NULL in MySQL

I want a value to be set to NULL if nothing is put into the text box in the form …

mysql sql

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL? In what cases should these be used?

mysql integer

Mysql: Setup the format of DATETIME to 'DD-MM-YYYY HH:MM:SS' when creating a table

After googling around, I cannot find a way to create a new table with a DATETIME column with the default …

mysql datetime command-line format create-table