Handheld Porn - Adult Videos
Portable Porn!

how to querry all lines from a table on mysql? [Archive] - BIG forum - Object Everything

PDA

View Full Version : how to querry all lines from a table on mysql?


almaz
10-15-2008, 02:43 AM
what I'm doing:

[root@s15308580 ~]# mysql -u auction_user -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 226385 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| auction_test |
+--------------------+
2 rows in set (0.14 sec)

mysql> connect mysql;
ERROR 1044 (42000): Access denied for user 'auction_user'@'%' to database 'mysql'
mysql> connect auction_test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id: 226389
Current database: auction_test

mysql> show tables;
+-----------------------------+
| Tables_in_auction_test |
+-----------------------------+
| PHPAUCTIONW_config |
| PHPAUCTIONW_transactions |
| PHPAUCTION_adminusers |
| PHPAUCTION_auctions |
| PHPAUCTION_banners |
| PHPAUCTION_bids |
| PHPAUCTION_categories |
| PHPAUCTION_categories_plain |
| PHPAUCTION_counters |
| PHPAUCTION_countries |
| PHPAUCTION_durations |
| PHPAUCTION_feedbacks |
| PHPAUCTION_help |
| PHPAUCTION_increments |
| PHPAUCTION_news |
| PHPAUCTION_payments |
| PHPAUCTION_request |
| PHPAUCTION_sessions |
| PHPAUCTION_settings |
| PHPAUCTION_users |
+-----------------------------+
20 rows in set (0.00 sec)

mysql> select * from PHPAUCTION_adminusers
->
->
->
->
->
->
-> Aborted
[root@s15308580 ~]#


question, what is wrong? how to querry all users on PHPAUCTION_adminusers table?


Handheld Porn - Adult Videos
Portable Porn!