Advertisement
Guest User

Untitled

a guest
Jan 8th, 2014
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.62 KB | None | 0 0
  1. mysql> SELECT * FROM Customers;
  2. +------------+-----------+----------+-------------------+------------------------+
  3. | CustomerId | FirstName | LastName | Email | Address |
  4. +------------+-----------+----------+-------------------+------------------------+
  5. | 1 | Jessie | James | james@yahoo.com | Str. Lunii, Nr. 9 |
  6. | 2 | Marian | Radu | raduX@yahoo.com | Str. Rapsodiei, Nr. 91 |
  7. | 3 | Graur | Valeriu | gv@yahoo.com | Str. Marti, Nr. 12 |
  8. | 4 | Ioane | Ioan | iioan@yahoo.com | Str. Cometei, Nr. 19 |
  9. | 5 | Granicer | Tudor | gtudor@yahoo.com | Str. Tomis, Nr. 651 |
  10. +------------+-----------+----------+-------------------+------------------------+
  11. 5 rows in set (0.00 sec)
  12.  
  13. mysql> SELECT * FROM Orders;
  14. +---------+------------+----------+----------+------------+
  15. | OrderId | Date | Quantity | TotalDue | CustomerId |
  16. +---------+------------+----------+----------+------------+
  17. | 1 | 2014-01-09 | 10 | 150 | 2 |
  18. | 2 | 2014-01-09 | 5 | 360 | 5 |
  19. | 3 | 2014-01-09 | 1 | 160 | 6 |
  20. +---------+------------+----------+----------+------------+
  21. 3 rows in set (0.00 sec)
  22.  
  23. mysql> DELETE FROM Orders WHERE OrderId=3
  24. -> ;
  25. Query OK, 1 row affected (0.00 sec)
  26.  
  27. mysql> DELETE FROM Orders WHERE OrderId=3
  28. ->
  29. -> ;
  30. Query OK, 0 rows affected (0.00 sec)
  31.  
  32. mysql> SELECT * FROM Orders;
  33. +---------+------------+----------+----------+------------+
  34. | OrderId | Date | Quantity | TotalDue | CustomerId |
  35. +---------+------------+----------+----------+------------+
  36. | 1 | 2014-01-09 | 10 | 150 | 2 |
  37. | 2 | 2014-01-09 | 5 | 360 | 5 |
  38. +---------+------------+----------+----------+------------+
  39. 2 rows in set (0.00 sec)
  40.  
  41. mysql> ALTER TABLE Orders Engine=InnoDB;
  42. Query OK, 2 rows affected (0.13 sec)
  43. Records: 2 Duplicates: 0 Warnings: 0
  44.  
  45. mysql> ALTER TABLE Customers Engine=InnoDB;
  46. Query OK, 5 rows affected (0.05 sec)
  47. Records: 5 Duplicates: 0 Warnings: 0
  48.  
  49. mysql> SELECT * FROM Orders;
  50. +---------+------------+----------+----------+------------+
  51. | OrderId | Date | Quantity | TotalDue | CustomerId |
  52. +---------+------------+----------+----------+------------+
  53. | 1 | 2014-01-09 | 10 | 150 | 2 |
  54. | 2 | 2014-01-09 | 5 | 360 | 5 |
  55. +---------+------------+----------+----------+------------+
  56. 2 rows in set (0.00 sec)
  57.  
  58. mysql> SELECT * FROM Customers;
  59. +------------+-----------+----------+-------------------+------------------------+
  60. | CustomerId | FirstName | LastName | Email | Address |
  61. +------------+-----------+----------+-------------------+------------------------+
  62. | 1 | Jessie | James | james@yahoo.com | Str. Lunii, Nr. 9 |
  63. | 2 | Marian | Radu | raduX@yahoo.com | Str. Rapsodiei, Nr. 91 |
  64. | 3 | Graur | Valeriu | gv@yahoo.com | Str. Marti, Nr. 12 |
  65. | 4 | Ioane | Ioan | iioan@yahoo.com | Str. Cometei, Nr. 19 |
  66. | 5 | Granicer | Tudor | gtudor@yahoo.com | Str. Tomis, Nr. 651 |
  67. +------------+-----------+----------+-------------------+------------------------+
  68. 5 rows in set (0.00 sec)
  69.  
  70. mysql> INSERT INTO Orders (Date, Quantity, TotalDue, CustomerId) VALUES(NOW(), 3, 400, 3);
  71. Query OK, 1 row affected, 1 warning (0.05 sec)
  72.  
  73. mysql> SELECT * FROM Orders;
  74. +---------+------------+----------+----------+------------+
  75. | OrderId | Date | Quantity | TotalDue | CustomerId |
  76. +---------+------------+----------+----------+------------+
  77. | 1 | 2014-01-09 | 10 | 150 | 2 |
  78. | 2 | 2014-01-09 | 5 | 360 | 5 |
  79. | 4 | 2014-01-09 | 3 | 400 | 3 |
  80. +---------+------------+----------+----------+------------+
  81. 3 rows in set (0.00 sec)
  82.  
  83. mysql> INSERT INTO Orders (Date, Quantity, TotalDue, CustomerId) VALUES(NOW(), 6, 450, 9);
  84. Query OK, 1 row affected, 1 warning (0.01 sec)
  85.  
  86. mysql> SELECT * FROM Orders;
  87. +---------+------------+----------+----------+------------+
  88. | OrderId | Date | Quantity | TotalDue | CustomerId |
  89. +---------+------------+----------+----------+------------+
  90. | 1 | 2014-01-09 | 10 | 150 | 2 |
  91. | 2 | 2014-01-09 | 5 | 360 | 5 |
  92. | 4 | 2014-01-09 | 3 | 400 | 3 |
  93. | 5 | 2014-01-09 | 6 | 450 | 9 |
  94. +---------+------------+----------+----------+------------+
  95. 4 rows in set (0.01 sec)
  96.  
  97. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement