/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 vote148 views1 answer
Mysql match in serialized data
SQL
0 vote146 views4 answers
Restart MySQL
SQL
0 vote155 views2 answers
How to create a table from another table in sql derby
SQL
0 vote155 views1 answer
Apt install sql server
SQL
0 vote150 views1 answer
Sql pivot without aggregate
SQL
5 votes183 views1 answer
Migrate sql table another database
SQL
1 vote160 views1 answer
Rename table column name in mysql
SQL
0 vote158 views1 answer
Changing name of column and datatype in sql
SQL
17 votes148 views6 answers
Current date in sql
SQL
0 vote140 views1 answer
Sqlite3 now
SQL

Share