aoeace

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;

SUBSTRING_INDEX

https://dev.mysql.com/doc/refman/5.7/en/keywords.html A ACCESSIBLE(R) ACCOUNT; added in 5.7.6 (nonreserved) ACTION ADD(R) AFTER AGAINST AGGREGATE ALGORITHM ...

  public Connection getConnection() throws SQLException { try { Class.forName(PropertiesUtil.getString("jdbc.driver")); } catch (ClassNotFoundException e) { e.printStackTrace(); } ...

  select CURRENT_TIMESTAMP; select NOW(); select CURDATE(); select CURTIME(); select UNIX_TIMESTAMP(); select SYSDATE();

  使用event常见的工作是创建表、插入数据、删除数据、清空表、删除表。 SHOW VARIABLES LIKE 'event_scheduler'; SET GLOBAL event_scheduler = 1; CREATE EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLE...

  logback <?xml version="1.0" encoding="UTF-8"?> <configuration debug="false" scan="true" scanPeriod="1 seconds"> <contextName>logback</contextNam

在my.ini中添加如下数据，重启mysql服务 #sql add 20170815 log-error="E:/mysql/logs/error.log" log="E:/mysql/logs/all.log" long_query_time=2 log-slow-queries= "E:/mysql/logs/slow_query.log" log-bin="E:/m...

      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...

      删除别名问题 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 ...

      1.查询并创建表 create table abc COMMENT='学生表' SELECT * from def where id<20         2.查询包含_%等关键字符的字符串，使用反斜杠，字段是关键词的使用键盘1前面那个键``引起来 select * from student where sname like '%\%%'--包含% s...

原文：http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm ALL_TAB_COLUMNS ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user...

  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...

      转：http://www.w3school.com.cn/sql/sql_dates.asp   MySQL Date 函数 下面的表格列出了 MySQL 中最重要的内建日期函数： 函数 描述 NOW() 返回当前的日期和时间 CURDATE() 返回当前的日期 CURTIME() 返回当前的时间 DATE() 提取日期或日期/时间表达...

Oracle,SQLserver,mySQL,postgreSQL,DB2区别    1.端口 Oracle----1521 SqlServer---1433 MySQL-----3306 postgreSQL-----5432 DB2-----50000   2.自动生成主键 Oracle----sequence---select seq.nextval from dua...