MySQL在线运行

版本：

编辑于 2022-03-15 11:18 累计访问:1042
点击了解高性能代码运行API
运行结果
代码简介
代码仓库
极速运行
终端运行
图形+终端

                        

                        

                    

                

                

                    

                        
用户最新保存的代码

                        
                        查看更多
                    

                

                

                    





    

        

            
                

                

                    作者 我是大神（2613）
                    
                

            
             编辑于：2022-03-15 11:18  
        

        

    

    

        
    

    

        
create database stu；
use stu；


CREATE TABLE students(
  id INT(11) UNSIGNED,
  name VARCHAR(32),
  age INT(4) UNSIGNED,
  sex VARCHAR(16)
  );


INSERT INTO students(id,name,age,sex) VALUES(1,"小明",22,"男");


SELECT * FROM students;


    

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

    

        

            
            
发送
            

        

    


    

        
        

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

            点击购买
            梦丘固件
        


        

    

    

                
                    

                        
                    

                      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 database q1;

use q1;

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

                
                    

                        
                    

                      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
                
                

                
                    

                        
                    

                      刘克淼作业4   1560
                
                

                
                    

                        
                    

                      name,sex,age,school,number="wjh","男","18","财校","22"
print(name)
print(sex)
print(age)
print(school)
print(number)   2553
                
                

                
                    

                        
                    

                      USE db_DATABASE;
CREATE TABLE tb_student(
	id mediumint not null auto_increment,
	name varchar(20),
    sex enum('男','女')，
    age tinyint,
	address varchar(255),
	primary key(id)
)engine=innodb default charset=utf8;

INSERT INTO tb_student VALUES (null,'张三','男',18,'广东省广州市');
INSERT INTO tb_student VALUES (null,'李四','男',19,'北京市朝阳区');
INSERT INTO tb_student VALUES (null,'张琳','女',20,'福建省厦门市');
INSERT INTO tb_student VALUES (null,'张晓露','女',22,'湖北省武汉市');   3151
                
                

                
                    

                        
                    

                      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
                
                

                
                    

                        
                    

                      func main(){
var name string 
var age int count,err:=fmt.Scanf("%s%d",&name,&age)
fmt.Printf("name=%s,age=%d\n",name,age)
fmt.Printf("输入了%d个参数\n",count)
fmt.Print("错误提示信息：",err)}   6421
                
                

                
                    

                        
                    

                      name='caiyiman'
sex='女'
age=17
school='caijing'
number='01'
print('name,sex,age,school,number',name,sex,age,school,number)   1546
                
                

                
                    

                        
                    

                      create database stu；
use stu；

CREATE TABLE students(
  id INT(11) UNSIGNED,
  name VARCHAR(32),
  age INT(4) UNSIGNED,
  sex VARCHAR(16)
  );


INSERT INTO students(id,name,age,sex) VALUES(1,"小明",22,"男");


SELECT * FROM students;   1043
                
                

                
                    

                        
                    

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

                
                    CREATE TABLE 语句
                
                

                
                    INSERT INTO SELECT 语句
                
                

                
                    CREATE TABLE语句