BUPgXHHp

1You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT INTO `tsv` (`Id`,`Date`,`Quantity`) VALUES( `1`,`2009-07-01`,`174`, `1`,`' at line 9
2	
3CREATE TABLE IF NOT EXISTS `tsv` 
4( `_id` int(11) NOT NULL AUTO_INCREMENT, 
5`Id` text NOT NULL, `Date` text NOT NULL, 
6`Quantity` text NOT NULL, PRIMARY KEY (`_id`) ) 
7ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ; 
8INSERT INTO `tsv` (`Id`,`Date`,`Quantity`) 
9VALUES( `1`,`2009-07-01`,`174`, `1`,`2009-07-02`,`96`, 
10`1`,`2009-07-03`,`271`, `1`,`2009-07-04`,`335`, `1`,
11`2009-07-06`,`72`, `1`,`2009-07-07`,`246`, `1`,`2009-07-08`,
12`93`, `1`,`2009-07-09`,`191`, `1`,`2009-07-10`,`136`, `1`,
13`2009-07-11`,`200`, `1`,`2009-07-13`,`151`, `1`,`2009-07-15`,`99`);
14	
15// Create connection
16$conn = new mysqli($servername, $username, $password, $dbname);
17
18// Check connection
19if ($conn->connect_error) {
20    die("Connection failed: " . $conn->connect_error);
21} 
22echo "Connected successfully";
23if ($conn->query($sqlContent) === TRUE) {
24    echo "New record created successfully";
25} else {
26    echo "Error: " . $sqlContent . "<br/>" . $conn->error;
27}
28
29$conn->close();
30	
31CREATE TABLE IF NOT EXISTS `tsv` 
32( `_id` int(11) NOT NULL AUTO_INCREMENT, 
33`Id` text NOT NULL, `Date` text NOT NULL, 
34`Quantity` text NOT NULL, PRIMARY KEY (`_id`) ) 
35ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ; 
36
37INSERT INTO `tsv` (`Id`,`Date`,`Quantity`) 
38VALUES('1','2009-07-01','174'), 
39      ('1','2009-07-02','96'),
40      ('1','2009-07-03','271'), ... and so on
41	
42INSERT INTO `tsv` (`Date`,`Quantity`) 
43VALUES( `2009-07-01`,`174`), (`2009-07-02`,`96`), 
44(`2009-07-03`,`271`), (`2009-07-04`,`335`), 
45(`2009-07-06`,`72`), (`2009-07-07`,`246`), (`2009-07-08`,
46`93`), (,`2009-07-09`,`191`), (`2009-07-10`,`136`), 
47(`2009-07-11`,`200`), (`2009-07-13`,`151`), (`2009-07-15`,`99`);