/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 vote349 views4 answers
How to connect form to database
SQL
0 vote372 views2 answers
While mysql
SQL
6 votes351 views3 answers
Date_trunc postgres
SQL
9 votes335 views2 answers
Oracle all tables in schema
SQL
1 vote375 views1 answer
Dropping a constraint in ms sql
SQL
0 vote373 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote294 views1 answer
Sql count how many times a value appears
SQL
1 vote591 views1 answer
Postgres convert text to number
SQL
1 vote347 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote373 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL

Share