API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 9th, 2019
120
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.15 KB | None | 0 0
raw download clone embed print report
  1. mysql> CREATE TABLE Animal (
  2. -> id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  3. -> espece VARCHAR(40) NOT NULL,
  4. -> sexe CHAR(1),
  5. -> date_naissance DATETIME NOT NULL,
  6. -> nom VARCHAR(30),
  7. -> commentaires TEXT,
  8. -> PRIMARY KEY (id)
  9. -> )
  10. -> ENGINE=INNODB;
  11. Query OK, 0 rows affected (0.05 sec)
  12.  
  13. mysql> commentaires TEXT,^C
  14. mysql> drop animal
  15. -> ;
  16. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'animal' at line 1
  17. mysql> DROP TABLE Animal
  18. -> ;
  19. Query OK, 0 rows affected (0.03 sec)
  20.  
  21. mysql> CREATE TABLE IF NOT EXISTS Animal (
  22. -> id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  23. -> espece VARCHAR(40) NOT NULL,
  24. -> sexe CHAR(1),
  25. -> date_naissance DATETIME NOT NULL,
  26. -> nom VARCHAR(30),
  27. -> commentaires TEXT,
  28. -> PRIMARY KEY (id)
  29. -> )
  30. -> ENGINE=INNODB;
  31. Query OK, 0 rows affected (0.04 sec)
  32.  
  33. mysql> DESCRIBE Animal;
  34. +----------------+----------------------+------+-----+---------+----------------+
  35. | Field | Type | Null | Key | Default | Extra |
  36. +----------------+----------------------+------+-----+---------+----------------+
  37. | id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
  38. | espece | varchar(40) | NO | | NULL | |
  39. | sexe | char(1) | YES | | NULL | |
  40. | date_naissance | datetime | NO | | NULL | |
  41. | nom | varchar(30) | YES | | NULL | |
  42. | commentaires | text | YES | | NULL | |
  43. +----------------+----------------------+------+-----+---------+----------------+
  44. 6 rows in set (0.00 sec)
  45.  
  46. mysql> DROP TABLE Animal;
  47. Query OK, 0 rows affected (0.03 sec)
  48.  
  49. mysql> DROP TABLE Animal;^C
  50. mysql> CREATE TABLE IF NOT EXISTS Animal (
  51. -> id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  52. -> espece VARCHAR(40) NOT NULL,
  53. -> sexe CHAR(1),
  54. -> date_naissance DATETIME NOT NULL,
  55. -> nom VARCHAR(30),
  56. -> commentaires TEXT,
  57. -> PRIMARY KEY (id)
  58. -> )
  59. -> ENGINE=INNODB;
  60. Query OK, 0 rows affected (0.05 sec)
  61.  
  62. mysql>
  63. mysql>
  64. mysql> DESCRIBE Animal;
  65. +----------------+----------------------+------+-----+---------+----------------+
  66. | Field | Type | Null | Key | Default | Extra |
  67. +----------------+----------------------+------+-----+---------+----------------+
  68. | id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
  69. | espece | varchar(40) | NO | | NULL | |
  70. | sexe | char(1) | YES | | NULL | |
  71. | date_naissance | datetime | NO | | NULL | |
  72. | nom | varchar(30) | YES | | NULL | |
  73. | commentaires | text | YES | | NULL | |
  74. +----------------+----------------------+------+-----+---------+----------------+
  75. 6 rows in set (0.00 sec)
  76.  
  77. mysql> SHOW tables;
  78. +-------------------+
  79. | Tables_in_elevage |
  80. +-------------------+
  81. | animal |
  82. +-------------------+
  83. 1 row in set (0.00 sec)
  84.  
  85. mysql> CREATE TABLE Test_tuto (
  86. -> id INT NOT NULL,
  87. -> nom VARCHAR(10) NOT NULL,
  88. -> PRIMARY KEY(id)
  89. -> );
  90. Query OK, 0 rows affected (0.04 sec)
  91.  
  92. mysql> DESCRIBE Test_tuto
  93. -> ;
  94. +-------+-------------+------+-----+---------+-------+
  95. | Field | Type | Null | Key | Default | Extra |
  96. +-------+-------------+------+-----+---------+-------+
  97. | id | int(11) | NO | PRI | NULL | |
  98. | nom | varchar(10) | NO | | NULL | |
  99. +-------+-------------+------+-----+---------+-------+
  100. 2 rows in set (0.00 sec)
  101.  
  102. mysql> ALTER TABLE Test_tuto
  103. -> ADD COLUMN date_insertion DATE NOT NULL;
  104. Query OK, 0 rows affected (0.06 sec)
  105. Records: 0 Duplicates: 0 Warnings: 0
  106.  
  107. mysql> DESCRIBE Test_tuto
  108. -> ;
  109. +----------------+-------------+------+-----+---------+-------+
  110. | Field | Type | Null | Key | Default | Extra |
  111. +----------------+-------------+------+-----+---------+-------+
  112. | id | int(11) | NO | PRI | NULL | |
  113. | nom | varchar(10) | NO | | NULL | |
  114. | date_insertion | date | NO | | NULL | |
  115. +----------------+-------------+------+-----+---------+-------+
  116. 3 rows in set (0.00 sec)
  117.  
  118. mysql> drop table if exists Test_tuto
  119. -> ;
  120. Query OK, 0 rows affected (0.02 sec)
  121.  
  122. mysql> DESCRIBE Test_tuto
  123. -> ;
  124. ERROR 1146 (42S02): Table 'elevage.test_tuto' doesn't exist
  125. mysql> CREATE TABLE IF NOT EXISTS Test_tuto (
  126. -> id INT NOT NULL,
  127. -> nom VARCHAR(10) NOT NULL,
  128. -> PRIMARY KEY(id)
  129. -> );
  130. Query OK, 0 rows affected (0.04 sec)
  131.  
  132. mysql> ENGINE=INNODB;
  133. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=INNODB' at line 1
  134. mysql> CREATE TABLE IF NOT EXISTS Test_tuto (
  135. -> id INT NOT NULL,
  136. -> nom VARCHAR(10) NOT NULL,
  137. -> PRIMARY KEY(id)
  138. -> )
  139. -> ENGINE=INNODB;
  140. Query OK, 0 rows affected, 1 warning (0.01 sec)
  141.  
  142. mysql> ALTER TABLE Test_tuto
  143. -> ADD COLUMN date_insertion DATE NOT NULL;
  144. Query OK, 0 rows affected (0.06 sec)
  145. Records: 0 Duplicates: 0 Warnings: 0
  146.  
  147. mysql> ADD COLUMN date_insertion DATE NOT NULL;^C
  148. mysql> DESCRIBE Test_tuto
  149. -> ;
  150. +----------------+-------------+------+-----+---------+-------+
  151. | Field | Type | Null | Key | Default | Extra |
  152. +----------------+-------------+------+-----+---------+-------+
  153. | id | int(11) | NO | PRI | NULL | |
  154. | nom | varchar(10) | NO | | NULL | |
  155. | date_insertion | date | NO | | NULL | |
  156. +----------------+-------------+------+-----+---------+-------+
  157. 3 rows in set (0.00 sec)
  158.  
  159. mysql> ALTER TABLE Test_tuto
  160. -> DROP COLUMN date_insertion;
  161. Query OK, 0 rows affected (0.06 sec)
  162. Records: 0 Duplicates: 0 Warnings: 0
  163.  
  164. mysql> ALTER TABLE Test_tuto
  165. -> CHANGE nom prenom VARCHAR(10) NOT NULL;
  166. Query OK, 0 rows affected (0.01 sec)
  167. Records: 0 Duplicates: 0 Warnings: 0
  168.  
  169. mysql> DESCRIBE Test_tuto
  170. -> ;
  171. +--------+-------------+------+-----+---------+-------+
  172. | Field | Type | Null | Key | Default | Extra |
  173. +--------+-------------+------+-----+---------+-------+
  174. | id | int(11) | NO | PRI | NULL | |
  175. | prenom | varchar(10) | NO | | NULL | |
  176. +--------+-------------+------+-----+---------+-------+
  177. 2 rows in set (0.00 sec)
  178.  
  179. mysql> ALTER TABLE Test_tuto
  180. -> MODIFY prenom VARCHAR(10) NOT NULL DEFAULT("Jimmy");
  181. Query OK, 0 rows affected (0.01 sec)
  182. Records: 0 Duplicates: 0 Warnings: 0
  183.  
  184. mysql> ALTER TABLE Test_tuto
  185. -> DESCRIBE Test_tuto
  186. -> ;
  187. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESCRIBE Test_tuto' at line 2
  188. mysql> DESCRIBE Test_tuto
  189. -> ;
  190. +--------+-------------+------+-----+-----------------+-------------------+
  191. | Field | Type | Null | Key | Default | Extra |
  192. +--------+-------------+------+-----+-----------------+-------------------+
  193. | id | int(11) | NO | PRI | NULL | |
  194. | prenom | varchar(10) | NO | | _cp850\'Jimmy\' | DEFAULT_GENERATED |
  195. +--------+-------------+------+-----+-----------------+-------------------+
  196. 2 rows in set (0.00 sec)
  197.  
  198. mysql> INSERT INTO Animal
  199. -> VALUES(1, 'chien', 'M', '2010-04-05 13:43:00', 'Mordille beaucoup', 'Rox');
  200. Query OK, 1 row affected (0.01 sec)
  201.  
  202. mysql> SELECT * FROM Test_tuto
  203. ->
  204. -> ;
  205. Empty set (0.00 sec)
  206.  
  207. mysql> SELECT * FROM Animal;
  208. +----+--------+------+---------------------+-------------------+--------------+
  209. | id | espece | sexe | date_naissance | nom | commentaires |
  210. +----+--------+------+---------------------+-------------------+--------------+
  211. | 1 | chien | M | 2010-04-05 13:43:00 | Mordille beaucoup | Rox |
  212. +----+--------+------+---------------------+-------------------+--------------+
  213. 1 row in set (0.00 sec)
  214.  
  215. mysql> INSERT INTO Animal
  216. -> VALUES (2, 'chat', NULL, '2010-03-24 02:23:00', NULL, "Roucky");
  217. Query OK, 1 row affected (0.00 sec)
  218.  
  219. mysql> INSERT INTO Animal
  220. -> VALUES (NULL , 'chat', 'F', '2010-09-13 15:02:00', NULL, 'Schtroumpfette');
  221. Query OK, 1 row affected (0.01 sec)
  222.  
  223. mysql> SELECT * FROM Animal;
  224. +----+--------+------+---------------------+-------------------+----------------+
  225. | id | espece | sexe | date_naissance | nom | commentaires |
  226. +----+--------+------+---------------------+-------------------+----------------+
  227. | 1 | chien | M | 2010-04-05 13:43:00 | Mordille beaucoup | Rox |
  228. | 2 | chat | NULL | 2010-03-24 02:23:00 | NULL | Roucky |
  229. | 3 | chat | F | 2010-09-13 15:02:00 | NULL | Schtroumpfette |
  230. +----+--------+------+---------------------+-------------------+----------------+
  231. 3 rows in set (0.00 sec)
  232.  
  233. mysql> INSERT INTO Animal
  234. -> VALUES(NULL, 'chien', 'M', '2019-12-09 14:20:00', NULL, 'GPADID2NON');
  235. Query OK, 1 row affected (0.00 sec)
  236.  
  237. mysql> SELECT * FROM Animal;
  238. +----+--------+------+---------------------+-------------------+----------------+
  239. | id | espece | sexe | date_naissance | nom | commentaires |
  240. +----+--------+------+---------------------+-------------------+----------------+
  241. | 1 | chien | M | 2010-04-05 13:43:00 | Mordille beaucoup | Rox |
  242. | 2 | chat | NULL | 2010-03-24 02:23:00 | NULL | Roucky |
  243. | 3 | chat | F | 2010-09-13 15:02:00 | NULL | Schtroumpfette |
  244. | 4 | chien | M | 2019-12-09 14:20:00 | NULL | GPADID2NON |
  245. +----+--------+------+---------------------+-------------------+----------------+
  246. 4 rows in set (0.00 sec)
  247.  
  248. mysql> SELECT espece FROM Animal;
  249. +--------+
  250. | espece |
  251. +--------+
  252. | chien |
  253. | chat |
  254. | chat |
  255. | chien |
  256. +--------+
  257. 4 rows in set (0.00 sec)
  258.  
  259. mysql> SELECT espece, nom from Animal;
  260. +--------+-------------------+
  261. | espece | nom |
  262. +--------+-------------------+
  263. | chien | Mordille beaucoup |
  264. | chat | NULL |
  265. | chat | NULL |
  266. | chien | NULL |
  267. +--------+-------------------+
  268. 4 rows in set (0.00 sec)
  269.  
  270. mysql> SELECT espece from Animal LIMIT 1;
  271. +--------+
  272. | espece |
  273. +--------+
  274. | chien |
  275. +--------+
  276. 1 row in set (0.00 sec)
  277.  
  278. mysql> SELECT DISTINCT espece FROM Animal;
  279. +--------+
  280. | espece |
  281. +--------+
  282. | chien |
  283. | chat |
  284. +--------+
  285. 2 rows in set (0.00 sec)
  286.  
  287. mysql> SELECT count(*) FROM Animal;
  288. +----------+
  289. | count(*) |
  290. +----------+
  291. | 4 |
  292. +----------+
  293. 1 row in set (0.00 sec)
  294.  
  295. mysql> SELECT count(*) from Animal WHERE espece = "chien";
  296. +----------+
  297. | count(*) |
  298. +----------+
  299. | 2 |
  300. +----------+
  301. 1 row in set (0.00 sec)
  302.  
  303. mysql> SELECT * from Animal WHERE espece = "chien";
  304. +----+--------+------+---------------------+-------------------+--------------+
  305. | id | espece | sexe | date_naissance | nom | commentaires |
  306. +----+--------+------+---------------------+-------------------+--------------+
  307. | 1 | chien | M | 2010-04-05 13:43:00 | Mordille beaucoup | Rox |
  308. | 4 | chien | M | 2019-12-09 14:20:00 | NULL | GPADID2NON |
  309. +----+--------+------+---------------------+-------------------+--------------+
  310. 2 rows in set (0.00 sec)
  311.  
  312. mysql> SELECT * from Animal WHERE espece = "chat" LIMIT 1;
  313. +----+--------+------+---------------------+------+--------------+
  314. | id | espece | sexe | date_naissance | nom | commentaires |
  315. +----+--------+------+---------------------+------+--------------+
  316. | 2 | chat | NULL | 2010-03-24 02:23:00 | NULL | Roucky |
  317. +----+--------+------+---------------------+------+--------------+
  318. 1 row in set (0.00 sec)
  319.  
  320. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!