100 % Practical SQL: MySql by Prabagaran P

Author:Prabagaran P [P, Prabagaran]
Language: eng
Format: epub
Publisher: P Prabagaran
Published: 2016-07-05T22:00:00+00:00

CREATE TABLE `softwarecompany`.`sw` (

`id` INT NOT NULL,

`pos` VARCHAR(45) NULL,

`sname` VARCHAR(45) NULL,

PRIMARY KEY (`id`));

------------------------------------------------------------------------------------------------------------------------------

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('111', 'man', 'a');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('112', 'emp', 'b');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('113', 'emp', 'c');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('114', 'emp', 'd');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('115', 'mar', 'e');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('116', 'hr', 'f');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('117', 'eng', 'g');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('118', 'mar', 'h');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('119', 'emp', 'i');

INSERT INTO `softwarecompany`.`sw` (`id`, `pos`, `sname`) VALUES ('120', 'hr', 'j');

------------------------------------------------------------------------------------------------------------------------------SELECT * FROM softwarecompany.sw;

------------------------------------------------------------------------------------------------------------------------------

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.