/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 vote243 views1 answer
How to map sql column to custom names
SQL
4 votes235 views3 answers
Postgres set default value
SQL
1 vote224 views1 answer
Error code 1055
SQL
2 votes206 views1 answer
Oracle sql drop column if exists
SQL
1 vote234 views1 answer
Query for all indexes in table postgres
SQL
0 vote261 views1 answer
Virtuoso sql query tutorial
SQL
0 vote228 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote211 views1 answer
Hive batch drop table
SQL
2 votes224 views2 answers
How to rename column name in sql server using query
SQL
0 vote210 views2 answers
Sql select inside select
SQL

Share