mysql

MySQL create new user

CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost';
FLUSH PRIVILEGES;

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

MySQL autoincrement == IDENTITY(1,1)

I often forget this, so....

MySQL autoincrement == IDENTITY(1,1) as in


id int IDENTITY(1,1) PRIMARY KEY,

Syndicate content