· 9 years ago · Jan 03, 2017, 11:26 AM
1
2Setting environment for using XAMPP for Windows.
3uczen@STACJA c:\xampp
4# mysql.exe
5Welcome to the MariaDB monitor. Commands end with ; or \g.
6Your MariaDB connection id is 2
7Server version: 10.1.8-MariaDB mariadb.org binary distribution
8
9Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
10
11Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
12
13MariaDB [(none)]> show databases;
14+--------------------+
15| Database |
16+--------------------+
17| information_schema |
18| test |
19+--------------------+
202 rows in set (0.01 sec)
21
22MariaDB [(none)]> use test;
23Database changed
24MariaDB [test]> show tables;
25Empty set (0.02 sec)
26
27MariaDB [test]> use information_schema;
28Database changed
29MariaDB [information_schema]> use information_schema;
30Database changed
31MariaDB [information_schema]> show information_schema;
32ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
33corresponds to your MariaDB server version for the right syntax to use near 'inf
34ormation_schema' at line 1
35MariaDB [information_schema]> show tables;
36+---------------------------------------+
37| Tables_in_information_schema |
38+---------------------------------------+
39| ALL_PLUGINS |
40| APPLICABLE_ROLES |
41| CHARACTER_SETS |
42| COLLATIONS |
43| COLLATION_CHARACTER_SET_APPLICABILITY |
44| COLUMNS |
45| COLUMN_PRIVILEGES |
46| ENABLED_ROLES |
47| ENGINES |
48| EVENTS |
49| FILES |
50| GLOBAL_STATUS |
51| GLOBAL_VARIABLES |
52| KEY_CACHES |
53| KEY_COLUMN_USAGE |
54| PARAMETERS |
55| PARTITIONS |
56| PLUGINS |
57| PROCESSLIST |
58| PROFILING |
59| REFERENTIAL_CONSTRAINTS |
60| ROUTINES |
61| SCHEMATA |
62| SCHEMA_PRIVILEGES |
63| SESSION_STATUS |
64| SESSION_VARIABLES |
65| STATISTICS |
66| SYSTEM_VARIABLES |
67| TABLES |
68| TABLESPACES |
69| TABLE_CONSTRAINTS |
70| TABLE_PRIVILEGES |
71| TRIGGERS |
72| USER_PRIVILEGES |
73| VIEWS |
74| GEOMETRY_COLUMNS |
75| SPATIAL_REF_SYS |
76| CLIENT_STATISTICS |
77| INDEX_STATISTICS |
78| INNODB_SYS_DATAFILES |
79| TABLE_STATISTICS |
80| INNODB_SYS_TABLESTATS |
81| USER_STATISTICS |
82| INNODB_SYS_INDEXES |
83| XTRADB_RSEG |
84| INNODB_CMP_PER_INDEX |
85| INNODB_TRX |
86| CHANGED_PAGE_BITMAPS |
87| INNODB_FT_BEING_DELETED |
88| INNODB_LOCK_WAITS |
89| INNODB_LOCKS |
90| INNODB_TABLESPACES_ENCRYPTION |
91| XTRADB_INTERNAL_HASH_TABLES |
92| INNODB_SYS_FIELDS |
93| INNODB_CMPMEM_RESET |
94| INNODB_CMP |
95| INNODB_FT_INDEX_TABLE |
96| INNODB_SYS_TABLESPACES |
97| INNODB_MUTEXES |
98| INNODB_BUFFER_PAGE_LRU |
99| INNODB_SYS_FOREIGN_COLS |
100| INNODB_CMP_RESET |
101| INNODB_BUFFER_POOL_STATS |
102| INNODB_FT_INDEX_CACHE |
103| INNODB_SYS_FOREIGN |
104| INNODB_METRICS |
105| INNODB_FT_DEFAULT_STOPWORD |
106| INNODB_CMPMEM |
107| INNODB_SYS_TABLES |
108| INNODB_SYS_COLUMNS |
109| INNODB_FT_CONFIG |
110| INNODB_BUFFER_PAGE |
111| INNODB_CMP_PER_INDEX_RESET |
112| XTRADB_READ_VIEW |
113| INNODB_SYS_SEMAPHORE_WAITS |
114| INNODB_CHANGED_PAGES |
115| INNODB_FT_DELETED |
116| INNODB_TABLESPACES_SCRUBBING |
117+---------------------------------------+
11878 rows in set (0.00 sec)
119
120MariaDB [information_schema]> create database 3a;
121ERROR 1044 (42000): Access denied for user ''@'localhost' to database '3a'
122MariaDB [information_schema]> mysql.exe -u root
123 -> ;
124ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
125corresponds to your MariaDB server version for the right syntax to use near 'mys
126ql.exe -u root' at line 1
127MariaDB [information_schema]> ;exit
128ERROR: No query specified
129
130 -> ;
131ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
132corresponds to your MariaDB server version for the right syntax to use near 'exi
133t' at line 1
134MariaDB [information_schema]> exit
135Bye
136
137uczen@STACJA c:\xampp
138# mysql.exe -u root
139Welcome to the MariaDB monitor. Commands end with ; or \g.
140Your MariaDB connection id is 3
141Server version: 10.1.8-MariaDB mariadb.org binary distribution
142
143Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
144
145Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
146
147MariaDB [(none)]> create database 3a;
148Query OK, 1 row affected (0.03 sec)
149
150MariaDB [(none)]> show databases;
151+--------------------+
152| Database |
153+--------------------+
154| 3a |
155| biblioteka |
156| information_schema |
157| mysql |
158| onp |
159| performance_schema |
160| phpmyadmin |
161| test |
162+--------------------+
1638 rows in set (0.03 sec)
164
165MariaDB [(none)]> create database 3a;
166ERROR 1007 (HY000): Can't create database '3a'; database exists
167MariaDB [(none)]> create database if not exists 3a;
168Query OK, 0 rows affected, 1 warning (0.00 sec)
169
170MariaDB [(none)]> drop database 3a;
171Query OK, 0 rows affected (0.06 sec)
172
173MariaDB [(none)]> show databases;
174+--------------------+
175| Database |
176+--------------------+
177| biblioteka |
178| information_schema |
179| mysql |
180| onp |
181| performance_schema |
182| phpmyadmin |
183| test |
184+--------------------+
1857 rows in set (0.00 sec)
186
187MariaDB [(none)]> drop databases biblioteka;
188ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
189corresponds to your MariaDB server version for the right syntax to use near 'dat
190abases biblioteka' at line 1
191MariaDB [(none)]> drop database biblioteka;
192Query OK, 3 rows affected (0.17 sec)
193
194MariaDB [(none)]> show databases;
195+--------------------+
196| Database |
197+--------------------+
198| information_schema |
199| mysql |
200| onp |
201| performance_schema |
202| phpmyadmin |
203| test |
204+--------------------+
2056 rows in set (0.00 sec)
206
207MariaDB [(none)]> dsa
208 -> dsad
209 -> d
210 -> asds
211 -> a
212 -> fsdf
213 -> fsdfsd;
214ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
215corresponds to your MariaDB server version for the right syntax to use near 'dsa
216
217dsad
218d
219asds
220a
221fsdf
222fsdfsd' at line 1
223MariaDB [(none)]> use 3a;
224ERROR 1049 (42000): Unknown database '3a'
225MariaDB [(none)]> create database if not exists 3a;
226Query OK, 1 row affected (0.00 sec)
227
228MariaDB [(none)]> use 3a;
229Database changed
230MariaDB [3a]>
231MariaDB [3a]> create table tab1
232 -> id int not null auto_increment primary key,
233 -> imie varchar(10),
234 -> nazwisko varchar(15),
235 -> kwota int);
236ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
237corresponds to your MariaDB server version for the right syntax to use near 'id
238int not null auto_increment primary key,
239imie varchar(10),
240nazwisko varchar(1' at line 2
241MariaDB [3a]> id int not null auto_increment primary key,
242 -> imie varchar(10),
243 -> nazwisko varchar(15),
244 -> ;
245ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
246corresponds to your MariaDB server version for the right syntax to use near 'id
247int not null auto_increment primary key,
248imie varchar(10),
249nazwisko varchar(1' at line 1
250MariaDB [3a]> create table tab1(\
251 -> ;
252ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
253corresponds to your MariaDB server version for the right syntax to use near '' a
254t line 1
255MariaDB [3a]> create table tab1(
256 -> id int not null auto_increment primary key,
257 -> imie varchar(10),
258 -> nazwisko varchar(15),
259 -> ;
260ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
261corresponds to your MariaDB server version for the right syntax to use near '' a
262t line 4
263MariaDB [3a]> id int not null auto_increment primary key,
264 -> imie varchar(10),
265 -> nazwisko varchar(15),
266 -> kwota int);
267ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
268corresponds to your MariaDB server version for the right syntax to use near 'id
269int not null auto_increment primary key,
270imie varchar(10),
271nazwisko varchar(1' at line 1
272MariaDB [3a]> id int not null auto_increment primary key,
273 -> imie varchar(10),
274 -> nazwisko varchar(15),
275 -> kwota int);;
276ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
277corresponds to your MariaDB server version for the right syntax to use near 'id
278int not null auto_increment primary key,
279imie varchar(10),
280nazwisko varchar(1' at line 1
281ERROR: No query specified
282
283MariaDB [3a]> create table tab1(
284 -> id int not null auto_increment primary key,
285 -> imie varchar(10),
286 -> nazwisko varchar(15),
287 -> kwota int);
288Query OK, 0 rows affected (0.06 sec)
289
290MariaDB [3a]>