linux:arnow> mysql -u arnow -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.0.67-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit
Bye
LINUX:arnow> mysql
ERROR 1045 (28000): Access denied for user 'arnow'@'localhost' (using password: NO)
LINUX:arnow> mysql -u fjalskdfjlk
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33
Server version: 5.0.67-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use arnow;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'arnow'
mysql> quit
Bye
LINUX:arnow> mysql -u arnow
ERROR 1045 (28000): Access denied for user 'arnow'@'localhost' (using password: NO)
LINUX:arnow> mysql -u arnow -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.0.67-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use anzhela;
ERROR 1044 (42000): Access denied for user 'arnow'@'localhost' to database 'anzhela'
mysql> use arnow;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-----------------+
| Tables_in_arnow |
+-----------------+
| junk |
+-----------------+
1 row in set (0.00 sec)
mysql> show databases ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| arnow |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> create table price ( price_id int(11) primary key auto_increment not null, name varchar(30), price int(11), maxdisc int(11) );
Query OK, 0 rows affected (0.08 sec)
mysql> show tables;
+-----------------+
| Tables_in_arnow |
+-----------------+
| junk |
| price |
+-----------------+
2 rows in set (0.00 sec)
mysql> describe price ;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| price_id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(30) | YES | | NULL | |
| price | int(11) | YES | | NULL | |
| maxdisc | int(11) | YES | | NULL | |
+----------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> select * from price ;
Empty set (0.00 sec)
mysql> insert into price (name,price) values('gizmo2000',9999);
Query OK, 1 row affected (0.00 sec)
mysql> select * from price ;
+----------+-----------+-------+---------+
| price_id | name | price | maxdisc |
+----------+-----------+-------+---------+
| 1 | gizmo2000 | 9999 | NULL |
+----------+-----------+-------+---------+
1 row | price |
+-----------+-------+
| gizmo2000 | 9999 |
| widget2 | 5000 |
+-----------+-------+
2 rows in set (0.01 sec)
mysql> select name.price from price where price>6000 ;
ERROR 1054 (42S22): Unknown column 'name.price' in 'field list'
mysql> select name,price from price where price>6000 ;
+-----------+-------+
| name | price |
+-----------+-------+
| gizmo2000 | 9999 |
+-----------+-------+
1 row in set (0.00 sec)
mysql>