Advertisement
ujiajah1

sql-auto-set/sql-code-auto-input

Apr 9th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.48 KB | None | 0 0
  1. # ===== back auto increment to number table ===== #
  2. ALTER TABLE Pegawai AUTO_INCREMENT = 1;
  3. # ===== auto set increment ====== #
  4. TRUNCATE TABLE tablename;
  5. # ===== sql database/tables =====#
  6. show databases;
  7. create database namedatabase;
  8. create table nametable:
  9. int (10) not null auto_increment primary key,
  10. varchar(100) not null,
  11. varchar (100) not null,
  12. int (5) not null
  13. );
  14. # ===== edit privileges ====== #
  15. grant all privileges on database.* to user@host identified by 'password';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement