Mysql基础知识.doc

Mysql 基础知识 8学时0 Mysql的安装1 数据库的创建Create database OA;2 数据类型类型字节最小值最大值(带符号的/无符号的)(带符号的/无符号的)TINYINT1-1281270255SMALLINT2-3276832767065535MEDIUMINT3-83886088388607016777215INT4-2147483648214748364704294967295BIGINT8-922337203685477580892233720368547758070184467440737095516153 数据表格的创建、主键、外键、自动增加create table user(loginId varchar(10) primary key,username varchar(20),password varchar(20),role int )create table course(id int primary key auto_INCREMENT,cname varchar(20),des varchar(20)insert into course values(null,C+,oop course)create table score(id int primary key auto_increment,loginId varchar(10),cid int ,score float,foreign key(cid) references course(id)insert into score values(null,yuyh,20 ,60)4 执行脚本D:tempselect.sqlselect * from score;source d:/temp/select.sql. D:/temp/select.sql5 查看数据库Show databases6 查看表格Show tables7 表结构的查看Desc user8 select 、 update 、insert 、delete9 查看时间Select now();Select current_date;10 jdbc操作package jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class JDBCTest /* * param args */public static void main(String args) / TODO 自动生成方法存根tryClass.forName(com.mysql.jdbc.Driver).newInstance();String name =root;String pwd = root ;String url = jdbc:mysql:/localhost:3306/oa;Connection conn = DriverManager.getConnection(url,name,pwd);Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(select * from course);while(rs.next()String cname = rs.getString(cname);