9/11/24, 2:38 Data Mangement - Applications
PM (D427)
Create Table
CREATE TABLE table_name (
column_1 data_type
constraint, column_2
data_type constraint,
column_3 data_type
constraint );
Delete Table
DROP TABLE table_name;
Alter Columns
Add Column
ALTER TABLE table_name
ADD COLUMN column_name data_type;
Remove Column
ALTER TABLE table_name
DROP COLUMN
column_name; Change
Column
ALTER TABLE table_name
CHANGE COLUMN CurrentColumnName NewColumnName NewDataType;
Modify Column
ALTER TABLE table_name
MODIFY COLUMN ColumnName NewDataType NewConstraints;
Add Constraint
ALTER TABLE table_name
ADD CONSTRAINT constraint_name
Constraints
PRIMARY KEY
UNIQUE
NOT NULL
DEFAULT value
AUTO_INCREMENT
UNSIGNED positive numbers, SIGNED negative
about:blan 1/
k 3
PM (D427)
Create Table
CREATE TABLE table_name (
column_1 data_type
constraint, column_2
data_type constraint,
column_3 data_type
constraint );
Delete Table
DROP TABLE table_name;
Alter Columns
Add Column
ALTER TABLE table_name
ADD COLUMN column_name data_type;
Remove Column
ALTER TABLE table_name
DROP COLUMN
column_name; Change
Column
ALTER TABLE table_name
CHANGE COLUMN CurrentColumnName NewColumnName NewDataType;
Modify Column
ALTER TABLE table_name
MODIFY COLUMN ColumnName NewDataType NewConstraints;
Add Constraint
ALTER TABLE table_name
ADD CONSTRAINT constraint_name
Constraints
PRIMARY KEY
UNIQUE
NOT NULL
DEFAULT value
AUTO_INCREMENT
UNSIGNED positive numbers, SIGNED negative
about:blan 1/
k 3
