In order to add the phone column to the candidates table, you use the following statement: ALTER TABLE candidates The following statement creates a new table named candidates: CREATE TABLE candidates ( Please check it out the next section for references. If you want to add multiple columns to an existing table using a single statement, you use the following syntax: ALTER TABLE table_nameĭifferent database systems support the ALTER TABLE ADD COLUMN statement with some minor variances. The typical syntax of the column_definition is as follows: column_name data_type constraint
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |