/SQL/My sql alter table

My sql alter table

Alter table mysql

ALTER TABLE contacts
  ADD last_name varchar(40) NOT NULL
    AFTER contact_id,
  ADD first_name varchar(35) NULL
    AFTER last_name;

0

Source: techonthenet.com

My sql alter table

ALTER TABLE nom_table
MODIFY nom_colonne type_donnees

0

Source: sql.sh

My sql alter table

ALTER TABLE nom_table
DROP nom_colonne

-1

Source: sql.sh

Similar codes

0 vote325 views1 answer
Install sql server in ubuntu 20.04
SQL
2 votes322 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes300 views1 answer
What is having clause
SQL
0 vote338 views1 answer
Sql server information_schema temp tables
SQL
0 vote356 views1 answer
SQL FROM-Klausel
SQL
1 vote322 views1 answer
Postgres set column equal to another
SQL
0 vote343 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote339 views1 answer
Grant privileges of databse to user
SQL
1 vote344 views1 answer
Mysql alter decimal precision
SQL
1 vote306 views1 answer
How to select random rows from table
SQL

Share