十8湾

// 查看外键是否被引用SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE CONSTRAINT_NAME=‘FK_PRODUCT_ID’// 查看表是否被引用select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where REFERENCED_TABLE_NAME=‘被引用表的表名...

1.账号创建create schema 库名称 default character set gbk ;GRANT all privileges ON 库名称.* TO 库名称@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;FLUSH PRIVILEGES;注意：%说明开启远程访问2.删除数据drop database 数据库名称;3.删除账号及权限...