API tools faq
paste
Advertisement
Guest User

sadasdasdasdd

a guest
Feb 28th, 2020
201
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.21 KB | None | 0 0
raw download clone embed print report
  1. etting environment for using XAMPP for Windows.
  2. Uczeń@S11K4 c:\xampp
  3. # mysql -u root -p
  4. Enter password: ***
  5. Welcome to the MariaDB monitor. Commands end with ; or \g.
  6. Your MariaDB connection id is 2
  7. Server version: 10.1.39-MariaDB mariadb.org binary distribution
  8.  
  9. Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
  10.  
  11. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  12.  
  13. MariaDB [(none)]> shoqw databases
  14. -> ;
  15. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'shoqw databases' at line 1
  16. MariaDB [(none)]> show databasess;
  17. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'databasess' at line 1
  18. MariaDB [(none)]> show databases;
  19. +--------------------+
  20. | Database |
  21. +--------------------+
  22. | baaza |
  23. | baza1 |
  24. | bigos |
  25. | cos |
  26. | create |
  27. | firma |
  28. | gorecki |
  29. | information_schema |
  30. | kowalski |
  31. | ksiegarnia |
  32. | ksiengarnia |
  33. | lul |
  34. | mysql |
  35. | performance_schema |
  36. | phpmyadmin |
  37. | pierwsza |
  38. | rodzina |
  39. | siema |
  40. | szkola |
  41. | test |
  42. +--------------------+
  43. 20 rows in set (0.02 sec)
  44.  
  45. MariaDB [(none)]> use lul
  46. Database changed
  47. MariaDB [lul]> create table t;
  48. ERROR 1113 (42000): A table must have at least 1 column
  49. MariaDB [lul]> create table t
  50. -> (id int primary key ayto_increment,imie varchar(20) not NULL,nazwisko varchar(20) not NULL,adres varchar(20) not NULL,miejscowosc varchar(20) not NULL);
  51. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'imie varchar(20) not NULL,nazwisko varchar(20) not NULL,adres varchar(20) not NU' at line 2
  52. MariaDB [lul]> create table t;
  53. ERROR 1113 (42000): A table must have at least 1 column
  54. MariaDB [lul]> (id int primary key ayto_increment,
  55. -> imie varchar(20) not NULL,
  56. -> nazwisko varchar(20) not NULL,adres varchar(20) not NULL,miejscowosc varchar(20) not NULL);
  57. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'id int primary key ayto_increment,
  58. imie varchar(20) not NULL,
  59. nazwisko varchar(2' at line 1
  60. MariaDB [lul]> create table t;
  61. ERROR 1113 (42000): A table must have at least 1 column
  62. MariaDB [lul]> (id int primary key auto_increment,
  63. -> imie varchar(20) not NULL,
  64. -> nazwisko varchar(20) not NULL,adres varchar(20) not NULL,miejscowosc varchar(20) not NULL);
  65. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'id int primary key auto_increment,
  66. imie varchar(20) not NULL,
  67. nazwisko varchar(2' at line 1
  68. MariaDB [lul]> create table t (id int Primary Key auto_increment,imie varchar(20) not NULL,nazwisko varchar(20) not NULL,adres varchar(20) not NULL,miejscowosc varchar(20) not NULL);
  69. Query OK, 0 rows affected (0.04 sec)
  70.  
  71. MariaDB [lul]> describe t
  72. -> ;
  73. +-------------+-------------+------+-----+---------+----------------+
  74. | Field | Type | Null | Key | Default | Extra |
  75. +-------------+-------------+------+-----+---------+----------------+
  76. | id | int(11) | NO | PRI | NULL | auto_increment |
  77. | imie | varchar(20) | NO | | NULL | |
  78. | nazwisko | varchar(20) | NO | | NULL | |
  79. | adres | varchar(20) | NO | | NULL | |
  80. | miejscowosc | varchar(20) | NO | | NULL | |
  81. +-------------+-------------+------+-----+---------+----------------+
  82. 5 rows in set (0.01 sec)
  83.  
  84. MariaDB [lul]> add index t char (imie,nazwisko);
  85. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'add index t char (imie,nazwisko)' at line 1
  86. MariaDB [lul]> create index on t (imie,nazwisko);
  87. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'on t (imie,nazwisko)' at line 1
  88. MariaDB [lul]> create index index1 on t (imie,nazwisko);
  89. Query OK, 0 rows affected (0.01 sec)
  90. Records: 0 Duplicates: 0 Warnings: 0
  91.  
  92. MariaDB [lul]> show index;
  93. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
  94. MariaDB [lul]> show index on t;
  95. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'on t' at line 1
  96. MariaDB [lul]> show index1 on t;
  97. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'index1 on t' at line 1
  98. MariaDB [lul]> show index from t;
  99. +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  100. | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
  101. +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  102. | t | 0 | PRIMARY | 1 | id | A | 0 | NULL | NULL | | BTREE | | |
  103. | t | 1 | index1 | 1 | imie | A | 0 | NULL | NULL | | BTREE | | |
  104. | t | 1 | index1 | 2 | nazwisko | A | 0 | NULL | NULL | | BTREE | | |
  105. +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
  106. 3 rows in set (0.00 sec)
  107.  
  108. MariaDB [lul]> show databases;
  109. +--------------------+
  110. | Database |
  111. +--------------------+
  112. | baaza |
  113. | baza1 |
  114. | bigos |
  115. | cos |
  116. | create |
  117. | firma |
  118. | gorecki |
  119. | information_schema |
  120. | kowalski |
  121. | ksiegarnia |
  122. | ksiengarnia |
  123. | lul |
  124. | mysql |
  125. | performance_schema |
  126. | phpmyadmin |
  127. | pierwsza |
  128. | rodzina |
  129. | siema |
  130. | szkola |
  131. | test |
  132. +--------------------+
  133. 20 rows in set (0.00 sec)
  134.  
  135. MariaDB [lul]> use firma
  136. Database changed
  137. MariaDB [firma]> show tables;
  138. +-----------------+
  139. | Tables_in_firma |
  140. +-----------------+
  141. | cos1 |
  142. | samochody |
  143. +-----------------+
  144. 2 rows in set (0.00 sec)
  145.  
  146. MariaDB [firma]> select * from samochody;
  147. +----+--------+-----------+-------------+---------------+----------+---------------+---------------+------------------+
  148. | id | marka | kolor | model | rok_produkcji | przebieg | rodzaj_paliwa | skrzynia_bieg | kraj_rejestracji |
  149. +----+--------+-----------+-------------+---------------+----------+---------------+---------------+------------------+
  150. | 1 | VW | Granatowy | IV | 2000 | 217000 | benzyna | manualna | Polska |
  151. | 2 | VW | Czerwony | V | 2004 | 200000 | benzyna | manualna | Polska |
  152. | 3 | Audi | Szary | IV | 2006 | 220000 | diesel | manualna | Polska |
  153. | 4 | Audi | Czarny | III | 2007 | 180000 | diesel | manualna | Polska |
  154. | 5 | Fiat | Szary | Stilo | 2001 | 215000 | benzyna+gaz | manualna | Polska |
  155. | 6 | Fiat | Czarny | Grande_Pnto | 2007 | 151000 | benzyna | manualna | Polska |
  156. | 7 | Alfa | Szary | 156 | 2004 | 250000 | benzyna | manualna | Polska |
  157. | 8 | Skoda | Srebrny | Octawia | 2002 | 200000 | benzyna+gaz | manualna | Polska |
  158. | 9 | Toyota | Niebieski | Aygo | 2012 | 150000 | benzyna | manualna | Polska |
  159. | 10 | VW | Czarny | Passat | 1998 | 280000 | diesel | manualna | Polska |
  160. | 11 | Reno | Zólty | Clio | 2005 | 200000 | benzyna | automatyczna | Polska |
  161. | 12 | BMW | Niebieski | E30 | 2001 | 300000 | benzyna | manualna | Polska |
  162. | 13 | VW | Bialy | II | 1994 | 300000 | benzyna | manualna | Polska |
  163. | 14 | VW | Zielony | I | 1990 | 400000 | benzyna | manualna | Polska |
  164. | 15 | Ford | Czarny | Fiesta | 2010 | 180000 | benzyna | manualna | Polska |
  165. +----+--------+-----------+-------------+---------------+----------+---------------+---------------+------------------+
  166. 15 rows in set (0.00 sec)
  167.  
  168. MariaDB [firma]> select * from cos1;
  169. Empty set (0.01 sec)
  170.  
  171. MariaDB [firma]> describe cos1;
  172. +----------+-------------+------+-----+---------+-------+
  173. | Field | Type | Null | Key | Default | Extra |
  174. +----------+-------------+------+-----+---------+-------+
  175. | id | int(11) | NO | PRI | NULL | |
  176. | imie | varchar(20) | YES | | NULL | |
  177. | nazwisko | varchar(20) | YES | | NULL | |
  178. +----------+-------------+------+-----+---------+-------+
  179. 3 rows in set (0.01 sec)
  180.  
  181. MariaDB [firma]> rename table samochody to zlomowisko;
  182. Query OK, 0 rows affected (0.02 sec)
  183.  
  184. MariaDB [firma]> show tables;
  185. +-----------------+
  186. | Tables_in_firma |
  187. +-----------------+
  188. | cos1 |
  189. | zlomowisko |
  190. +-----------------+
  191. 2 rows in set (0.00 sec)
  192.  
  193. MariaDB [firma]> alter table add column id_samochody first;
  194. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'add column id_samochody first' at line 1
  195. MariaDB [firma]> alter table zlomowisko add column id_samochody first;
  196. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'first' at line 1
  197. MariaDB [firma]> add column id_samochody first;
  198. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'add column id_samochody first' at line 1
  199. MariaDB [firma]> add column id_samochody int;
  200. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'add column id_samochody int' at line 1
  201. MariaDB [firma]> alter table zlomowisko add column id_samochody int;
  202. Query OK, 0 rows affected (0.02 sec)
  203. Records: 0 Duplicates: 0 Warnings: 0
  204.  
  205. MariaDB [firma]> describe zlomowisko;
  206. +------------------+-------------+------+-----+---------+----------------+
  207. | Field | Type | Null | Key | Default | Extra |
  208. +------------------+-------------+------+-----+---------+----------------+
  209. | id | int(11) | NO | PRI | NULL | auto_increment |
  210. | marka | varchar(20) | YES | | NULL | |
  211. | kolor | varchar(20) | YES | | NULL | |
  212. | model | varchar(20) | YES | | NULL | |
  213. | rok_produkcji | int(11) | YES | | NULL | |
  214. | przebieg | int(11) | YES | | NULL | |
  215. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  216. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  217. | kraj_rejestracji | varchar(20) | YES | | Polska | |
  218. | id_samochody | int(11) | YES | | NULL | |
  219. +------------------+-------------+------+-----+---------+----------------+
  220. 10 rows in set (0.01 sec)
  221.  
  222. MariaDB [firma]> alter table zlomowisko drop column id_samochody int;
  223. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'int' at line 1
  224. MariaDB [firma]> alter table zlomowisko drop column id_samochody;
  225. Query OK, 0 rows affected (0.03 sec)
  226. Records: 0 Duplicates: 0 Warnings: 0
  227.  
  228. MariaDB [firma]> alter table zlomowisko add column id_samochody int first;
  229. Query OK, 0 rows affected (0.03 sec)
  230. Records: 0 Duplicates: 0 Warnings: 0
  231.  
  232. MariaDB [firma]> describe zlomowisko;
  233. +------------------+-------------+------+-----+---------+----------------+
  234. | Field | Type | Null | Key | Default | Extra |
  235. +------------------+-------------+------+-----+---------+----------------+
  236. | id_samochody | int(11) | YES | | NULL | |
  237. | id | int(11) | NO | PRI | NULL | auto_increment |
  238. | marka | varchar(20) | YES | | NULL | |
  239. | kolor | varchar(20) | YES | | NULL | |
  240. | model | varchar(20) | YES | | NULL | |
  241. | rok_produkcji | int(11) | YES | | NULL | |
  242. | przebieg | int(11) | YES | | NULL | |
  243. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  244. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  245. | kraj_rejestracji | varchar(20) | YES | | Polska | |
  246. +------------------+-------------+------+-----+---------+----------------+
  247. 10 rows in set (0.01 sec)
  248.  
  249. MariaDB [firma]> alter table zlomowisko drop column id;
  250. Query OK, 15 rows affected (0.04 sec)
  251. Records: 15 Duplicates: 0 Warnings: 0
  252.  
  253. MariaDB [firma]> alter table zlomowisko change column 'id_samochody' 'id_samochody' int Primary Key auto_increment;
  254. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''id_samochody' 'id_samochody' int Primary Key auto_increment' at line 1
  255. MariaDB [firma]> alter table zlomowisko change column id_samochody id_samochody int Primary Key auto_increment;
  256. Query OK, 15 rows affected (0.04 sec)
  257. Records: 15 Duplicates: 0 Warnings: 0
  258.  
  259. MariaDB [firma]> describe zlomowisko;
  260. +------------------+-------------+------+-----+---------+----------------+
  261. | Field | Type | Null | Key | Default | Extra |
  262. +------------------+-------------+------+-----+---------+----------------+
  263. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  264. | marka | varchar(20) | YES | | NULL | |
  265. | kolor | varchar(20) | YES | | NULL | |
  266. | model | varchar(20) | YES | | NULL | |
  267. | rok_produkcji | int(11) | YES | | NULL | |
  268. | przebieg | int(11) | YES | | NULL | |
  269. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  270. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  271. | kraj_rejestracji | varchar(20) | YES | | Polska | |
  272. +------------------+-------------+------+-----+---------+----------------+
  273. 9 rows in set (0.01 sec)
  274.  
  275. MariaDB [firma]> alter table zlomowisko change column marka marka varchar(30);
  276. Query OK, 15 rows affected (0.04 sec)
  277. Records: 15 Duplicates: 0 Warnings: 0
  278.  
  279. MariaDB [firma]> alter table zlomowisko change column kolor kolor varchar(30);
  280. Query OK, 15 rows affected (0.03 sec)
  281. Records: 15 Duplicates: 0 Warnings: 0
  282.  
  283. MariaDB [firma]> alter table zlomowisko change column model model varchar(30);
  284. Query OK, 15 rows affected (0.03 sec)
  285. Records: 15 Duplicates: 0 Warnings: 0
  286.  
  287. MariaDB [firma]> describe zlomowisko;
  288. +------------------+-------------+------+-----+---------+----------------+
  289. | Field | Type | Null | Key | Default | Extra |
  290. +------------------+-------------+------+-----+---------+----------------+
  291. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  292. | marka | varchar(30) | YES | | NULL | |
  293. | kolor | varchar(30) | YES | | NULL | |
  294. | model | varchar(30) | YES | | NULL | |
  295. | rok_produkcji | int(11) | YES | | NULL | |
  296. | przebieg | int(11) | YES | | NULL | |
  297. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  298. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  299. | kraj_rejestracji | varchar(20) | YES | | Polska | |
  300. +------------------+-------------+------+-----+---------+----------------+
  301. 9 rows in set (0.01 sec)
  302.  
  303. MariaDB [firma]> alter table zlomowisko add column nadwozie varchar(20) after model;
  304. Query OK, 0 rows affected (0.02 sec)
  305. Records: 0 Duplicates: 0 Warnings: 0
  306.  
  307. MariaDB [firma]> describe zlomowisko;
  308. +------------------+-------------+------+-----+---------+----------------+
  309. | Field | Type | Null | Key | Default | Extra |
  310. +------------------+-------------+------+-----+---------+----------------+
  311. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  312. | marka | varchar(30) | YES | | NULL | |
  313. | kolor | varchar(30) | YES | | NULL | |
  314. | model | varchar(30) | YES | | NULL | |
  315. | nadwozie | varchar(20) | YES | | NULL | |
  316. | rok_produkcji | int(11) | YES | | NULL | |
  317. | przebieg | int(11) | YES | | NULL | |
  318. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  319. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  320. | kraj_rejestracji | varchar(20) | YES | | Polska | |
  321. +------------------+-------------+------+-----+---------+----------------+
  322. 10 rows in set (0.01 sec)
  323.  
  324. MariaDB [firma]> create index qwerty on zlomowisko (rok_produkcji);
  325. Query OK, 0 rows affected (0.01 sec)
  326. Records: 0 Duplicates: 0 Warnings: 0
  327.  
  328. MariaDB [firma]> describe zlomowisko;
  329. +------------------+-------------+------+-----+---------+----------------+
  330. | Field | Type | Null | Key | Default | Extra |
  331. +------------------+-------------+------+-----+---------+----------------+
  332. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  333. | marka | varchar(30) | YES | | NULL | |
  334. | kolor | varchar(30) | YES | | NULL | |
  335. | model | varchar(30) | YES | | NULL | |
  336. | nadwozie | varchar(20) | YES | | NULL | |
  337. | rok_produkcji | int(11) | YES | MUL | NULL | |
  338. | przebieg | int(11) | YES | | NULL | |
  339. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  340. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  341. | kraj_rejestracji | varchar(20) | YES | | Polska | |
  342. +------------------+-------------+------+-----+---------+----------------+
  343. 10 rows in set (0.00 sec)
  344.  
  345. MariaDB [firma]> alter table zlomowisko change kraj_rejestracji kraj_rejestracji varchar(20);
  346. Query OK, 0 rows affected (0.00 sec)
  347. Records: 0 Duplicates: 0 Warnings: 0
  348.  
  349. MariaDB [firma]> describe zlomowisko;
  350. +------------------+-------------+------+-----+---------+----------------+
  351. | Field | Type | Null | Key | Default | Extra |
  352. +------------------+-------------+------+-----+---------+----------------+
  353. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  354. | marka | varchar(30) | YES | | NULL | |
  355. | kolor | varchar(30) | YES | | NULL | |
  356. | model | varchar(30) | YES | | NULL | |
  357. | nadwozie | varchar(20) | YES | | NULL | |
  358. | rok_produkcji | int(11) | YES | MUL | NULL | |
  359. | przebieg | int(11) | YES | | NULL | |
  360. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  361. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  362. | kraj_rejestracji | varchar(20) | YES | | NULL | |
  363. +------------------+-------------+------+-----+---------+----------------+
  364. 10 rows in set (0.00 sec)
  365.  
  366. MariaDB [firma]> alter table zlomowisko change nadwozie nadwozie varchar(20) default'sedan';
  367. Query OK, 0 rows affected (0.01 sec)
  368. Records: 0 Duplicates: 0 Warnings: 0
  369.  
  370. MariaDB [firma]> describe zlomowisko;
  371. +------------------+-------------+------+-----+---------+----------------+
  372. | Field | Type | Null | Key | Default | Extra |
  373. +------------------+-------------+------+-----+---------+----------------+
  374. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  375. | marka | varchar(30) | YES | | NULL | |
  376. | kolor | varchar(30) | YES | | NULL | |
  377. | model | varchar(30) | YES | | NULL | |
  378. | nadwozie | varchar(20) | YES | | sedan | |
  379. | rok_produkcji | int(11) | YES | MUL | NULL | |
  380. | przebieg | int(11) | YES | | NULL | |
  381. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  382. | skrzynia_bieg | varchar(20) | YES | | NULL | |
  383. | kraj_rejestracji | varchar(20) | YES | | NULL | |
  384. +------------------+-------------+------+-----+---------+----------------+
  385. 10 rows in set (0.00 sec)
  386.  
  387. MariaDB [firma]> alter table zlomowisko change skrzynia_bieg skrzynia varchar(20);
  388. Query OK, 0 rows affected (0.01 sec)
  389. Records: 0 Duplicates: 0 Warnings: 0
  390.  
  391. MariaDB [firma]> alter table zlomowisko change przebieg przebieg int not NULL;
  392. Query OK, 15 rows affected (0.04 sec)
  393. Records: 15 Duplicates: 0 Warnings: 0
  394.  
  395. MariaDB [firma]> alter table zlomowisko change kolor kolor varchar(30) not NULL;
  396. Query OK, 15 rows affected (0.04 sec)
  397. Records: 15 Duplicates: 0 Warnings: 0
  398.  
  399. MariaDB [firma]> describe zlomowisko;
  400. +------------------+-------------+------+-----+---------+----------------+
  401. | Field | Type | Null | Key | Default | Extra |
  402. +------------------+-------------+------+-----+---------+----------------+
  403. | id_samochody | int(11) | NO | PRI | NULL | auto_increment |
  404. | marka | varchar(30) | YES | | NULL | |
  405. | kolor | varchar(30) | NO | | NULL | |
  406. | model | varchar(30) | YES | | NULL | |
  407. | nadwozie | varchar(20) | YES | | sedan | |
  408. | rok_produkcji | int(11) | YES | MUL | NULL | |
  409. | przebieg | int(11) | NO | | NULL | |
  410. | rodzaj_paliwa | varchar(20) | YES | | NULL | |
  411. | skrzynia | varchar(20) | YES | | NULL | |
  412. | kraj_rejestracji | varchar(20) | YES | | NULL | |
  413. +------------------+-------------+------+-----+---------+----------------+
  414. 10 rows in set (0.01 sec)
  415.  
  416. MariaDB [firma]> alter table zlomowisko convert to character set latin2;
  417. Query OK, 15 rows affected (0.09 sec)
  418. Records: 15 Duplicates: 0 Warnings: 0
  419.  
  420. MariaDB [firma]> add index t char (imie,nazwisko);
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!