Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # ===== back auto increment to number table ===== #
- ALTER TABLE Pegawai AUTO_INCREMENT = 1;
- # ===== auto set increment ====== #
- TRUNCATE TABLE tablename;
- # ===== sql database/tables =====#
- show databases;
- create database namedatabase;
- create table nametable:
- int (10) not null auto_increment primary key,
- varchar(100) not null,
- varchar (100) not null,
- int (5) not null
- );
- # ===== edit privileges ====== #
- grant all privileges on database.* to user@host identified by 'password';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement