随笔分类 -  【准备删1】

摘要：create database Susake;use Susake;create table Test(a int, b int);insert into Test values(1, 2);select *from Test; 阅读全文

摘要：The INSERT privilege enablesrows to be inserted into tables in a databasecreate database Susake;use Susake;create table Test(a int, b int);insert into Test values(1, 2); 阅读全文

摘要：The DELETE privilege enablesrows to be deleted from tables in a databasecreate database Susake;use Susake;create table Test(a int, b int);insert into Test values(1, 2);insert into Test values(2, 3);delete from Test where a = 1;drop table Test;drop database Susake; 阅读全文

摘要：The ALTER privilege enables use of ALTER TABLE to change thestructure of tables. ALTER TABLE also requires theCREATE and INSERT privileges. Renaming atable requires ALTER andDROP on the old table,ALTER,CREATE, andINSERT on the new tablecreate database Susake;use Susake;create table Qing(a int, b int 阅读全文

摘要：The LOCK TABLES privilegeenables the use of explicit LOCK TABLES statements to lock tables for which you havethe SELECT privilege. Thisincludes the use of write locks, which prevents other sessionsfrom reading the locked tablecreate database Susake;use Susake;create table Test(a int, b int);lock tab 阅读全文