xhy0422的专栏

1连接数据库：      进入mysql的安装路径bin如：C:\>cd C:\Program Files\MySQL\MySQL Server 5.0\bin     输入用户名密码： C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -p123456 2退出mysql   mysql>exit 3. 修改密码: ...

触发器： CREATE TRIGGER SCHOOL_disable_QUESTION AFTER DELETE ON DB_SCHOOL FOR EACH ROW update DB_QUESTION t set t.STATE_TAG='0' where t.SCHOOL_ID=OLD.SCHOOL_ID; 命令行执行.sql文件 mysql->source C:\mysql\a.sql...