songdawei001的专栏

[code="mysql"]CREATE DEFINER = 'root'@'%' PROCEDURE `PROC_ROLE_CREATE`(IN i_opr_id SMALLINT, IN i_passport VARCHAR(32), IN i_rolename VARCHAR(32), IN i_sex VARCHAR(1), IN i_ip BIGINT, IN i_recommend I...

DROP TABLE IF EXISTS `dict_province`;CREATE TABLE `dict_province` ( `N_PROVID` int(10) unsigned NOT NULL default '0', `S_PROVNAME` varchar(30) NOT NULL, `S_TYPE` varchar(1) default NULL COM...

由于数据太大,所以暂时以附件的形式上传

[b]常用MySQL命令[/b]　　启动：net start mySql;　　进入：mysql -u root -p/mysql -h localhost -u root -p databaseName;　　列出数据库：show databases;　　选择数据库：use databaseName;　　列出表格：show tables；　　显示表格列的属性：show col...