JockerO的博客

Add a Column to a table if not existsMySQL allows you to create a table if it does not exist, but does not provide a native way of a adding a column (i.e. a field) to an existing table with a te

自定义排序select * from doc order by field(doc_title,'主任医师','副主任医师','主治医师','住院医师')首字母排序select * from doc order by CONVERT( doc_name USING gbk ) COLLATE gbk_chinese_ci ASC

一、修改数据库1)首先修改数据字符集2)修改涉及此问题的表字段字符集　　3)修改数据库连接池配置我们项目用的是阿里巴巴的DruidDataSource数据库连接池,贴一下修改位置 id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource" .....

SELECT TABLE_NAME as '表名', COLUMN_NAME as '列名',COLUMN_COMMENT,DATA_TYPE as '字段类型' ,COLUMN_TYPE as '长度加类型' FROM information_schema.`COLUMNS` where TABLE_SCHEMA='smarthos_ty' order by TABLE_NAME,COLUMN