Top "Mysql" questions

Create a temporary table in a SELECT statement without a separate CREATE TABLE

Is it possible to create a temporary (session only) table from a select statement without using a create table statement …

mysql select temp-tables create-table derived-table

How do I query between two dates using MySQL?

The following query: SELECT * FROM `objects` WHERE (date_field BETWEEN '2010-09-29 10:15:55' AND '2010-01-30 14:15:55') returns …

mysql sql

How to declare a variable in MySQL?

How to declare a variable in mysql, so that my second query can use it? I would like to write …

mysql sql

#1071 - Specified key was too long; max key length is 767 bytes

When I executed the following command: ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` ); I got this error message: #1071 - Specified …

mysql byte varchar mysql-error-1071

How can I temporarily disable a foreign key constraint in MySQL?

Is it possible to temporarily disable constraints in MySQL? I have two Django models, each with a foreign key to …

mysql sql django django-models

How to export a mysql database using Command Prompt?

I have a database that is quite large so I want to export it using Command Prompt but I don't …

mysql

MySQL Query GROUP BY day / month / year

Is it possible to make a simple query to count how many records I have in a determined period of …

mysql sql date datetime group-by

Add Foreign Key to existing table

I want to add a Foreign Key to a table called "katalog". ALTER TABLE katalog ADD CONSTRAINT `fk_katalog_sprache` …

mysql foreign-keys

How do I change the data type for a column in MySQL?

I want to change the data type of multiple columns from float to int. What is the simplest way to …

mysql

MySQL SELECT only not null values

Is it possible to do a select statement that takes only NOT NULL values? Right now I am using this: …

mysql sql select notnull