User:Rezonansowy/term



 dispenser@nightshade:~$ sql wiki_p Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5926554 Server version: 5.0.64 Source distribution

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

mysql> DESCRIBE -> user_groups; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 2 rows in set (0.00 sec)
 * Field   | Type            | Null | Key | Default | Extra |
 * ug_user | int(5) unsigned | NO   |     | 0       |       |
 * ug_group | char(16)       | NO   |     |         |       |

mysql> SELECT count(*) FROM user_groups WHERE ug_group="sysop"; +--+ +--+ +--+ 1 row in set (0.03 sec)
 * count(*) |

mysql> SELECT * from site_stats; +---+++--+-- -+--+---+---+ | ss_users | ss_admins | ss_images | +---+++--+-- -+--+---+---+ |  |       496 |     | +---+++--+-- -+--+---+---+ 1 row in set (0.00 sec)
 * ss_row_id | ss_total_views | ss_total_edits | ss_good_articles | ss_total_page
 * 1 |      63208805 |       |           |

mysql> quit Bye dispenser@nightshade:~$