Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT * FROM Customers;
- +------------+-----------+----------+-------------------+------------------------+
- | CustomerId | FirstName | LastName | Email | Address |
- +------------+-----------+----------+-------------------+------------------------+
- | 1 | Jessie | James | james@yahoo.com | Str. Lunii, Nr. 9 |
- | 2 | Marian | Radu | raduX@yahoo.com | Str. Rapsodiei, Nr. 91 |
- | 3 | Graur | Valeriu | gv@yahoo.com | Str. Marti, Nr. 12 |
- | 4 | Ioane | Ioan | iioan@yahoo.com | Str. Cometei, Nr. 19 |
- | 5 | Granicer | Tudor | gtudor@yahoo.com | Str. Tomis, Nr. 651 |
- +------------+-----------+----------+-------------------+------------------------+
- 5 rows in set (0.00 sec)
- mysql> SELECT * FROM Orders;
- +---------+------------+----------+----------+------------+
- | OrderId | Date | Quantity | TotalDue | CustomerId |
- +---------+------------+----------+----------+------------+
- | 1 | 2014-01-09 | 10 | 150 | 2 |
- | 2 | 2014-01-09 | 5 | 360 | 5 |
- | 3 | 2014-01-09 | 1 | 160 | 6 |
- +---------+------------+----------+----------+------------+
- 3 rows in set (0.00 sec)
- mysql> DELETE FROM Orders WHERE OrderId=3
- -> ;
- Query OK, 1 row affected (0.00 sec)
- mysql> DELETE FROM Orders WHERE OrderId=3
- ->
- -> ;
- Query OK, 0 rows affected (0.00 sec)
- mysql> SELECT * FROM Orders;
- +---------+------------+----------+----------+------------+
- | OrderId | Date | Quantity | TotalDue | CustomerId |
- +---------+------------+----------+----------+------------+
- | 1 | 2014-01-09 | 10 | 150 | 2 |
- | 2 | 2014-01-09 | 5 | 360 | 5 |
- +---------+------------+----------+----------+------------+
- 2 rows in set (0.00 sec)
- mysql> ALTER TABLE Orders Engine=InnoDB;
- Query OK, 2 rows affected (0.13 sec)
- Records: 2 Duplicates: 0 Warnings: 0
- mysql> ALTER TABLE Customers Engine=InnoDB;
- Query OK, 5 rows affected (0.05 sec)
- Records: 5 Duplicates: 0 Warnings: 0
- mysql> SELECT * FROM Orders;
- +---------+------------+----------+----------+------------+
- | OrderId | Date | Quantity | TotalDue | CustomerId |
- +---------+------------+----------+----------+------------+
- | 1 | 2014-01-09 | 10 | 150 | 2 |
- | 2 | 2014-01-09 | 5 | 360 | 5 |
- +---------+------------+----------+----------+------------+
- 2 rows in set (0.00 sec)
- mysql> SELECT * FROM Customers;
- +------------+-----------+----------+-------------------+------------------------+
- | CustomerId | FirstName | LastName | Email | Address |
- +------------+-----------+----------+-------------------+------------------------+
- | 1 | Jessie | James | james@yahoo.com | Str. Lunii, Nr. 9 |
- | 2 | Marian | Radu | raduX@yahoo.com | Str. Rapsodiei, Nr. 91 |
- | 3 | Graur | Valeriu | gv@yahoo.com | Str. Marti, Nr. 12 |
- | 4 | Ioane | Ioan | iioan@yahoo.com | Str. Cometei, Nr. 19 |
- | 5 | Granicer | Tudor | gtudor@yahoo.com | Str. Tomis, Nr. 651 |
- +------------+-----------+----------+-------------------+------------------------+
- 5 rows in set (0.00 sec)
- mysql> INSERT INTO Orders (Date, Quantity, TotalDue, CustomerId) VALUES(NOW(), 3, 400, 3);
- Query OK, 1 row affected, 1 warning (0.05 sec)
- mysql> SELECT * FROM Orders;
- +---------+------------+----------+----------+------------+
- | OrderId | Date | Quantity | TotalDue | CustomerId |
- +---------+------------+----------+----------+------------+
- | 1 | 2014-01-09 | 10 | 150 | 2 |
- | 2 | 2014-01-09 | 5 | 360 | 5 |
- | 4 | 2014-01-09 | 3 | 400 | 3 |
- +---------+------------+----------+----------+------------+
- 3 rows in set (0.00 sec)
- mysql> INSERT INTO Orders (Date, Quantity, TotalDue, CustomerId) VALUES(NOW(), 6, 450, 9);
- Query OK, 1 row affected, 1 warning (0.01 sec)
- mysql> SELECT * FROM Orders;
- +---------+------------+----------+----------+------------+
- | OrderId | Date | Quantity | TotalDue | CustomerId |
- +---------+------------+----------+----------+------------+
- | 1 | 2014-01-09 | 10 | 150 | 2 |
- | 2 | 2014-01-09 | 5 | 360 | 5 |
- | 4 | 2014-01-09 | 3 | 400 | 3 |
- | 5 | 2014-01-09 | 6 | 450 | 9 |
- +---------+------------+----------+----------+------------+
- 4 rows in set (0.01 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement