/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

2 votes279 views1 answer
Sqlplus clear screen
SQL
0 vote264 views3 answers
Query string not ending with with vowels
SQL
16 votes277 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
1 vote258 views1 answer
Last 6 months postgresql
SQL
0 vote256 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote274 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote262 views1 answer
Python connect microsoft sql server
SQL
0 vote204 views1 answer
Sqlalchemy existing database
SQL
1 vote258 views3 answers
Reset sql primary key
SQL
0 vote298 views1 answer
Site:av.ru "files"
SQL

Share