quick links

Create Table, DROP Table, ALTER Table

Create Table

  • CREATE TABLE MyGuests(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50))

DROP Table

  • DROP TABLE MyGuests

ALTER Table

  • ALTER TABLE table_name MODIFY COLUMN column_name datatype
  • ALTER TABLE table_name DROP COLUMN column_name
  • ALTER TABLE table_name ADD COLUMN column_name datatype
 

About Us

Joomla Web Solution

We love working with PHP, HTML5, CSS3, jQuery and the most-loved content management framework in the world, Joomla!

LIKE US ON FACEBOOK