下面是在Linux上登录MysqL,创建数据库和创建表的过程。 yin@yin-Ubuntu10:~$ MysqL -u root -p
Enter password:
Welcome to the MysqL monitor. Commands end with ; or \g.
Your MysqL connection id is 360
Server version: 5.1.41-3ubuntu12.1 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MysqL> create database UseCase;
Query OK,1 row affected (0.00 sec) MysqL> use UseCase;
Database changed MysqL> create table User(UserName varchar(20) primary key,Password varchar(20) not null,CreateTime timestamp default current_timestamp);
Query OK,0 rows affected (0.01 sec)下面就来建立一个页面来完成新建用户的页面。首先是一个简单的表单:
<div class="codetitle"><a style="CURSOR: pointer" data="24090" class="copybut" id="copybut24090" onclick="doCopy('code24090')"> 代码如下: