Home » Tag Archives: Mysql

Tag Archives: Mysql

How to ALTER table in SQL

ALTER a table in SQL Use the following commands for add,change,drop table fields in SQL. SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name> ALTER TABLE  `test` ADD  `test INT NOT NULL ALTER TABLE  `test` DROP `name` ALTER TABLE  `test` CHANGE  `name`  `student_name` INT( 11 ) NOT NULL

Read More »

mysql table alter query

We can use the following query for add new field to table. this types of queries are alter queries Syntax :ALTER `<table name>` ADD `<fieldname>` <type> <option> Example: ALTER TABLE `engine4_core_poll_societies` ADD `soc_admin` INT NOT NULL

Read More »