/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

3 votes306 views3 answers
Stop mysql ubuntu
SQL
0 vote313 views1 answer
Bitmap join index
SQL
0 vote284 views1 answer
Mysql coonect sample code
SQL
7 votes291 views2 answers
Show size database mysql
SQL
0 vote289 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote291 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote329 views1 answer
Postgres - Login and connect as default user
SQL
1 vote299 views1 answer
Replace all numbers in mysql
SQL
-3 votes312 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
15 votes527 views2 answers
How to sort names in alphabetical order in sql
SQL

Share