Posts

Showing posts from March, 2018

mysql cheat sheet

User Creation: CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test623'; GRANT ALL ON testdb.* TO 'testuser'@'localhost'; FLUSH PRIVILEGES; Sql Create Table: CREATE TABLE Persons (     PersonID int,     LastName varchar( 255 ),     FirstName varchar( 255 ),     Address varchar( 255 ),     City varchar( 255 ) );