摘要：复制模板新增insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("localhost","cz",password("cz2@14"),'','','');flush privileges;create database czdb;grant all privileges on czdb.* to cz@localhost identified by 'cz2@ 阅读全文

摘要：CREATE PROCEDURE `test`.`new_procedure` ()BEGINDECLARE done INT DEFAULT FALSE; -- 需要定义接收游标数据的变量 DECLARE a CHAR(16); -- 游标 DECLARE cur CURSOR FOR SELECT i FROM test.t; -- 遍历数据结束标志 DECLARE done INT DEFAULT FALSE; -- 将结束标志绑定到游标 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; -- 打开游标 OPEN cur1;. 阅读全文

摘要：查看mysql表结构的方法有三种：1、desctablename;例如：要查看jos_modules表结构的命令：descjos_modules;查看结果：mysql>descjos_modules;+------------------+---------------------+------+-----+---------------------+----------------+|Field|Type|Null|Key|Default|Extra|+------------------+---------------------+------+-----+------------- 阅读全文