https://bugzilla.wikimedia.org/show_bug.cgi?id=35626
--- Comment #20 from Marcin Cieślak <[email protected]> 2012-05-03 06:15:05 UTC --- Some data from my MySQL instance: $ mysql -u root -p reviewdb --default-character-set=utf8 Enter password: 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 1212 Server version: 5.0.92 FreeBSD port: mysql-server-5.0.92 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \s -------------- mysql Ver 14.12 Distrib 5.0.92, for portbld-freebsd8.2 (amd64) using 5.2 Connection id: 1212 Current database: reviewdb Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.0.92 FreeBSD port: mysql-server-5.0.92 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /tmp/mysql.sock Uptime: 21 days 8 hours 24 min 17 sec Threads: 6 Questions: 339557 Slow queries: 0 Opens: 85 Flush tables: 1 Open tables: 64 Queries per second avg: 0.184 -------------- mysql> show full columns from accounts; +----------------------------------------+--------------+-----------------+------+-----+-------------------+-------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +----------------------------------------+--------------+-----------------+------+-----+-------------------+-------+---------------------------------+---------+ | registered_on | timestamp | NULL | NO | | CURRENT_TIMESTAMP | | select,insert,update,references | | | full_name | varchar(255) | utf8_bin | YES | MUL | NULL | | select,insert,update,references | | | preferred_email | varchar(255) | utf8_bin | YES | MUL | NULL | | select,insert,update,references | | | contact_filed_on | timestamp | NULL | YES | | NULL | | select,insert,update,references | | | maximum_page_size | smallint(6) | NULL | NO | | 0 | | select,insert,update,references | | | show_site_header | char(1) | utf8_unicode_ci | NO | | N | | select,insert,update,references | | | use_flash_clipboard | char(1) | utf8_unicode_ci | NO | | N | | select,insert,update,references | | | download_url | varchar(20) | utf8_bin | YES | | NULL | | select,insert,update,references | | | download_command | varchar(20) | utf8_bin | YES | | NULL | | select,insert,update,references | | | copy_self_on_email | char(1) | utf8_unicode_ci | NO | | N | | select,insert,update,references | | | date_format | varchar(10) | utf8_bin | YES | | NULL | | select,insert,update,references | | | time_format | varchar(10) | utf8_bin | YES | | NULL | | select,insert,update,references | | | display_patch_sets_in_reverse_order | char(1) | utf8_unicode_ci | NO | | N | | select,insert,update,references | | | display_person_name_in_review_category | char(1) | utf8_unicode_ci | NO | | N | | select,insert,update,references | | | inactive | char(1) | utf8_unicode_ci | NO | | N | | select,insert,update,references | | | account_id | int(11) | NULL | NO | PRI | 0 | | select,insert,update,references | | +----------------------------------------+--------------+-----------------+------+-----+-------------------+-------+---------------------------------+---------+ 16 rows in set (0.02 sec) mysql> select full_name from accounts where preferred_email like 'saper%' \G *************************** 1. row *************************** full_name: Marcin Cieślak 1 row in set (0.00 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
