mysql set column code example

Example 1: how remove column in mysql

ALTER TABLE "table_name" DROP "column_name";

Example 2: sql server add column

ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;

Example 3: mysql update add to existing value

mysql> UPDATE tableName SET sometotal = sometotal+10 WHERE Id = 4;

Example 4: change column in mysql

#Alter is used
#alter table TableName change CurrentColumnName NewColumnName Specification(size);
alter table TableName change name firstname varchar(30);

Tags:

Csharp Example

Related