MySQL在线运行

版本：

编辑于 2026-04-14 16:39 累计访问:2792
点击了解高性能代码运行API
运行结果
代码简介
代码仓库
极速运行
终端运行
图形+终端

                        

                        

                    

                

                

                    

                        
用户最新保存的代码

                        
                        查看更多
                    

                

                

                    





    

        

            
                

                

                    作者 我是大神（260214666）
                    
                

            
             编辑于：2026-04-14 16:39  
        

        

    

    

        
    

    

        
CREATE DATEBASE zhangsa_library_ab; 
USE zhangsan_library_ab; CREATE TABLE book(
 bid INT PRIMARY KEY,
 bname VARCHAR(50), 
author VARCHAR(30), 
pricr FLOAT, 
pub-date DATE
);
CREATE TABLE reader(
 rid INT PRIMARY KEY, 
rname VARCHAR(20), 
phone VARCHAR(11),
 rtype VARCHAR(10)
);
CREATE TABLE borrow(
id INT PRIMARY KEY AUTO_INCREMENT,
 rid INT, 
bid INT,
borrow_date DATE, return_date DATE
);


    

    
提示：本站严禁涉政、违法等无关技术的内容
    

    

        

            
            
发送
            

        

    


    

        
        

            搭载国产梦丘操作系统，支持安装软件，在线编程可视化开发软件，无需配置开发环境 
   

            点击购买
            梦丘固件
        


        

    

    

                
                    

                        
                    

                      CREATE DATEBASE zhangsa_library_ab; 
USE zhangsan_library_ab; CREATE TABLE book(
 bid INT PRIMARY KEY,
 bname VARCHAR(50), 
author VARCHAR(30), 
pricr FLOAT, 
pub-date DATE
);
CREATE TABLE reader(
 rid INT PRIMARY KEY, 
rname VARCHAR(20), 
phone VARCHAR(11),
 rtype VARCHAR(10)
);
CREATE TABLE borrow(
id INT PRIMARY KEY AUTO_INCREMENT,
 rid INT, 
bid INT,
borrow_date DATE, return_date DATE
);   2793
                
                

                
                    

                        
                    

                      CREATE TABLE members(
    user_name varchar(20) PRTMARY KEY,
    name varchar(50) NOT NULL,
    gender varchar(10) NOT NULL,
    passwd varchar(50) NOT NULL,
    tell_number varchar(20) NOT NULL,
    reg_time DATEIME NOT NULL
    );   2788
                
                

                
                    

                        
                    

                      create database q1;

use q1;

CREATE TABLE student (
	id int,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);   2679
                
                

                
                    

                        
                    

                      CREATE DATABASE zheng0510;
CREATE TABLE goods(
       id INT(11) PRIMARY KEY AUTO_INCREMENT COMMENT '商品编号',
       type VARCHAR(30) NOT NULL COMMENT '商品类别',
       name VARCHAR(30) UNIQUE COMMENT '商品名称',
       price DECIMAL(7,2) COMMENT '商品价格',
       num INT(11) DEFAULT 0 COMMENT '商品库存',
       add_time DATETIME COMMENT '添加时间'
);   1162
                
                

                
                    

                        
                    

                      CREATE DATABASE zheng0510;
CREATE TABLE goods(
       id INT(11) PRIMARY KEY AUTO_INCREMENT COMMENT '商品编号',
       type VARCHAR(30) NOT NULL COMMENT '商品类别',
       name VARCHAR(30) UNIQUE COMMENT '商品名称',
       price DECIMAL(7,2) COMMENT '商品价格',
       num INT(11) DEFAULT 0 COMMENT '商品库存',
       add_time DATETIME COMMENT '添加时间'
);   2323
                
                

                
                    

                        
                    

                      CREATE TABLE Player (
    PlayerID INT PRIMARY KEY,
    Username VARCHAR(255) NOT NULL,
    Avatar VARCHAR(255),
    Nickname VARCHAR(255),
    Password VARCHAR(255) NOT NULL,
    TotalGamesPlayed INT,
    GamesLost INT,
    GamesWon INT
);   1921
                
                

                
                    

                        
                    

                      CREATE TABLE Player (
    PlayerID INT PRIMARY KEY,
    Username VARCHAR(255) NOT NULL,
    Avatar VARCHAR(255),
    Nickname VARCHAR(255),
    Password VARCHAR(255) NOT NULL,
    TotalGamesPlayed INT,
    GamesLost INT,
    GamesWon INT
);   2131
                
                

                
                    

                        
                    

                      CREATE TABLE Player (
    PlayerID INT PRIMARY KEY,
    Username VARCHAR(255) NOT NULL,
    Avatar VARCHAR(255),
    Nickname VARCHAR(255),
    Password VARCHAR(255) NOT NULL,
    TotalGamesPlayed INT,
    GamesLost INT,
    GamesWon INT
);   4607
                
                

                
                    

                        
                    

                      create database db_teacher;
show databases;
use db_teacher;
create table teacher
(
教工号 varchar(10),
姓名 varchar(10),
职称 varchar(20),
学历 varchar(10),
出生日期 varchar(20),
毕业院校 varchar(20),
工资 decimal(7,2)
);   4248
                
                

                
                    

                        
                    

                      create table stu_kecheng(
name int not null auto_increment,
kecheng varchar(10) not null,
fenshu int,
primary key(name)
);
 [link](http://jsrun.net/)   4199
                
                

                
                    

                        
                    

                      create database yan;
use yan;
create table test(id int(20), name varchar(50), age int(10), pa_id int(60));
insert into test values (1, 'wo', 18, 155), (2,'shi', 20, 182), (3,'wo', 50, 198);   2996
                
                

                
                    

                        
                    

                      CREATE TABLE student (
	id int,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);   1101
                
                

                
                    CREATE TABLE 语句
                
                

                
                    CREATE TABLE语句
                
                

                
                    _.create