Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql -h project-db-instance.cp4pbzdfe7d6.us-west-1.rds.amazonaws.com -P 3306 -u admin -p
- SHOW DATABASES;
- CREATE DATABASE project;
- USE sample/project;
- SHOW TABLES;
- SELECT * FROM EMPLOYEES;
- \! clear
- ALTER TABLE `table_name` AUTO_INCREMENT = 1; // FOR empty TABLES
- ALTER TABLE `table_name` DROP `auto_colmn`;
- ALTER TABLE `table_name` ADD `auto_colmn` INT( {many you want} ) NOT NULL AUTO_INCREMENT FIRST ,ADD PRIMARY KEY (`auto_colmn`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement