/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 vote167 views1 answer
Set column in all row mysql
SQL
6 votes189 views2 answers
Mysqldump password in file
SQL
0 vote255 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote193 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
5 votes182 views1 answer
Sql use database
SQL
0 vote172 views1 answer
Sql DATE = GETDATE()
SQL
-1 vote237 views3 answers
PS5
SQL
1 vote213 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote128 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
17 votes181 views3 answers
How to change a collumn name in sql
SQL

Share