SQL
豆浆and馒头
一个喜欢乱搞的测试
展开
-
多个字段关联同一张字典表-查询SQL
SELECT a.id, a.company_id, d.company_name, a.type, b.dictdata_value, a.`name`, a.url, a.`status`, c.dictdata_valueFROM project_url aLEFT JOIN dictionary b ON a.type = b.dict_valueAND ...原创 2019-03-26 17:04:17 · 4567 阅读 · 1 评论 -
SQL别名ResultSetMetaData.getColumnName无法识别-解决方法
SQL = “SELECT id as a,url from project_url”ResultSet rs = statement.executeQuery(SQL);ResultSetMetaData rsmd = rs.getMetaData();rsmd.getColumnLabel(0);//结果arsmd.getColumnLabel(1);//结果urlrsmd.get...原创 2019-03-27 16:17:28 · 1887 阅读 · 0 评论 -
SQL字段拼接
方法一:select CONCAT(ip,path) from api;方法二:select ip+path from api;原创 2019-04-19 11:41:38 · 1341 阅读 · 0 评论