PROGRAMMING

 
REMEMBERS




Last update:   29-10-2021

Create table

 
CREATE TABLE mytable (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    myname VARCHAR(30)    
)
Get Table Structure    (2/2)

Get table structure

 
SHOW CREATE TABLE mytable;

-- result:
CREATE TABLE `mytable` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `myname` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
... 2 lines
 

Questions    
Add column

        A B C D E F
🔔
1/2