Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
--创建数据表 create table 商品信息表 ( 商品编号 VARCHAR(4) primary key, 商品名称 VARCHAR(10) not null, 商品价格 int not null, 商品库存 int not null, 备注 char(30) ) --插入表内数据 insert into 商品信息表(商品编号,商品名称,商品价格,商品库存) values('a001','T恤',98,136), ('b001','裤子',200,120), ('a002','卫衣',380,92), ('a003','衬衫',190,60) --查询商品信息 select * from 商品信息表 --更改表的属性类别 alter table 商品信息表 --更改某个表 alter column 商品价格 float --更改表的某一属性 --查询商品信息 select * from 商品信息表 --更改表的属性的大小 alter table 商品信息表 alter column 商品名称 varchar(18) --删除表的属性 alter table 商品信息表 drop column 备注 --查询商品信息 select * from 商品信息表 --重命名表 sp_rename '商品信息表','商品信息'

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Have a question? Ask in our telegram chat!
Contact us:
© 2025 Free Online MS SQL Server 2019 Playground: Practice & Master SQL Skills | About project | Privacy Policy and Disclaimer
The site powered by: Contabo
PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, MariaDB 11.4, MariaDB 11.8, MariaDB 11.8 OpenFlights (ReadOnly), MariaDB 10, MariaDB 10 Sakila (ReadOnly), SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17 + PostGIS, PostgreSQL 17 + PostGIS WorkShop (ReadOnly), PostgreSQL 18, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), MS SQL Server 2025, Firebird 4.0, Firebird 4.0 (Employee), Firebird 5.0, RedDatabase 5.0, Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 26ai, SOQOL, ClickHouse