/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

8 votes298 views1 answer
Ltrim sql
SQL
0 vote296 views1 answer
How to install postgresql on wsl
SQL
1 vote290 views1 answer
Vagrant mysql downgrade version
SQL
8 votes307 views4 answers
Reset SQL auto increment
SQL
0 vote271 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote260 views1 answer
Select other columns with distinct
SQL
2 votes278 views1 answer
Sql server check for value in multiple columns
SQL
14 votes283 views1 answer
Sql value of string
SQL
0 vote279 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
8 votes296 views1 answer
Oracle current date plus 1 month
SQL

Share