mysql

1.\. j:\\database.sql
2.create database mydata;
3.use mydata;
4. show databases
5. show tables;
6. desc dept;
7. insert into dept values(10, 'A', 'A');
8. commit;
9. select * from dept order by deptno  limit 2,3;
10. create table article
 (
 id int primary key auto_increment
 title varchar(30)
 );
11. insert into article values(null,'b');
    insert into article (title) values('d');
 
----+-------+
 id | title |
----+-------+
  1 | a     |
  2 | b     |
  3 | d     |

----+-------+
12. select now();

   select date_format ( now(), '%Y-%m-%d %H:%i:%s');
   insert into emp values(12, 'aa', 'dd', 3, '1888-03-23 23:34:34', 23434, 3
34344, 10);