Answers for "add two columns in mysql"

SQL
9

add new column to the table mysql

ALTER TABLE `TABLE_NAME` 
	ADD `COLUMN_NAME` VARCHAR(50) NULL
    AFTER `COLUMN_NAME_AFTER`;
Posted by: Guest on August-20-2020
4

create column mysql terminal

alter table icecream add column flavor varchar (20) ;
Posted by: Guest on April-08-2020
0

how to add more columns to a table in mysql

CREATE TABLE IF NOT EXISTS vendors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);
ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;
Posted by: Guest on March-16-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language