[sql] table creating practice

Viewer

copydownloadembedprintName: table creating practice
  1. CREATE TABLE `Authors` (
  2.         `name` VARCHAR(200) NOT NULL,
  3.         `surname` VARCHAR(200) NOT NULL,
  4.         `age` INT NOT NULL,
  5.         PRIMARY KEY (`name`,`surname`,`age`)
  6. );
  7.  
  8.  
  9. INSERT INTO TABLE ('name','surname','age')
  10. VALUES  ('Mathin','Akhundlu','33');
  11.  
  12.  
  13. SELECT *FROM Authors;

Editor

You can edit this paste and save as new: