--初始化操作,创建两个用户一个,testo,一个test.在testo上创建表,test上创建物化视图。SQL> create user testo identified by testo;User created.SQL> create user test identified by test;User created.SQL> grant connect,resource to testo,test;Grant succeeded.SQL> grant create materialized view ...【阅读全文】
--初始化操作,创建两个用户一个,testo,一个test.在testo上创建表,test上创建物化视图。SQL> create user testo identified by testo;User created.SQL> create user test identified by test;User created.SQL> grant connect,resource to testo,test;Grant succeeded.SQL> grant create materialized view ...【阅读全文】
[root@ba ~]# mysqldump --default-character-set=utf8 --databases susite ucme >/home/2db-uch-ss-20120312.sqlmysqldump: Got error: 1449: The user specified as a definer ([url=mailto:]'mbuch'@'10.6.21.%'[/url]) does not exist when using LOCK TABLES【】建用户mysql> grant select,insert,update,delete on mc...【阅读全文】
-- update 操作的触发器例子drop trigger if exists csf_maec.tri_economic_dt_update;delimiter |create trigger csf_maec.tri_economic_dt_update after update on csf_maec.maec_datafor each row begin insert into csf_maec.maec_data_ecnomic( data_id, ...【阅读全文】
-- =====================================================-- MySQL load数据的小问题处理-- =====================================================对于字段类型date,load data infile时,如果不指定相应的FIELDS参数,错误的将日期用单引号引起来会导致插入错误的日期mysql> show create table a;+-------+------...【阅读全文】