MySQLѧϰ±Ê¼Ç

Ò»¡¢MySQL»ù±¾ÃüÁºÏ£º
1¡¢  create database mydata£»//´´½¨Êý¾Ý¿â
2¡¢  use mydata; //ÔÚmydataÕâ¸öÊý¾Ý¿âϹ¤×÷
3¡¢  create table dept    //ÔÚmydataÊý¾Ý¿âÏ´´½¨±ídept
(
deptno int primary key,
dname varchar(14),
loc varchar(13)
);
 
create table emp  //ÔÚmydataÊý¾Ý¿âÏ´´½¨±íemp
(
empno int primary key,
ename varchar(10),
job varchar(10),
mar int,
hiredate datetime,
sal double,
comm double,
deptno int,
foreign key (deptno) references dept(deptno)
);
4¡¢  show databases£»//ÏÔʾÊý¾Ý¿â
5¡¢  show tables£»//ÏÔʾ±í
6¡¢  desc dept£»//ÏÔʾdept±íµÄ½á¹¹
7¡¢  insert into dept values£¨10, ‘A’, ‘A’£©£»//Ïòdept±íÖÐÌí¼Ó¼Ç¼
   insert into dept values£¨20, ‘B’, ‘B’£©£»
   insert into dept values£¨30, ‘C’, ‘C’£©£»
   commit£» //Ìá½»
8¡¢  select * from dept£»//²éѯ¼Ç¼
select * from dept order by deptno desc limit 3,2£»//ÏÔʾ¼Ç¼
¶þ¡¢MySQLµÄ×Ô¶¯µÝÔö£º
create  table article          //´´½¨×Ô¶¯µÝÔö±í
(
Id int primary key auto_increment,
Title varchar(255)
);
Insert into article values(null,’a’);
Insert into article values(null,’b’);
Insert into article(title) values(‘c’);
Èý¡¢MySQLµÄÈÕÆÚʱ¼ä£º
1¡¢  select now£¨£©£»//ÏÔʾµ±Ç°Ê±¼ä
2¡¢  select date_format(now( ),’%y-%m-%d  %H£º%i£º%s’)£»//ÏÔʾָ¶¨¸ñʽµÄʱ¼ä
ËÄ¡¢MySQL_jdbcÁ¬½Ó£º
import java.sql.*;
public class TestMysqlConnection {
    public static void main(String[] args) {
       Connection conn = null;
       Statement stmt = null;
       ResultSet rs = null;
       try {
           Class.forName("com.mysql.jdbc.Driver");
 &nb