$pdo
=
'PDO instance'
$int
=
1
#1
|
PDO::exec
|
("CREATE TABLE fruit (name, color, calories); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)")
|
#2
|
PDO::exec
|
("CREATE TABLE fruit (name, color, calories); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250); UPDATE fruit SET name = 'pear' WHERE name = 'apple'")
|
#3
|
PDO::exec
|
("CREATE TABLE bad ()")
|