/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 vote339 views1 answer
Sql case when exists in another table
SQL
0 vote363 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote343 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote336 views1 answer
Mssql check if date is greater than today
SQL
2 votes343 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote376 views1 answer
Oracle insert single quote in string
SQL
0 vote337 views2 answers
Reseed sql identity
SQL
3 votes375 views1 answer
Select count from table mysql
SQL
49 votes389 views6 answers
Alter table add column
SQL
1 vote367 views2 answers
Oracle list service names
SQL

Share