SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE users ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(75) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT = 1; INSERT INTO users(name, password, email) values ('tom', 'e38d', 'tom@gmail.com'); SELECT * FROM users; INSERT INTO users(name, password, email) values ('ed', 'a59r', 'ed@gmail.com'); SELECT * FROM users; UPDATE users SET name='wa' WHERE id=2; SELECT * FROM users; ALTER TABLE users DROP Column name; DELETE FROM users WHERE id=1; Rename TABLE users TO info; Lock table info Read; SELECT * FROM info WHERE id=2;