清心寡欲的博客

-- 查询数据库库所有表结构SELECT t.table_name as '表', t.table_comment as '表名',c.ORDINAL_POSITION AS '序号',c.COLUMN_NAME AS '字段名',c.COLUMN_TYPE AS '类型(长度)',c.NUMERIC_PRECISION AS '精度',c.NUMERIC_SCALE AS '小数位数',c.COLUMN_DEFAULT AS '默认值',IF( c.IS_NULLABLE = 'YE

系统：navicat打开后报错： 00000000009CE10A in module 'navicat.exe'. Read of address 00000000000000001.

现象安装mysql时候，执行命令 /usr/local/mysql/support-files/mysql.server start，启动mysql报错如下：[root@localhost local]# /usr/local/mysql/support-files/mysql.server startStarting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/localhost.loca

mysql安装

1.查询当前库的所有表名show tables2.查询某张表所有字段desc tablename3.创建存储过程DELIMITER$CREATE PROCEDURE aa(IN 参数名 参数类型)BEGINSELECT * FROM tablename;END $DELIMITER;4.调用存储过程-- 标准语法CALL 存储过程名称(实际参数);5.查看所有存储过程SELECT * from mysql.proc where db='数据.

说明你的MySQL还没有启动。解决办法：Liunx环境重启mysql命令　　service mysqld restart