PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Alok Mohanty   multipleInsert   ???   Download  
File: ???
Role: Configuration script
Content typex: text/plain
Description: SQL File
Class: multipleInsert
Mutiple record Insertion in to a single table
Author: By
Last change:
Date: 22 years ago
Size: 727 bytes
 

Contents

Class file image Download
CREATE TABLE `student`
(
`std_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`std_name` CHAR( 50 ) ,
`std_age` INT
);

INSERT INTO `student` ( `std_id` , `std_name` , `std_age` ) VALUES ('', 'Proge Gran ', '27');
INSERT INTO `student` ( `std_id` , `std_name` , `std_age` ) VALUES ('', 'Alya Ruiz', '28');
INSERT INTO `student` ( `std_id` , `std_name` , `std_age` ) VALUES ('', 'Luee Victor', '29');
INSERT INTO `student` ( `std_id` , `std_name` , `std_age` ) VALUES ('', 'Spencer Lee', '30');
INSERT INTO `student` ( `std_id` , `std_name` , `std_age` ) VALUES ('', 'Mike Abraham', '31');



CREATE TABLE `student_dummy`
(
`sd_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` CHAR( 50 ) ,
`age` INT
);