![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
梅八哥
懒人推动技术进步
展开
-
mysql 变量使用
select user_id,user_name into@USER_ID,@USER_NAME from user where user_id=1;select @USER_ID,@USER_NAME;select *fromuser_subject where user_id=@USER_ID;原创 2021-01-06 17:09:55 · 81 阅读 · 0 评论 -
mysql常用函数
SUBSTRING_INDEX原创 2020-12-04 14:06:29 · 92 阅读 · 0 评论 -
mysql5.7关键字和保留字
https://dev.mysql.com/doc/refman/5.7/en/keywords.htmlA ACCESSIBLE(R) ACCOUNT; added in 5.7.6 (nonreserved) ACTION ADD(R) AFTER AGAINST AGGREGATE ALGORITHM ...转载 2019-04-11 15:38:27 · 378 阅读 · 0 评论 -
mysqldao
public Connection getConnection() throws SQLException { try { Class.forName(PropertiesUtil.getString("jdbc.driver")); } catch (ClassNotFoundException e) { e.printStackTrace(); }...2018-07-30 17:52:59 · 400 阅读 · 0 评论 -
mysql时间
select CURRENT_TIMESTAMP;select NOW();select CURDATE();select CURTIME();select UNIX_TIMESTAMP();select SYSDATE();原创 2017-03-08 14:40:48 · 111 阅读 · 0 评论 -
mysql event定时器
使用event常见的工作是创建表、插入数据、删除数据、清空表、删除表。SHOW VARIABLES LIKE 'event_scheduler';SET GLOBAL event_scheduler = 1; CREATE EVENT [IF NOT EXISTS]event_nameON SCHEDULE schedule[ON COMPLE...原创 2017-03-02 18:08:15 · 140 阅读 · 0 评论 -
logback配置及打印sql
logback<?xml version="1.0" encoding="UTF-8"?><configuration debug="false" scan="true" scanPeriod="1 seconds"> <contextName>logback</contextNam2017-11-02 15:26:28 · 1661 阅读 · 0 评论 -
mysql日志
在my.ini中添加如下数据,重启mysql服务#sql add 20170815log-error="E:/mysql/logs/error.log" log="E:/mysql/logs/all.log" long_query_time=2log-slow-queries= "E:/mysql/logs/slow_query.log" log-bin="E:/m...原创 2017-08-15 17:46:06 · 114 阅读 · 0 评论 -
mysql+poi导出数据库设计文档
package com.chipmunk.word;import java.io.FileOutputStream;import java.math.BigInteger;import java.util.List;import java.util.Map;import org.apache.poi.hslf.model.textpropertie...2017-08-11 18:43:56 · 239 阅读 · 0 评论 -
mysql sql CRUD
删除别名问题delete from aaa where id in (select id from bbb) 对delete from aaa a where exist(select id from bbb where id=a.id) 错delete a from aaa a where exist(select id from bbb where ...原创 2017-04-05 18:50:18 · 87 阅读 · 0 评论 -
常用sql
1.查询并创建表create table abcCOMMENT='学生表'SELECT * from defwhere id<20 2.查询包含_%等关键字符的字符串,使用反斜杠,字段是关键词的使用键盘1前面那个键``引起来select * from studentwhere sname like '%\%%'--包含%s...原创 2016-11-14 17:51:25 · 130 阅读 · 0 评论 -
oracle所有表的基本信息
原文:http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htmALL_TAB_COLUMNSALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user...原创 2016-08-24 15:41:50 · 294 阅读 · 0 评论 -
Oracle的表结构查询
select * from all_tables WHERE table_name='STUDENT';select * from all_tab_columns where owner='chipmunk' and table_name='STUDENT';select column_name,comments from all_col_comments where ow...原创 2016-08-24 13:51:08 · 116 阅读 · 0 评论 -
mysql和sqlserver的Date类型
转:http://www.w3school.com.cn/sql/sql_dates.asp MySQL Date 函数下面的表格列出了 MySQL 中最重要的内建日期函数:函数描述NOW()返回当前的日期和时间CURDATE()返回当前的日期CURTIME()返回当前的时间DATE()提取日期或日期/时间表达...原创 2016-07-27 16:37:49 · 1007 阅读 · 0 评论 -
数据库
Oracle,SQLserver,mySQL,postgreSQL,DB2区别 1.端口Oracle----1521SqlServer---1433MySQL-----3306postgreSQL-----5432DB2-----50000 2.自动生成主键Oracle----sequence---select seq.nextval from dua...2011-06-07 18:23:11 · 125 阅读 · 0 评论