创建学生表,包含学号 姓名 年龄 性别
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER,
gender TEXT
);
All generations.
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER,
gender TEXT
);
<div class="body">
<div class="title">登录</div>
<div class="content">
<div class="input">
<input type="text" class="username" placeholder="请输入用户名">
</div>
<div class="input">
<input type="password" class="password" placeholder="请输入密码">
</div>
</div>
<div class="bottom">
<button class="login">登录</button>
<div class="forget">忘记密码</div>
</div>
</div>
<div class="container">
<div class="row">
<div class="col-md-6">
<img src="images/img.png" alt="">
</div>
<div class="col-md-6">
<form action="http://www.baidu.com" method="post">
<div class="form-group">
<div class="input-group">
<span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
<input type="text" class="form-control" placeholder="用户名">
</div>
</div>
<div class="form-group">
<div class="input-group">
<span class="input-group-addon"><i class="glyphicon glyphicon-lock"></i></span>
<input type="text" class="form-control" placeholder="密码">
</div>
</div>
<div class="form-group">
CREATE TABLE student(
sno INT PRIMARY KEY AUTO_INCREMENT,
sname VARCHAR(10) NOT NULL,
sage INT NOT NULL,
ssex CHAR(2) NOT NULL
);
### 解答:
create table student(sno int,sname varchar(20),sage int,ssex varchar(20))
<div class="login-page">
<div class="form">
<form class="register-form">
<input type="text" placeholder="name"/>
<input type="password" placeholder="password"/>
<input type="text" placeholder="email address"/>
<button>create</button>
<p class="message">Already registered? <a href="#">Sign In</a></p>
</form>
<form class="login-form">
<input type="text" placeholder="username"/>
<input type="password" placeholder="password"/>
<button>login</button>
<p class="message">Not registered? <a href="#">Create an account</a></p>
</form>
</div>
</div>
CREATE TABLE student(
sno VARCHAR(5) PRIMARY KEY NOT NULL,
sname VARCHAR(20) NOT NULL,
sage SMALLINT,
ssex CHAR
);
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>百度一下,你就知道</title>
<style type="text/css">
.container {
width: 1000px;
margin: 0 auto;
}
.header {
background-color: #6a6a6a;
}
.logo {
float: left;
height: 100px;
width: 100px;
}
.search {
float: left;
width: 400px;
height: 100px;
}
.search-box {
height: 30px;
width: 380px;
border: 1px solid #c2c2c2;
}
.search-btn {
height: 30px;
width: 60px;
border: 1px solid #c2c2c2;
}
.
<form action="http://www.baidu.com">
<input type="text" placeholder="请输入用户名" name="username">
<input type="password" placeholder="请输入密码" name="password">
<button type="submit">登录</button>
<a href="http://www.taobao.com">忘记密码</a>
</form>
CREATE TABLE students (
name varchar(10),
age int,
address varchar(20),
class varchar(20)
);
INSERT INTO students (name,age,address,class) VALUES ('小明',23,'北京市朝阳区','初三六班');
INSERT INTO students (name,age,address,class) VALUES ('小王',18,'北京市海淀区','初三六班');
INSERT INTO students (name,age,address,class) VALUES ('小花',20,'北京市丰台区','初二七班');
CREATE TABLE student(
sno INT UNSIGNED AUTO_INCREMENT,
sname VARCHAR(10),
sage TINYINT UNSIGNED,
ssex CHAR(2),
PRIMARY KEY (sno)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE student(
sno int,
sname varchar(10),
sage int,
ssex varchar(2)
);
CREATE TABLE student (sno CHAR(4),sname CHAR(8),sage SMALLINT,ssex CHAR(2));
CREATE TABLE students (name VARCHAR(20), age INT, address VARCHAR(50), class VARCHAR(30));
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>登录页面</title>
</head>
<body>
<div class="container" id="main">
<div class="userName">
<input type="text" placeholder="请输入用户名">
</div>
<div class="passWord">
<input type="password" placeholder="请输入密码">
</div>
<div class="login-btn">
<input type="button" value="登录">
</div>
<div class="forget-btn">
<input type="button" value="忘记密码">
</div>
</div>
</body>
</html>
create table students(
id integer primary key,
name varchar(255),
age integer,
address varchar(255),
class varchar(255)
);
insert into students(name,age,address,class) values('小明',23,'北京市朝阳区','初三六班');
insert into students(name,age,address,class) values('小王',18,'北京市海淀区','初三六班');
insert into students(name,age,address,class) values('小花',20,'北京市丰台区','初二七班');
select * from students where class='初三六班';
CREATE TABLE student (
sno CHAR(8),
name CHAR(8),
age SMALLINT,
sex CHAR(2)
);
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<div class="container">
<div class="title">
<a href="">
<img src="logo.png" alt="logo">
</a>
</div>
<div class="search">
<form action="" method="get">
<input type="text" name="" value="" placeholder="请输入搜索关键字...">
<input type="submit" value="搜索">
</form>
</div>
</div>
</body>
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<style>
html,body{
margin:0;
padding:0;
}
.container{
width:1000px;
margin:0 auto;
border:1px solid green;
}
.container .title{
width:100%;
height:100px;
background:red;
}
.container .content{
width:100%;
height:200px;
background:yellow;
}
</style>
</head>
<body>
<div class="container">
<div class="title">标题</div>
<div class="content">内容</div>
</div>
</body>
</html>
``
Generate
More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.
Function from Description
Text Description to SQL Command
Translate Languages
Generate HTML from Description
Code to Explanation
Fix invalid Code
Get Test for Code
Class from Description
Regex from Description
Regex to Explanation
Git Command from Description
Linux Command
Function from Docstring
Add typing to code
Get Language from Code
Time complexity
CSS from Description
Meta Tags from Description
− sponsored −