/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

6 votes194 views1 answer
Allsource oracle
SQL
4 votes246 views1 answer
Postgresql change default value
SQL
3 votes183 views1 answer
Null sql
SQL
0 vote188 views1 answer
Oracle change password expiration policy
SQL
2 votes177 views1 answer
Sql find missing values between two tables
SQL
10 votes226 views4 answers
Else if mysql
SQL
0 vote177 views1 answer
Sql server select top 2 of each group
SQL
0 vote186 views3 answers
How to run sql query
SQL
0 vote223 views2 answers
How to type a blank discord messgae
SQL
3 votes182 views1 answer
Stpop start psql server
SQL

Share