`
文章列表
[root@localhost ~]# mysql -h localhost -uxxxxxxx -pxxxxxxx Welcome to the MariaDB monitor.  Commands end with ; or \g. Your MariaDB connection id is 1905 Server version: 5.5.44-MariaDB-log MariaDB Server   Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.   Type 'help;' or ...
--oracle的字典 select * from dictionary --创建表空间oracle创建表空间 create tablesapce  testSpace datafile 'E:oracleSpace\test.dbf' size 100M autoextend on; --创建用户 create user test identified by t123456 --用户赋权 grant connect,resource,dba to test --创建表  create table test( did number(8) not null, dNa ...
select sysdate from dual--返回系统时间 select trunc(sysdate) from dual select trunc(sysdate-8) from dual select trunc(sysdate+8) from dual select trunc(sysdate-to_date('2015-2-18','yyyy-MM-dd')) from dual--系统时间-指定时间 select trunc(to_date('2015-2-20','yyyy-MM-dd')-8) from dual--指定时间加减天数 select trunc(t ...
#mysql手动操作sql事务管理  start transaction;#开启事务 #要执行的sql delete from table where id=x #事务提交 #commit;     #回滚操作 rollback;
Global site tag (gtag.js) - Google Analytics