Mysql基础知识

《Mysql基础知识》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Mysql基础知识–8学时0Mysql的安装1数据库的创建CreatedatabaseOA;2数据类型类型字节最小值最大值  (带符号的/无符号的)(带符号的/无符号的)TINYINT1-128127  0255SMALLINT2-3276832767  065535MEDIUMINT3-83886088388607  016777215INT4-21474836482147483647  04294967295BIGINT8-92233720368547758089223372036854775807  01844674407370

2、95516153数据表格的创建、主键、外键、自动增加createtableuser(loginIdvarchar(10)primarykey,usernamevarchar(20),passwordvarchar(20),roleint)createtablecourse(idintprimarykeyauto_INCREMENT,cnamevarchar(20),desvarchar(20))insertintocoursevalues(null,'C++','oopcourse')createtablescore(idintpri

3、marykeyauto_increment,loginIdvarchar(10),cidint,scorefloat,foreignkey(cid)referencescourse(id))insertintoscorevalues(null,'yuyh',20,60)4执行脚本D:tempselect.sqlselect*fromscore;sourced:/temp/select.sql.D:/temp/select.sql5查看数据库Showdatabases6查看表格Showtables7表结构的查看Descuser8s

4、elect、update、insert、delete9查看时间Selectnow();Selectcurrent_date;10jdbc操作packagejdbc;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicclassJDBCTest{/***@paramargs*/publicstaticvoidmain(String[]args){//TODO自动生成方法

5、存根try{Class.forName("com.mysql.jdbc.Driver").newInstance();Stringname="root";Stringpwd="root";Stringurl="jdbc:mysql://localhost:3306/oa";Connectionconn=DriverManager.getConnection(url,name,pwd);Statementstmt=conn.createStatement();ResultSetrs=stmt.executeQuery("select*f

6、romcourse");while(rs.next()){Stringcname=rs.getString("cname");System.out.println(cname);}conn.close();}catch(Exceptione){e.printStackTrace();}}}