/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

17 votes179 views3 answers
How to change a collumn name in sql
SQL
3 votes222 views1 answer
What is having
SQL
0 vote194 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote185 views1 answer
Like sql for second letter of the family name
SQL
3 votes199 views6 answers
Jwt laravel
SQL
11 votes243 views2 answers
Import mysql dump command line windows
SQL
34 votes224 views6 answers
Alter table add foreign key mysql
SQL
22 votes192 views4 answers
Mysql date format
SQL
0 vote182 views1 answer
Sql server concat null
SQL
1 vote136 views1 answer
Oracle boolean to varchar
SQL

Share