mysql数据库的高级应用索引,视图,触发器的详细介绍

/

*

ORDER BY

mysql>delimiter $$  //

(

create table

[

[

desc

(

 t2

 t2

create table t5 like t2;

create

(

alter table

sql

view

view

create or replace view

use view;

alter

alter view

use view;

select    

update

delect

触发器简介

(triggers) 

:

create

;

//

// 

2

student_insert_trigger

1

show triggers\G

2

use information_schema

Drop trigger student_insert_trigger;

tab1

tab1

tab2

after_tab1_trigger

tab1

tab2

ustudent_trigger

new

mysql数据库的高级应用索引,视图,触发器的详细介绍