根据字段查询表:
SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE 'DepartID';
视图:
CREATE ALGORITHM=UNDEFINED DEFINER=`xoops_root`@`127.0.0.1` VIEW `v_form_number` AS SELECT `a`.`UUID` AS `uuid`,'' AS `worknumber`,
`a`.`turnname` AS `turnname`,`a`.`tablename` AS `tablename`,`a`.`pp` AS `pp`
FROM (`v_form` `a` LEFT JOIN `mt_jbpm_apply` `b` ON((`a`.`UUID` = `b`.`FOREIGNID`))) WHERE (1 = 2)
ALGORITHM:这是指定算法
DEFINER=`xoops_root`@`127.0.0.1`:这是指定权限,‘root@%’这意思是所有人的权限
Column 'dirction' in where clause is ambiguous
多表查询中,出现字段名一样的,
mysql函数
ifnull(concat(cast(concat('[ ',audittype,' ] ') as char),cast(typename as char)),'未确定类型') as typename,
concat:拼接字符串,
cast:指定字符串编码,防止拼接字符串导致乱码
convert("aaa" using gbk) :设置字符串的编码
2018年10月23日遇到问题
<driver-url>jdbc:mysql://10.0.101.2:3306/asdb?autoReconnect=true&useUnicode=true&characterEncoding=utf8</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="123456"/>
<property name="autoReconnect" value="true" />
配置文件中链接数据库的配置编码一定要和数据库编码要一致,不然就会出现各种乱码问题,编码不一致问题报错,今天就遇到数据库是GBK的,然后链接是UTF8的,所以各种编码问题