Top "Mysql" questions

ALTER TABLE to add a composite primary key

I have a table called provider. I have three columns called person, place, thing. There can be duplicate persons, duplicate …

mysql sql primary-key alter-table composite-primary-key

Compare two MySQL databases

I'm currently developing an application using a MySQL database. The database-structure is still in flux and changes while development progresses (…

mysql database diff

Order a MySQL table by two columns

How do I sort a MySQL table by two columns? What I want are articles sorted by highest ratings first, …

mysql sql-order-by

What data type to use for hashed password field and what length?

I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm …

mysql hash types passwords cryptography

Mysql adding user for remote access

I created user user@'%' with password 'password. But I can not connect with: mysql_connect('localhost:3306', 'user', …

mysql remote-access

Compare dates in MySQL

I want to compare a date from a database that is between 2 given dates. The column from the database is …

mysql sql comparison

PHP mysql insert date format

Im using jQuery datepicker the format of the datepicker is this 08/25/2012 i have errors when inserting to my database it …

php mysql date insert

MySQL's now() +1 day

I'm using now() in MySQL query. INSERT INTO table SET data = '$data', date = now() But I want to add 1 …

sql mysql datetime

How can I simulate an array variable in MySQL?

It appears that MySQL doesn't have array variables. What should I use instead? There seem to be two alternatives suggested: …

mysql arrays variables set temp-tables

MySQL dump by query

Is it possible to do mysqldump by single SQL query? I mean to dump the whole database, like phpmyadmin does …

sql mysql database