/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 vote109 views1 answer
Write SQL in ruby on rails
SQL
2 votes99 views2 answers
Compare date mysql
SQL
19 votes103 views6 answers
Sql create table
SQL
0 vote98 views1 answer
Kotlin sqlite delete row
SQL
0 vote112 views1 answer
How to close external sql connection in laravel
SQL
0 vote106 views1 answer
Wordpress database query change url
SQL
1 vote111 views1 answer
Type int in mysql maxlenght
SQL
-1 vote124 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote155 views1 answer
Oracle db get table sizes
SQL
1 vote125 views1 answer
How to get previous year from sysdate in oracle
SQL

Share