Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

MySQL selecting yesterday's date

How can I display and count the values whose dates are yesterday? I used time() to insert date in the …

mysql
Multiple queries executed in java in single statement

Hi I was wondering if it is possible to execute something like this using JDBC as it currently provides an …

java mysql sql jdbc
Exporting results of a Mysql query to excel?

My requirement is to store the entire results of the query SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult …

mysql excel export
How to compare timestamp dates with date-only parameter in MySQL?

In a SQL statement, how do I compare a date saved as TIMESTAMP with a date in YYYY-MM-DD format? Ex.: …

mysql datetime date
Include headers when using SELECT INTO OUTFILE?

Is it possible to include the headers somehow when using the MySQL INTO OUTFILE?

mysql into-outfile
Stop MySQL service windows

I am developing a website and need to refresh data. Therefore MySQL must be stopped. How can I stop the …

mysql shutdown restart
Delete many rows from a table using id in Mysql

I am a Linux admin with only basic knowledge in Mysql Queries I want to delete many table entries which …

mysql sql sql-delete
MySQL show current connection info

I am in a MySQL terminal session but I don't know what server I am connected to, or what database …

mysql
Updating MySQL primary key

I have a table user_interactions with 4 columns: user_1 user_2 type timestamp The primary key is (user_1,user_2,type) and …

mysql primary-key
Insert and set value with max()+1 problems

I am trying to insert a new row and set the customer_id with max()+1. The reason for this is …

mysql sql insert mysql-error-1093