SQLize Online / PHPize Online  /  SQLtest Online

-- create database CREATE DATABASE csit; -- use database USE csit; -- create table CREATE TABLE test (id INT, name VARCHAR(10), age INT); -- add and drop constraints in existing columns ALTER TABLE test ALTER COLUMN id INT NOT NULL; ALTER TABLE test ALTER COLUMN id INT NULL; ALTER TABLE test ADD CONSTRAINT pk PRIMARY KEY (id); ALTER TABLE test DROP CONSTRAINT pk; -- add new column in existing table with primary key and auto increment constraints ALTER TABLE test ADD sn INT IDENTITY PRIMARY KEY; -- display data SELECT * FROM test; -- insert multiple data in single query INSERT INTO test (id, name, age) VALUES (2,'ram',34), (4,'hari',35), (6,'gopal',37) ; -- delete multiple data in single query DELETE FROM test WHERE sn IN (1,3,5); -- update data UPDATE test SET name='rahul' WHERE id=4; -- Rename/change table name EXEC sp_rename 'test', 'tbltest'; -- Rename/change column name EXEC sp_rename 'tbltest.id', 'tid'; -- Display data from the renamed table SELECT * FROM tbltest;