/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

1 vote206 views1 answer
Backup mysql data only
SQL
0 vote214 views1 answer
Mysql case when null
SQL
0 vote198 views1 answer
Get employees if not contains in sql
SQL
0 vote205 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote205 views1 answer
Postgresql isnull with max
SQL
8 votes201 views2 answers
Python simple connect to mysql
SQL
1 vote193 views1 answer
Oracle create program if no exists
SQL
1 vote200 views2 answers
Mysql select tables with name like
SQL
0 vote211 views1 answer
Mysql c commands
SQL
31 votes210 views3 answers
SQL Server change column data type
SQL

Share