/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 vote282 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote269 views1 answer
How to get table current identity value in sql server
SQL
0 vote267 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote283 views1 answer
Oracle for loop on list
SQL
0 vote232 views1 answer
Flask_sqlalchemy install
SQL
28 votes253 views4 answers
Mysql delete database
SQL
0 vote283 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
1 vote275 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote272 views1 answer
Sql create text column limited values
SQL
1 vote262 views1 answer
How to select random rows from table
SQL

Share