风来君的专栏

--create a procedre CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_compall`(name varchar(50)) begin if name='' then select * from eb_comp; else select * from eb_comp where companyname like name; end if; end;

<br />允许所有IP访问<br />grant all privileges on *.* to root@'%' identified by '';

delimiter//改变界定符 为// 列出所有数据库 showdatabases; 列出所有数据表 showtables; 改变连接数据库 usedatabaes; 列出数据库编码 show variables like 'character_set_%'; 插入记录 insertintousers(UserName,Password)val