Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alex@alex:~$ ssh tools-login.wmflabs.org -t sql enwiki
- If you are having access problems, please see: https://wikitech.wikimedia.org/wiki/Access#Accessing_public_and_private_instances
- 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 MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 7189339
- Server version: 5.5.30-MariaDB-mariadb1~precise-log mariadb.org binary distribution
- Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [enwiki_p]> EXPLAIN user;
- +--------------------------+-----------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------------------+-----------------+------+-----+---------+-------+
- | user_id | int(5) unsigned | NO | | 0 | |
- | user_name | varbinary(255) | NO | | | |
- | user_real_name | varbinary(255) | NO | | | |
- | user_password | tinyblob | NO | | NULL | |
- | user_newpassword | tinyblob | NO | | NULL | |
- | user_email | tinyblob | NO | | NULL | |
- | user_options | blob | NO | | NULL | |
- | user_touched | varbinary(14) | NO | | | |
- | user_token | varbinary(32) | NO | | | |
- | user_email_authenticated | varbinary(14) | YES | | NULL | |
- | user_email_token | varbinary(32) | YES | | NULL | |
- | user_email_token_expires | varbinary(14) | YES | | NULL | |
- | user_registration | varbinary(14) | YES | | NULL | |
- | user_newpass_time | varbinary(14) | YES | | NULL | |
- | user_editcount | int(11) | YES | | NULL | |
- +--------------------------+-----------------+------+-----+---------+-------+
- 15 rows in set (0.04 sec)
Advertisement
Add Comment
Please, Sign In to add comment