mysql> use test;
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_test |
+----------------+
| Nums |
| a |
| charTest |
| customers |
| employees |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| yeartest |
| z |
+----------------+
17 rows in set (0.00 sec)
mysql> #数据按照主键顺序 还要order by 干嘛?
mysql> #其实不然, 数据并非总是按照主键顺序排序的 这里Innodb引擎不是索引组织表码?
mysql> #写个例子
mysql> create table animals(id int primary key, name varchar(20), unique key(name))engine=innodb;
Query OK, 0 rows affected (0.10 sec)
mysql> insert into animals select 1,'Tiger';
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into animals select 2,'Dog';
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into animals select 3,'Cat';
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from animals;
+----+-------+
| id | name |
+----+-------+
| 3 | Cat |
| 2 | Dog |
| 1 | Tiger |
+----+-------+
3 rows in set (0.00 sec)
mysql> #哇 有主键id,但是查询结果出人意料,所以得出结论,对于没有使用order by子句的查询结果 其结果永远不会是按照主键顺序进行排列的 因为没有order by子句的查询只代表从结合中查询数据 而集合是没有顺序概念的
mysql>
mysql> select * from animals order by id asc;
+----+-------+
| id | name |
+----+-------+
| 1 | Tiger |
| 2 | Dog |
| 3 | Cat |
+----+-------+
3 rows in set (0.00 sec)
mysql> show status;
+------------------------------------------+-------------+
| Variable_name | Value |
+------------------------------------------+-------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 698 |
| Bytes_sent | 3987 |
| Com_admin_commands | 0 |
| Com_assign_to_keycache | 0 |
| Com_alter_db | 0 |
| Com_alter_db_upgrade | 0 |
| Com_alter_event | 0 |
| Com_alter_function | 0 |
| Com_alter_procedure | 0 |
| Com_alter_server | 0 |
| Com_alter_table | 0 |
| Com_alter_tablespace | 0 |
| Com_analyze | 0 |
| Com_begin | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 1 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_procedure | 0 |
| Com_create_server | 0 |
| Com_create_table | 1 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_procedure | 0 |
| Com_drop_server | 0 |
| Com_drop_table | 0 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 0 |
| Com_insert_select | 3 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 0 |
| Com_rename_table | 0 |
| Com_rename_user | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_resignal | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 4 |
| Com_set_option | 0 |
| Com_signal | 0 |
| Com_show_authors | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_contributors | 0 |
| Com_show_create_db | 0 |
| Com_show_create_event | 0 |
| Com_show_create_func | 0 |
| Com_show_create_proc | 0 |
| Com_show_create_table | 0 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 1 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 0 |
| Com_show_events | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 17 |
| Com_show_function_status | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges | 0 |
| Com_show_procedure_status | 0 |
| Com_show_processlist | 0 |
| Com_show_profile | 0 |
| Com_show_profiles | 0 |
| Com_show_relaylog_events | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_table_status | 0 |
| Com_show_tables | 2 |
| Com_show_triggers | 0 |
| Com_show_variables | 0 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 0 |
| Com_update | 0 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 38 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 5 |
| Created_tmp_tables | 3 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 5 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 2 |
| Handler_read_key | 2 |
| Handler_read_last | 0 |
| Handler_read_next | 6 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 44 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 0 |
| Handler_write | 44 |
| Innodb_buffer_pool_pages_data | 475 |
| Innodb_buffer_pool_bytes_data | 7782400 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 22 |
| Innodb_buffer_pool_pages_free | 7716 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 8192 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 6063 |
| Innodb_buffer_pool_reads | 474 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 62 |
| Innodb_data_fsyncs | 19 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 9949184 |
| Innodb_data_reads | 484 |
| Innodb_data_writes | 27 |
| Innodb_data_written | 730112 |
| Innodb_dblwr_pages_written | 22 |
| Innodb_dblwr_writes | 4 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 7 |
| Innodb_log_writes | 5 |
| Innodb_os_log_fsyncs | 11 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 6144 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 2 |
| Innodb_pages_read | 473 |
| Innodb_pages_written | 22 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 3 |
| Innodb_rows_read | 6 |
| Innodb_rows_updated | 0 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 13394 |
| Key_blocks_used | 2 |
| Key_read_requests | 8 |
| Key_reads | 2 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Last_query_cost | 4.599000 |
| Max_used_connections | 1 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 50 |
| Open_streams | 0 |
| Open_table_definitions | 91 |
| Open_tables | 91 |
| Opened_files | 391 |
| Opened_table_definitions | 2 |
| Opened_tables | 2 |
| Performance_schema_cond_classes_lost | 0 |
| Performance_schema_cond_instances_lost | 0 |
| Performance_schema_file_classes_lost | 0 |
| Performance_schema_file_handles_lost | 0 |
| Performance_schema_file_instances_lost | 0 |
| Performance_schema_locker_lost | 0 |
| Performance_schema_mutex_classes_lost | 0 |
| Performance_schema_mutex_instances_lost | 0 |
| Performance_schema_rwlock_classes_lost | 0 |
| Performance_schema_rwlock_instances_lost | 0 |
| Performance_schema_table_handles_lost | 0 |
| Performance_schema_table_instances_lost | 0 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 16757136 |
| Qcache_hits | 0 |
| Qcache_inserts | 2 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 71 |
| Qcache_queries_in_cache | 2 |
| Qcache_total_blocks | 6 |
| Queries | 138 |
| Questions | 30 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 5 |
| Slave_heartbeat_period | 0.000 |
| Slave_open_temp_tables | 0 |
| Slave_received_heartbeats | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 68 |
| Table_locks_waited | 0 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 1 |
| Threads_running | 1 |
| Uptime | 593 |
| Uptime_since_flush_status | 593 |
+------------------------------------------+-------------+
312 rows in set (0.00 sec)
mysql> show status like '%sort%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
+-------------------+-------+
4 rows in set (0.00 sec)
mysql> #limit n,m 子句
mysql> #表示从第n条记录开始选择m条记录
mysql> select * from aminals limit 2;
ERROR 1146 (42S02): Table 'test.aminals' doesn't exist
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| employees |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| yeartest |
| z |
+----------------+
18 rows in set (0.00 sec)
mysql> select * from animals limit 2;
+----+------+
| id | name |
+----+------+
| 3 | Cat |
| 2 | Dog |
+----+------+
2 rows in set (0.00 sec)
mysql> #子查询
mysql> #是指在一个select语句中嵌套另一个select语句
mysql> #好处:
mysql> #1.子查询允许结构化的查询 这样就可以把一个查询语句的每个部分隔开
mysql> #2.子查询提供了另一种方法来执行有些需要复杂的join和union来实现的操作
mysql> #3.在许多人看来,子查询的刻度性能比较高
mysql>
mysql> #一个子查询返回一个标量(一个行 一个列 一个表) 子查询可以包括select语句可以包括的一切子句
mysql> #子查询限制: 用户不能既在一个子查询中修改一个表,又在另一个表中进行选择
mysql>
mysql> select 'a'=(select 'a') as t;
+---+
| t |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
mysql> select 'a'=(select null) as t;
+------+
| t |
+------+
| NULL |
+------+
1 row in set (0.00 sec)
mysql> #标量子查询
mysql> desc orders;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| order_id | int(11) | NO | PRI | NULL | auto_increment |
| customer_id | varchar(10) | YES | | NULL | |
+-------------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> select * from orders;
+----------+-------------+
| order_id | customer_id |
+----------+-------------+
| 1 | Jack1 |
| 2 | Jack1 |
| 3 | 9You |
| 4 | 9You |
| 5 | 9You |
| 6 | TX |
| 7 | NULL |
+----------+-------------+
7 rows in set (0.00 sec)
mysql> #现在我们利用子查询来查找员工表中每月worktime最后一个
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| employees |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| yeartest |
| z |
+----------------+
18 rows in set (0.00 sec)
mysql> drop table new_emp;
Query OK, 0 rows affected (0.05 sec)
mysql> create table new_emp like employees;
Query OK, 0 rows affected (0.10 sec)
mysql> insert into new_emp select * from employees limit 500;
Query OK, 500 rows affected (0.05 sec)
Records: 500 Duplicates: 0 Warnings: 0
mysql> desc new_emp;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(10) | NO | PRI | NULL | |
| birth_date | date | YES | | NULL | |
| first_name | varchar(15) | NO | | | |
| last_name | varchar(15) | NO | | | |
| sex | char(1) | YES | | NULL | |
| worktime | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> select id, concat(first_name,' ',last_name) as name, worktime
-> from new_emp
-> where worktime in
-> (select max(worktime)
-> from new_emp
-> group by (date_format(worktime,'%Y%m')));
+-------+------------------------+------------+
| id | name | worktime |
+-------+------------------------+------------+
| 10001 | Georgi Facello | 1986-06-26 |
| 10003 | Parto Bamford | 1986-08-28 |
| 10008 | Saniya Kalloufi | 1994-09-15 |
| 10010 | Duangkaew Piveteau | 1989-08-24 |
| 10016 | Kazuhito Cappelletti | 1995-01-27 |
| 10019 | Lillian Haddadi | 1999-04-30 |
| 10020 | Mayuko Warwick | 1991-01-26 |
| 10022 | Shahaf Famili | 1995-08-22 |
| 10024 | Suzette Pettey | 1997-05-19 |
| 10026 | Yongqiao Berztiss | 1995-03-20 |
| 10030 | Elvis Demeyer | 1994-02-17 |
| 10032 | Jeong Reistad | 1990-06-20 |
| 10040 | Weiyi Meriste | 1993-02-14 |
| 10047 | Zvonko Nyanchama | 1989-03-31 |
| 10048 | Florian Syrotiuk | 1985-02-24 |
| 10051 | Hidefumi Caine | 1992-10-15 |
| 10055 | Georgy Dredge | 1992-04-27 |
| 10059 | Alejandro McAlpine | 1991-06-26 |
| 10062 | Anoosh Peyn | 1991-08-30 |
| 10066 | Kwee Schusler | 1986-02-26 |
| 10078 | Danel Mondadori | 1987-05-26 |
| 10081 | Zhongwei Rosen | 1986-10-30 |
| 10083 | Vishv Zockler | 1987-03-31 |
| 10086 | Somnath Foote | 1990-02-16 |
| 10091 | Amabile Gomatam | 1992-11-18 |
| 10092 | Valdiodio Niizuma | 1989-09-22 |
| 10093 | Sailaja Desikan | 1996-11-05 |
| 10100 | Hironobu Haraldson | 1987-09-21 |
| 10102 | Paraskevi Luby | 1994-01-26 |
| 10109 | Mariusz Prampolini | 1993-06-16 |
| 10113 | Jaewon Syrzycki | 1989-12-24 |
| 10116 | Dayanand Czap | 1985-05-28 |
| 10125 | Syozo Hiltgen | 1990-10-26 |
| 10131 | Magdalena Eldridge | 1994-11-17 |
| 10132 | Ayakannu Skrikant | 1994-10-30 |
| 10139 | Ewing Foong | 1998-03-15 |
| 10140 | Yucel Auria | 1991-03-14 |
| 10142 | Tzvetan Hettesheimer | 1993-10-28 |
| 10143 | Sakthirel Bakhtari | 1988-09-30 |
| 10146 | Chenyi Syang | 1988-06-28 |
| 10158 | Khedija Mitsuhashi | 1986-01-29 |
| 10159 | Serif Buescher | 1991-05-29 |
| 10160 | Debatosh Khasidashvili | 1989-01-30 |
| 10171 | Herbert Trachtenberg | 1989-07-22 |
| 10173 | Shrikanth Mahmud | 1992-03-21 |
| 10176 | Brendon Lenart | 1994-12-22 |
| 10186 | Shigehito Kropatsch | 1986-03-28 |
| 10191 | Zdislav Nastansky | 1986-04-10 |
| 10193 | Masaru Cheshire | 1991-07-28 |
| 10197 | Kasidit Krzyzanowski | 1993-11-22 |
| 10198 | Pranav Furedi | 1985-08-31 |
| 10199 | Kazuhisa Ranta | 1997-04-29 |
| 10201 | Idoia Kavraki | 1986-11-22 |
| 10205 | Mabhin Leijenhorst | 1993-08-23 |
| 10208 | Xiping Klerer | 1991-12-23 |
| 10209 | Yolla Ellozy | 1991-11-23 |
| 10212 | Divier Esteva | 1990-07-11 |
| 10214 | Tadahiko Ciolek | 1988-02-29 |
| 10216 | Amstein Ghemri | 1987-10-30 |
| 10218 | Zhenhua Magalhaes | 1997-01-15 |
| 10219 | Genta Kolvik | 1993-03-31 |
| 10220 | Kish Fasbender | 1992-06-25 |
| 10226 | Xinglin Plessier | 1989-10-27 |
| 10227 | Anneli Kaiser | 1994-04-24 |
| 10229 | Ulises Takanami | 1987-11-22 |
| 10230 | Clyde Vernadat | 1996-06-16 |
| 10231 | Shaowen Desikan | 1996-04-13 |
| 10234 | Arunachalam Bakhtari | 1990-11-19 |
| 10235 | Susanta Roccetti | 1995-04-06 |
| 10236 | Susumu Bade | 1996-08-30 |
| 10239 | Nikolaos Llado | 1995-05-08 |
| 10243 | Wonhee Pouyioutas | 1985-11-24 |
| 10244 | Foong Flasterstein | 1985-12-23 |
| 10250 | Serap Etalle | 1992-08-30 |
| 10251 | Alair Rosenbaum | 1992-06-25 |
| 10262 | Mahendra Maraist | 1992-07-27 |
| 10264 | Nalini Kawashimo | 1997-07-16 |
| 10269 | Taizo Oxman | 1988-07-24 |
| 10270 | Bedir Hartvigsen | 1990-04-26 |
| 10274 | Dmitri Pearson | 1991-04-21 |
| 10283 | Kauko Birjandi | 1988-05-25 |
| 10285 | Zhonghui Preusig | 1995-02-27 |
| 10286 | Saddek Gopalakrishnan | 1988-03-21 |
| 10288 | Selwyn Perri | 1994-08-29 |
| 10291 | Dipayan Seghrouchni | 1986-09-29 |
| 10295 | Kristine Velardi | 1990-08-27 |
| 10297 | Narain Oaver | 1986-05-28 |
| 10298 | Dietrich DuCasse | 1999-03-30 |
| 10302 | Faiza Baer | 1986-07-22 |
| 10305 | Hirochika Piancastelli | 1988-10-31 |
| 10306 | Heng Kilgour | 1993-09-06 |
| 10308 | Dzung Holburn | 1992-12-29 |
| 10312 | Rasiah Deyuan | 1986-08-28 |
| 10315 | Maris Angelopoulos | 1987-08-28 |
| 10318 | Mototsugu Beilner | 1985-06-29 |
| 10320 | Uinam Stasinski | 1988-11-03 |
| 10322 | Isamu Dahlbom | 1990-01-29 |
| 10325 | Arunachalam Badr | 1990-09-20 |
| 10333 | Snehasis Dymetman | 1993-01-16 |
| 10334 | Falguni Erie | 1996-12-28 |
| 10339 | Teunis Liedekerke | 1989-11-30 |
| 10340 | Djelloul Laventhal | 1987-06-05 |
| 10341 | Wilmer Greenaway | 1987-04-29 |
| 10342 | Stella Hiroyama | 1987-07-25 |
| 10344 | Uwe Garnier | 1994-06-25 |
| 10346 | Aamod Radwan | 1987-01-27 |
| 10349 | Oksana Brodie | 1991-09-28 |
| 10352 | Erzsebet Ohori | 1996-01-21 |
| 10353 | Phule Hammerschmidt | 1989-08-24 |
| 10354 | Moto Kusakari | 1996-03-26 |
| 10358 | Qunsheng Tagansky | 1991-02-19 |
| 10360 | Irene Munck | 1996-09-04 |
| 10372 | Anneli Frijda | 1985-07-30 |
| 10374 | Willard Rosin | 1993-12-08 |
| 10375 | Dante Kalafatis | 1994-05-29 |
| 10378 | Takahira Lichtner | 1990-12-30 |
| 10380 | Alejandro Kamble | 1985-03-19 |
| 10389 | Make Peir | 1995-10-31 |
| 10390 | Wanqing Bratten | 1989-05-17 |
| 10391 | Hongzue Akaboshi | 1989-12-24 |
| 10393 | Yagil DasSarma | 1989-06-23 |
| 10394 | Shawna Meriste | 1991-03-14 |
| 10397 | Irena Reutenauer | 1993-05-21 |
| 10404 | Prodip Rosti | 1988-08-28 |
| 10408 | Martijn Kaiser | 1998-10-07 |
| 10413 | Danel Impagliazzo | 1990-03-26 |
| 10414 | Yinlin Alpin | 1990-05-30 |
| 10418 | Candida Porotnikoff | 1989-04-20 |
| 10423 | Dante Cronin | 1998-09-06 |
| 10425 | Sashi Osgood | 1991-10-29 |
| 10432 | Hisao Tiemann | 1985-04-30 |
| 10433 | Reuven Dengi | 1989-02-14 |
| 10434 | Dzung Peltason | 1995-06-27 |
| 10435 | Marsha Tagansky | 1986-12-19 |
| 10436 | Yahiko Lammel | 1988-01-30 |
| 10440 | Akeel Narahara | 1994-03-31 |
| 10444 | Kazuhira Rosis | 1993-03-31 |
| 10446 | Ebru Chepyzhov | 1994-11-17 |
| 10447 | Ronghao Yavatkar | 1988-12-29 |
| 10455 | Sverrir Streng | 1989-02-14 |
| 10456 | Stepehn Hardjono | 1995-12-25 |
| 10457 | Oddvar Schlenzig | 1991-11-23 |
| 10459 | Ennio Trogemann | 1997-06-28 |
| 10460 | Shushma VanScheik | 1994-07-01 |
| 10463 | Ung Zaiane | 1987-12-25 |
| 10466 | Jiakeng Himler | 1985-09-29 |
| 10472 | Salvador Lodder | 1996-07-29 |
| 10473 | Przemyslawa Oskamp | 1987-10-30 |
| 10479 | Duro Coney | 1987-02-28 |
| 10484 | Nirmal Varley | 1995-10-31 |
| 10485 | Teruyuki Sundgren | 1985-10-27 |
| 10492 | Lobel Kumaresan | 1988-04-24 |
| 10493 | Maris Haraldson | 1992-05-16 |
| 10495 | Anyuan Zhiwei | 1985-09-29 |
| 10497 | Pramod Rabehasaina | 1992-01-22 |
+-------+------------------------+------------+
155 rows in set (0.48 sec)
mysql> #因为年的关系 所以会出现多个啊
mysql>
mysql> #相关子查询
mysql> select id, concat(first_name,' ',last_name) as name, worktime
-> from new_emp as a
-> where worktime =
-> (select max(worktime)
-> from new_emp as b
-> where a.id = b.id);
+-------+---------------------------+------------+
| id | name | worktime |
+-------+---------------------------+------------+
| 10001 | Georgi Facello | 1986-06-26 |
| 10002 | Bezalel Simmel | 1985-11-21 |
| 10003 | Parto Bamford | 1986-08-28 |
| 10004 | Chirstian Koblick | 1986-12-01 |
| 10005 | Kyoichi Maliniak | 1989-09-12 |
| 10006 | Anneke Preusig | 1989-06-02 |
| 10007 | Tzvetan Zielinski | 1989-02-10 |
| 10008 | Saniya Kalloufi | 1994-09-15 |
| 10009 | Sumant Peac | 1985-02-18 |
| 10010 | Duangkaew Piveteau | 1989-08-24 |
| 10011 | Mary Sluis | 1990-01-22 |
| 10012 | Patricio Bridgland | 1992-12-18 |
| 10013 | Eberhardt Terkki | 1985-10-20 |
| 10014 | Berni Genin | 1987-03-11 |
| 10015 | Guoxiang Nooteboom | 1987-07-02 |
| 10016 | Kazuhito Cappelletti | 1995-01-27 |
| 10017 | Cristinel Bouloucos | 1993-08-03 |
| 10018 | Kazuhide Peha | 1987-04-03 |
| 10019 | Lillian Haddadi | 1999-04-30 |
| 10020 | Mayuko Warwick | 1991-01-26 |
| 10021 | Ramzi Erde | 1988-02-10 |
| 10022 | Shahaf Famili | 1995-08-22 |
| 10023 | Bojan Montemayor | 1989-12-17 |
| 10024 | Suzette Pettey | 1997-05-19 |
| 10025 | Prasadram Heyers | 1987-08-17 |
| 10026 | Yongqiao Berztiss | 1995-03-20 |
| 10027 | Divier Reistad | 1989-07-07 |
| 10028 | Domenick Tempesti | 1991-10-22 |
| 10029 | Otmar Herbst | 1985-11-20 |
| 10030 | Elvis Demeyer | 1994-02-17 |
| 10031 | Karsten Joslin | 1991-09-01 |
| 10032 | Jeong Reistad | 1990-06-20 |
| 10033 | Arif Merlo | 1987-03-18 |
| 10034 | Bader Swan | 1988-09-21 |
| 10035 | Alain Chappelet | 1988-09-05 |
| 10036 | Adamantios Portugali | 1992-01-03 |
| 10037 | Pradeep Makrucki | 1990-12-05 |
| 10038 | Huan Lortz | 1989-09-20 |
| 10039 | Alejandro Brender | 1988-01-19 |
| 10040 | Weiyi Meriste | 1993-02-14 |
| 10041 | Uri Lenart | 1989-11-12 |
| 10042 | Magy Stamatiou | 1993-03-21 |
| 10043 | Yishay Tzvieli | 1990-10-20 |
| 10044 | Mingsen Casley | 1994-05-21 |
| 10045 | Moss Shanbhogue | 1989-09-02 |
| 10046 | Lucien Rosenbaum | 1992-06-20 |
| 10047 | Zvonko Nyanchama | 1989-03-31 |
| 10048 | Florian Syrotiuk | 1985-02-24 |
| 10049 | Basil Tramer | 1992-05-04 |
| 10050 | Yinghua Dredge | 1990-12-25 |
| 10051 | Hidefumi Caine | 1992-10-15 |
| 10052 | Heping Nitsch | 1988-05-21 |
| 10053 | Sanjiv Zschoche | 1986-02-04 |
| 10054 | Mayumi Schueller | 1995-03-13 |
| 10055 | Georgy Dredge | 1992-04-27 |
| 10056 | Brendon Bernini | 1990-02-01 |
| 10057 | Ebbe Callaway | 1992-01-15 |
| 10058 | Berhard McFarlin | 1987-04-13 |
| 10059 | Alejandro McAlpine | 1991-06-26 |
| 10060 | Breannda Billingsley | 1987-11-02 |
| 10061 | Tse Herber | 1985-09-17 |
| 10062 | Anoosh Peyn | 1991-08-30 |
| 10063 | Gino Leonhardt | 1989-04-08 |
| 10064 | Udi Jansch | 1985-11-20 |
| 10065 | Satosi Awdeh | 1988-05-18 |
| 10066 | Kwee Schusler | 1986-02-26 |
| 10067 | Claudi Stavenow | 1987-03-04 |
| 10068 | Charlene Brattka | 1987-08-07 |
| 10069 | Margareta Bierman | 1989-11-05 |
| 10070 | Reuven Garigliano | 1985-10-14 |
| 10071 | Hisao Lipner | 1987-10-01 |
| 10072 | Hironoby Sidou | 1988-07-21 |
| 10073 | Shir McClurg | 1991-12-01 |
| 10074 | Mokhtar Bernatsky | 1990-08-13 |
| 10075 | Gao Dolinsky | 1987-03-19 |
| 10076 | Erez Ritzmann | 1985-07-09 |
| 10077 | Mona Azuma | 1990-03-02 |
| 10078 | Danel Mondadori | 1987-05-26 |
| 10079 | Kshitij Gils | 1986-03-27 |
| 10080 | Premal Baek | 1985-11-19 |
| 10081 | Zhongwei Rosen | 1986-10-30 |
| 10082 | Parviz Lortz | 1990-01-03 |
| 10083 | Vishv Zockler | 1987-03-31 |
| 10084 | Tuval Kalloufi | 1995-12-15 |
| 10085 | Kenroku Malabarba | 1994-04-09 |
| 10086 | Somnath Foote | 1990-02-16 |
| 10087 | Xinglin Eugenio | 1986-09-08 |
| 10088 | Jungsoon Syrzycki | 1988-09-02 |
| 10089 | Sudharsan Flasterstein | 1986-08-12 |
| 10090 | Kendra Hofting | 1986-03-14 |
| 10091 | Amabile Gomatam | 1992-11-18 |
| 10092 | Valdiodio Niizuma | 1989-09-22 |
| 10093 | Sailaja Desikan | 1996-11-05 |
| 10094 | Arumugam Ossenbruggen | 1987-04-18 |
| 10095 | Hilari Morton | 1986-07-15 |
| 10096 | Jayson Mandell | 1990-01-14 |
| 10097 | Remzi Waschkowski | 1990-09-15 |
| 10098 | Sreekrishna Servieres | 1985-05-13 |
| 10099 | Valter Sullins | 1988-10-18 |
| 10100 | Hironobu Haraldson | 1987-09-21 |
| 10101 | Perla Heyers | 1992-12-28 |
| 10102 | Paraskevi Luby | 1994-01-26 |
| 10103 | Akemi Birch | 1986-12-02 |
| 10104 | Xinyu Warwick | 1987-04-16 |
| 10105 | Hironoby Piveteau | 1999-03-23 |
| 10106 | Eben Aingworth | 1990-12-19 |
| 10107 | Dung Baca | 1994-03-22 |
| 10108 | Lunjin Giveon | 1986-10-02 |
| 10109 | Mariusz Prampolini | 1993-06-16 |
| 10110 | Xuejia Ullian | 1986-08-22 |
| 10111 | Hugo Rosis | 1988-06-19 |
| 10112 | Yuichiro Swick | 1985-10-08 |
| 10113 | Jaewon Syrzycki | 1989-12-24 |
| 10114 | Munir Demeyer | 1992-07-17 |
| 10115 | Chikara Rissland | 1986-01-23 |
| 10116 | Dayanand Czap | 1985-05-28 |
| 10117 | Kiyotoshi Blokdijk | 1990-05-28 |
| 10118 | Zhonghui Zyda | 1990-09-13 |
| 10119 | Domenick Peltason | 1986-03-14 |
| 10120 | Armond Fairtlough | 1996-07-06 |
| 10121 | Guoxiang Ramsay | 1989-05-03 |
| 10122 | Ohad Esposito | 1992-12-23 |
| 10123 | Hinrich Randi | 1993-01-15 |
| 10124 | Geraldo Marwedel | 1991-09-05 |
| 10125 | Syozo Hiltgen | 1990-10-26 |
| 10126 | Kayoko Valtorta | 1985-09-08 |
| 10127 | Subir Baja | 1989-01-14 |
| 10128 | Babette Lamba | 1988-06-06 |
| 10129 | Armond Peir | 1985-12-10 |
| 10130 | Nishit Casperson | 1988-06-21 |
| 10131 | Magdalena Eldridge | 1994-11-17 |
| 10132 | Ayakannu Skrikant | 1994-10-30 |
| 10133 | Giri Isaak | 1985-12-15 |
| 10134 | Diederik Siprelle | 1987-12-12 |
| 10135 | Nathan Monkewich | 1988-02-19 |
| 10136 | Zissis Pintelas | 1986-02-11 |
| 10137 | Maren Hutton | 1985-02-18 |
| 10138 | Perry Shimshoni | 1986-09-18 |
| 10139 | Ewing Foong | 1998-03-15 |
| 10140 | Yucel Auria | 1991-03-14 |
| 10141 | Shahaf Ishibashi | 1993-05-06 |
| 10142 | Tzvetan Hettesheimer | 1993-10-28 |
| 10143 | Sakthirel Bakhtari | 1988-09-30 |
| 10144 | Marla Brendel | 1985-10-14 |
| 10145 | Akemi Esposito | 1987-08-01 |
| 10146 | Chenyi Syang | 1988-06-28 |
| 10147 | Kazuhito Encarnacion | 1986-08-21 |
| 10148 | Douadi Azumi | 1995-10-10 |
| 10149 | Xiadong Perry | 1986-11-05 |
| 10150 | Zhenbing Perng | 1986-11-16 |
| 10151 | Itzchak Lichtner | 1990-04-10 |
| 10152 | Jaques Munro | 1986-01-27 |
| 10153 | Heekeun Majewski | 1987-04-08 |
| 10154 | Abdulah Thibadeau | 1990-12-12 |
| 10155 | Adas Nastansky | 1990-01-05 |
| 10156 | Sumali Fargier | 1985-03-10 |
| 10157 | Nigel Aloisi | 1985-11-02 |
| 10158 | Khedija Mitsuhashi | 1986-01-29 |
| 10159 | Serif Buescher | 1991-05-29 |
| 10160 | Debatosh Khasidashvili | 1989-01-30 |
| 10161 | Hairong Mellouli | 1988-04-03 |
| 10162 | Florina Eugenio | 1991-05-01 |
| 10163 | Karsten Szmurlo | 1989-07-19 |
| 10164 | Jagoda Braunmuhl | 1985-11-12 |
| 10165 | Miyeon Macedo | 1988-05-17 |
| 10166 | Samphel Siegrist | 1993-01-01 |
| 10167 | Duangkaew Rassart | 1992-04-04 |
| 10168 | Dharmaraja Stassinopoulos | 1986-12-06 |
| 10169 | Sampalli Snedden | 1992-07-24 |
| 10170 | Kasturi Jenevein | 1986-01-02 |
| 10171 | Herbert Trachtenberg | 1989-07-22 |
| 10172 | Shigeu Matzen | 1995-10-13 |
| 10173 | Shrikanth Mahmud | 1992-03-21 |
| 10174 | Badri Furudate | 1987-06-01 |
| 10175 | Aleksandar Ananiadou | 1988-01-11 |
| 10176 | Brendon Lenart | 1994-12-22 |
| 10177 | Pragnesh Iisaka | 1993-02-06 |
| 10178 | Valery Litvinov | 1986-10-07 |
| 10179 | Deniz Duclos | 1990-10-04 |
| 10180 | Shaw Wendorf | 1986-02-25 |
| 10181 | Sibyl Nooteboom | 1988-06-22 |
| 10182 | Moriyoshi Merey | 1990-09-02 |
| 10183 | Mechthild Bonifati | 1996-08-11 |
| 10184 | Mihalis Lowrie | 1987-10-29 |
| 10185 | Duro Sidhu | 1986-03-01 |
| 10186 | Shigehito Kropatsch | 1986-03-28 |
| 10187 | Tommaso Narwekar | 1991-06-01 |
| 10188 | Christ Muchinsky | 1987-08-27 |
| 10189 | Khalid Erva | 1989-10-05 |
| 10190 | Arve Fairtlough | 1986-06-23 |
| 10191 | Zdislav Nastansky | 1986-04-10 |
| 10192 | Mohua Falck | 1988-06-13 |
| 10193 | Masaru Cheshire | 1991-07-28 |
| 10194 | Josyula Hofmeyr | 1989-05-15 |
| 10195 | Annemarie Redmiles | 1985-02-15 |
| 10196 | Marc Hellwagner | 1994-11-16 |
| 10197 | Kasidit Krzyzanowski | 1993-11-22 |
| 10198 | Pranav Furedi | 1985-08-31 |
| 10199 | Kazuhisa Ranta | 1997-04-29 |
| 10200 | Vidya Awdeh | 1985-10-16 |
| 10201 | Idoia Kavraki | 1986-11-22 |
| 10202 | Greger Lichtner | 1991-10-06 |
| 10203 | Steen Escriba | 1989-04-06 |
| 10204 | Nevio Ritcey | 1986-12-04 |
| 10205 | Mabhin Leijenhorst | 1993-08-23 |
| 10206 | Alassane Iwayama | 1988-04-19 |
| 10207 | Girolamo Anandan | 1992-10-11 |
| 10208 | Xiping Klerer | 1991-12-23 |
| 10209 | Yolla Ellozy | 1991-11-23 |
| 10210 | Yuping Alpin | 1994-05-10 |
| 10211 | Vishu Strehl | 1989-11-18 |
| 10212 | Divier Esteva | 1990-07-11 |
| 10213 | Jackson Kakkad | 1992-11-06 |
| 10214 | Tadahiko Ciolek | 1988-02-29 |
| 10215 | Xiaobin Duclos | 1987-10-19 |
| 10216 | Amstein Ghemri | 1987-10-30 |
| 10217 | Yongmin Roison | 1986-05-12 |
| 10218 | Zhenhua Magalhaes | 1997-01-15 |
| 10219 | Genta Kolvik | 1993-03-31 |
| 10220 | Kish Fasbender | 1992-06-25 |
| 10221 | Yucai Granlund | 1988-06-08 |
| 10222 | Tze Nourani | 1986-06-08 |
| 10223 | Carrsten Schmiedel | 1985-11-18 |
| 10224 | Leon Trogemann | 1988-01-09 |
| 10225 | Kellie Chinen | 1986-06-19 |
| 10226 | Xinglin Plessier | 1989-10-27 |
| 10227 | Anneli Kaiser | 1994-04-24 |
| 10228 | Karoline Cesareni | 1991-08-26 |
| 10229 | Ulises Takanami | 1987-11-22 |
| 10230 | Clyde Vernadat | 1996-06-16 |
| 10231 | Shaowen Desikan | 1996-04-13 |
| 10232 | Marko Auria | 1992-06-04 |
| 10233 | Lein Vendrig | 1985-07-05 |
| 10234 | Arunachalam Bakhtari | 1990-11-19 |
| 10235 | Susanta Roccetti | 1995-04-06 |
| 10236 | Susumu Bade | 1996-08-30 |
| 10237 | Yannis Mandell | 1989-08-11 |
| 10238 | Mototsugu Gire | 1986-11-19 |
| 10239 | Nikolaos Llado | 1995-05-08 |
| 10240 | Remko Maccarone | 1998-10-06 |
| 10241 | Ortrud Murillo | 1988-06-12 |
| 10242 | Lunjin Ozeri | 1988-01-18 |
| 10243 | Wonhee Pouyioutas | 1985-11-24 |
| 10244 | Foong Flasterstein | 1985-12-23 |
| 10245 | Ramalingam Gente | 1985-04-26 |
| 10246 | Basem Teitelbaum | 1987-07-12 |
| 10247 | Heon Riefers | 1992-08-14 |
| 10248 | Frederique Tempesti | 1991-08-13 |
| 10249 | Marie Boreale | 1991-12-08 |
| 10250 | Serap Etalle | 1992-08-30 |
| 10251 | Alair Rosenbaum | 1992-06-25 |
| 10252 | Shirish Wegerle | 1990-11-08 |
| 10253 | Zsolt Salinas | 1985-02-21 |
| 10254 | Shen Brattka | 1990-06-14 |
| 10255 | Roddy Garnick | 1993-05-12 |
| 10256 | Irene Radhakrishnan | 1985-10-12 |
| 10257 | Aiman Riexinger | 1986-08-05 |
| 10258 | Basil Ishibashi | 1985-05-17 |
| 10259 | Susanna Vesel | 1986-06-25 |
| 10260 | Alper Suomi | 1991-04-13 |
| 10261 | Mang Erie | 1993-10-20 |
| 10262 | Mahendra Maraist | 1992-07-27 |
| 10263 | Takahiro Waterhouse | 1994-02-05 |
| 10264 | Nalini Kawashimo | 1997-07-16 |
| 10265 | Ramalingam Muniz | 1989-07-13 |
| 10266 | Sukumar Rassart | 1990-05-25 |
| 10267 | Shaunak Cullers | 1996-12-11 |
| 10268 | Nishit Siochi | 1986-12-17 |
| 10269 | Taizo Oxman | 1988-07-24 |
| 10270 | Bedir Hartvigsen | 1990-04-26 |
| 10271 | Sham Eastman | 1986-05-23 |
| 10272 | Yishai Cannane | 1988-05-23 |
| 10273 | Baocai Lieblein | 1985-11-06 |
| 10274 | Dmitri Pearson | 1991-04-21 |
| 10275 | Marek Luck | 1987-09-08 |
| 10276 | Xuejun Hempstead | 1985-07-21 |
| 10277 | Isaac Schwartzbauer | 1985-06-16 |
| 10278 | Lubomir Nitsch | 1991-05-17 |
| 10279 | Barton Jumpertz | 1994-12-20 |
| 10280 | Stabislas Delgrange | 1988-03-18 |
| 10281 | Moty Kusakari | 1994-12-03 |
| 10282 | Hercules Benzmuller | 1986-06-04 |
| 10283 | Kauko Birjandi | 1988-05-25 |
| 10284 | Masali Murrill | 1997-07-02 |
| 10285 | Zhonghui Preusig | 1995-02-27 |
| 10286 | Saddek Gopalakrishnan | 1988-03-21 |
| 10287 | Marie Pietracaprina | 1992-12-28 |
| 10288 | Selwyn Perri | 1994-08-29 |
| 10289 | Shay Poulakidas | 1990-06-06 |
| 10290 | Yongmao Pleszkun | 1991-09-18 |
| 10291 | Dipayan Seghrouchni | 1986-09-29 |
| 10292 | Yucel Ghelli | 1989-06-05 |
| 10293 | Mihalis Avouris | 1992-12-12 |
| 10294 | Rutger Miara | 1996-04-08 |
| 10295 | Kristine Velardi | 1990-08-27 |
| 10296 | Petter Lorho | 1989-09-16 |
| 10297 | Narain Oaver | 1986-05-28 |
| 10298 | Dietrich DuCasse | 1999-03-30 |
| 10299 | Ipke Stentiford | 1990-01-10 |
| 10300 | Tadahiko Ulupinar | 1991-05-17 |
| 10301 | Lucien Staudhammer | 1988-05-23 |
| 10302 | Faiza Baer | 1986-07-22 |
| 10303 | Marlo Zschoche | 1990-02-05 |
| 10304 | Bernt Erie | 1992-11-16 |
| 10305 | Hirochika Piancastelli | 1988-10-31 |
| 10306 | Heng Kilgour | 1993-09-06 |
| 10307 | Nikolaos Leaver | 1991-04-10 |
| 10308 | Dzung Holburn | 1992-12-29 |
| 10309 | Prodip Schusler | 1985-06-20 |
| 10310 | Aksel Alencar | 1990-10-24 |
| 10311 | Hsiangchu Molenkamp | 1991-04-01 |
| 10312 | Rasiah Deyuan | 1986-08-28 |
| 10313 | Subbu Riexinger | 1994-10-10 |
| 10314 | Christfried Apsitis | 1986-01-16 |
| 10315 | Maris Angelopoulos | 1987-08-28 |
| 10316 | Christoper Schwaller | 1987-09-04 |
| 10317 | Arie Birge | 1986-12-10 |
| 10318 | Mototsugu Beilner | 1985-06-29 |
| 10319 | Mechthild Miyakawa | 1985-08-15 |
| 10320 | Uinam Stasinski | 1988-11-03 |
| 10321 | Guenter Ravishankar | 1991-09-24 |
| 10322 | Isamu Dahlbom | 1990-01-29 |
| 10323 | Kankanahalli Hinsberger | 1991-06-06 |
| 10324 | Bernardo Rouquie | 1988-03-19 |
| 10325 | Arunachalam Badr | 1990-09-20 |
| 10326 | Masali Czap | 1985-05-13 |
| 10327 | Roded Facello | 1987-09-18 |
| 10328 | Serenella Kawashima | 1994-01-16 |
| 10329 | Remko Shigei | 1986-01-20 |
| 10330 | Kasturi Bellmore | 1985-06-12 |
| 10331 | Arto Binkley | 1985-04-06 |
| 10332 | Masanao Bain | 1988-06-08 |
| 10333 | Snehasis Dymetman | 1993-01-16 |
| 10334 | Falguni Erie | 1996-12-28 |
| 10335 | Toshimori Bahi | 1992-04-06 |
| 10336 | Goa Rothe | 1992-01-07 |
| 10337 | Jeong Sadowsky | 1995-08-06 |
| 10338 | Heon Ranai | 1988-09-01 |
| 10339 | Teunis Liedekerke | 1989-11-30 |
| 10340 | Djelloul Laventhal | 1987-06-05 |
| 10341 | Wilmer Greenaway | 1987-04-29 |
| 10342 | Stella Hiroyama | 1987-07-25 |
| 10343 | Dinah Syrzycki | 1993-10-14 |
| 10344 | Uwe Garnier | 1994-06-25 |
| 10345 | Arra Ratnakar | 1993-11-08 |
| 10346 | Aamod Radwan | 1987-01-27 |
| 10347 | Pradeep Kaminger | 1985-12-12 |
| 10348 | Mahendra Picco | 1995-10-22 |
| 10349 | Oksana Brodie | 1991-09-28 |
| 10350 | Kristen Kavvadias | 1990-08-19 |
| 10351 | Tadahiko Strehl | 1985-03-07 |
| 10352 | Erzsebet Ohori | 1996-01-21 |
| 10353 | Phule Hammerschmidt | 1989-08-24 |
| 10354 | Moto Kusakari | 1996-03-26 |
| 10355 | Satyanarayana Cochrane | 1987-11-15 |
| 10356 | Vasilis Standera | 1988-08-06 |
| 10357 | Hausi Sidhu | 1994-04-04 |
| 10358 | Qunsheng Tagansky | 1991-02-19 |
| 10359 | Heekeun Sambasivam | 1991-05-09 |
| 10360 | Irene Munck | 1996-09-04 |
| 10361 | Seshu Sidou | 1986-10-23 |
| 10362 | Shalesh dAstous | 1988-08-24 |
| 10363 | Toshiki Muniz | 1985-09-11 |
| 10364 | Nakhoon Dengi | 1985-11-14 |
| 10365 | Rosine Granlund | 1987-06-02 |
| 10366 | Morrie Piazza | 1994-04-11 |
| 10367 | Hyuckchul Gini | 1991-06-24 |
| 10368 | Hatim Koshiba | 1991-04-05 |
| 10369 | Qunsheng Toyoshima | 1986-05-17 |
| 10370 | Clyde Fandrianto | 1992-04-04 |
| 10371 | Ioana Kirkerud | 1989-11-28 |
| 10372 | Anneli Frijda | 1985-07-30 |
| 10373 | Hongzue Heijenga | 1997-04-26 |
| 10374 | Willard Rosin | 1993-12-08 |
| 10375 | Dante Kalafatis | 1994-05-29 |
| 10376 | Fai Bale | 1989-01-14 |
| 10377 | Marl Grospietsch | 1990-05-07 |
| 10378 | Takahira Lichtner | 1990-12-30 |
| 10379 | Mikhail Rosis | 1996-07-15 |
| 10380 | Alejandro Kamble | 1985-03-19 |
| 10381 | Jiong Parfitt | 1991-12-04 |
| 10382 | Shirish Dredge | 1990-07-04 |
| 10383 | Leucio Aumann | 1991-06-19 |
| 10384 | Feiyu Luft | 1986-01-16 |
| 10385 | Khatoun Imataki | 1992-12-20 |
| 10386 | Eishiro Miyakawa | 1985-08-02 |
| 10387 | Parto Wrigley | 1987-02-19 |
| 10388 | Hironoby Kaiser | 1996-03-24 |
| 10389 | Make Peir | 1995-10-31 |
| 10390 | Wanqing Bratten | 1989-05-17 |
| 10391 | Hongzue Akaboshi | 1989-12-24 |
| 10392 | Jiann Hainaut | 1992-03-01 |
| 10393 | Yagil DasSarma | 1989-06-23 |
| 10394 | Shawna Meriste | 1991-03-14 |
| 10395 | Takahiro Deverell | 1987-02-04 |
| 10396 | Sibyl Rahier | 1986-01-11 |
| 10397 | Irena Reutenauer | 1993-05-21 |
| 10398 | Shooichi Escriba | 1990-10-12 |
| 10399 | Guenter Marchegay | 1985-05-07 |
| 10400 | Ortrud Nitto | 1993-10-17 |
| 10401 | Eckart Barriga | 1991-04-05 |
| 10402 | Volkmar Ebeling | 1987-01-02 |
| 10403 | Atreyi Mungall | 1991-09-13 |
| 10404 | Prodip Rosti | 1988-08-28 |
| 10405 | Hilary Budinsky | 1985-11-04 |
| 10406 | Sigeru Wynblatt | 1987-03-11 |
| 10407 | Ulf Siepmann | 1990-03-08 |
| 10408 | Martijn Kaiser | 1998-10-07 |
| 10409 | Mario Straney | 1997-07-09 |
| 10410 | Takahito Gecsei | 1993-10-16 |
| 10411 | Lidong Klerer | 1989-09-02 |
| 10412 | Masoud Fabrizio | 1986-05-06 |
| 10413 | Danel Impagliazzo | 1990-03-26 |
| 10414 | Yinlin Alpin | 1990-05-30 |
| 10415 | Mark Coorg | 1993-10-25 |
| 10416 | Uli Keustermans | 1989-03-24 |
| 10417 | Bingning Bakhtari | 1992-03-12 |
| 10418 | Candida Porotnikoff | 1989-04-20 |
| 10419 | Maria Bauknecht | 1992-04-25 |
| 10420 | Kaijung Riesenhuber | 1988-01-17 |
| 10421 | Divine Marzano | 1989-09-12 |
| 10422 | Greger Rubsam | 1990-12-07 |
| 10423 | Dante Cronin | 1998-09-06 |
| 10424 | Babette Straney | 1989-08-07 |
| 10425 | Sashi Osgood | 1991-10-29 |
| 10426 | Arunas Luce | 1985-07-06 |
| 10427 | Khosrow Sudbeck | 1991-11-01 |
| 10428 | Cathie Brlek | 1992-06-04 |
| 10429 | Martien Improta | 1986-03-09 |
| 10430 | Ferdinand Chenney | 1990-11-16 |
| 10431 | Patricio Bugrara | 1987-10-08 |
| 10432 | Hisao Tiemann | 1985-04-30 |
| 10433 | Reuven Dengi | 1989-02-14 |
| 10434 | Dzung Peltason | 1995-06-27 |
| 10435 | Marsha Tagansky | 1986-12-19 |
| 10436 | Yahiko Lammel | 1988-01-30 |
| 10437 | Narain Reeker | 1996-04-12 |
| 10438 | Evgueni Srimani | 1990-01-19 |
| 10439 | Jolita Jarecki | 1990-01-11 |
| 10440 | Akeel Narahara | 1994-03-31 |
| 10441 | Adel Perfilyeva | 1988-07-12 |
| 10442 | Volkmar Unno | 1988-03-13 |
| 10443 | Shichao Litvinov | 1989-08-01 |
| 10444 | Kazuhira Rosis | 1993-03-31 |
| 10445 | Junichi Kavanagh | 1987-11-04 |
| 10446 | Ebru Chepyzhov | 1994-11-17 |
| 10447 | Ronghao Yavatkar | 1988-12-29 |
| 10448 | Phule Oxenboll | 1992-03-12 |
| 10449 | Aleksandar Sudkamp | 1987-03-28 |
| 10450 | Khun Harbusch | 1990-01-17 |
| 10451 | Bodh Ranta | 1988-03-12 |
| 10452 | Werner Hasham | 1988-09-05 |
| 10453 | Tsvetan Matzel | 1985-04-02 |
| 10454 | Wonhee Badr | 1987-04-10 |
| 10455 | Sverrir Streng | 1989-02-14 |
| 10456 | Stepehn Hardjono | 1995-12-25 |
| 10457 | Oddvar Schlenzig | 1991-11-23 |
| 10458 | Gina Engelmann | 1988-07-23 |
| 10459 | Ennio Trogemann | 1997-06-28 |
| 10460 | Shushma VanScheik | 1994-07-01 |
| 10461 | Gal Karcich | 1987-08-03 |
| 10462 | Sumali Schlenzig | 1996-03-25 |
| 10463 | Ung Zaiane | 1987-12-25 |
| 10464 | Mang Maginnis | 1989-10-09 |
| 10465 | Claudi Shackel | 1987-09-01 |
| 10466 | Jiakeng Himler | 1985-09-29 |
| 10467 | Dipayan Suomi | 1988-07-14 |
| 10468 | Yoshimitsu Shobatake | 1991-05-28 |
| 10469 | Munehiko Ananiadou | 1985-06-05 |
| 10470 | Peternela Iwayama | 1988-06-01 |
| 10471 | Jouko Yamaashi | 1990-11-18 |
| 10472 | Salvador Lodder | 1996-07-29 |
| 10473 | Przemyslawa Oskamp | 1987-10-30 |
| 10474 | Kenton Garnham | 1985-09-28 |
| 10475 | Mario Rodite | 1987-01-19 |
| 10476 | Kokou Iisaka | 1987-09-20 |
| 10477 | Guoxiang Trogemann | 1989-03-04 |
| 10478 | Maik Ushiama | 1992-06-09 |
| 10479 | Duro Coney | 1987-02-28 |
| 10480 | Make Baba | 1988-05-18 |
| 10481 | Yongmao Pintelas | 1988-10-06 |
| 10482 | Goa Pleszkun | 1991-07-20 |
| 10483 | Zhiwei Anick | 1992-11-08 |
| 10484 | Nirmal Varley | 1995-10-31 |
| 10485 | Teruyuki Sundgren | 1985-10-27 |
| 10486 | Amstein Kossowski | 1987-10-08 |
| 10487 | Perla Middleton | 1992-08-14 |
| 10488 | Mihalis Heering | 1994-06-09 |
| 10489 | Elvia Homond | 1989-09-10 |
| 10490 | Huiqun Vuskovic | 1992-10-07 |
| 10491 | Garnik Narahari | 1990-01-17 |
| 10492 | Lobel Kumaresan | 1988-04-24 |
| 10493 | Maris Haraldson | 1992-05-16 |
| 10494 | Yakkov Servieres | 1986-01-18 |
| 10495 | Anyuan Zhiwei | 1985-09-29 |
| 10496 | Gretta Baig | 1987-02-26 |
| 10497 | Pramod Rabehasaina | 1992-01-22 |
| 10498 | Valter Cappelletti | 1988-02-01 |
| 10499 | Maik Luft | 1989-11-23 |
| 10500 | Vojin Narwekar | 1996-12-16 |
+-------+---------------------------+------------+
500 rows in set (0.00 sec)
mysql> #由此观之 上次的查询还有问题(统一个表中笛卡尔积好像不正确)
mysql>
mysql> exit
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_test |
+----------------+
| Nums |
| a |
| charTest |
| customers |
| employees |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| yeartest |
| z |
+----------------+
17 rows in set (0.00 sec)
mysql> #数据按照主键顺序 还要order by 干嘛?
mysql> #其实不然, 数据并非总是按照主键顺序排序的 这里Innodb引擎不是索引组织表码?
mysql> #写个例子
mysql> create table animals(id int primary key, name varchar(20), unique key(name))engine=innodb;
Query OK, 0 rows affected (0.10 sec)
mysql> insert into animals select 1,'Tiger';
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into animals select 2,'Dog';
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into animals select 3,'Cat';
Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from animals;
+----+-------+
| id | name |
+----+-------+
| 3 | Cat |
| 2 | Dog |
| 1 | Tiger |
+----+-------+
3 rows in set (0.00 sec)
mysql> #哇 有主键id,但是查询结果出人意料,所以得出结论,对于没有使用order by子句的查询结果 其结果永远不会是按照主键顺序进行排列的 因为没有order by子句的查询只代表从结合中查询数据 而集合是没有顺序概念的
mysql>
mysql> select * from animals order by id asc;
+----+-------+
| id | name |
+----+-------+
| 1 | Tiger |
| 2 | Dog |
| 3 | Cat |
+----+-------+
3 rows in set (0.00 sec)
mysql> show status;
+------------------------------------------+-------------+
| Variable_name | Value |
+------------------------------------------+-------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 698 |
| Bytes_sent | 3987 |
| Com_admin_commands | 0 |
| Com_assign_to_keycache | 0 |
| Com_alter_db | 0 |
| Com_alter_db_upgrade | 0 |
| Com_alter_event | 0 |
| Com_alter_function | 0 |
| Com_alter_procedure | 0 |
| Com_alter_server | 0 |
| Com_alter_table | 0 |
| Com_alter_tablespace | 0 |
| Com_analyze | 0 |
| Com_begin | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 1 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_procedure | 0 |
| Com_create_server | 0 |
| Com_create_table | 1 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_procedure | 0 |
| Com_drop_server | 0 |
| Com_drop_table | 0 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 0 |
| Com_insert_select | 3 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 0 |
| Com_rename_table | 0 |
| Com_rename_user | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_resignal | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 4 |
| Com_set_option | 0 |
| Com_signal | 0 |
| Com_show_authors | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_contributors | 0 |
| Com_show_create_db | 0 |
| Com_show_create_event | 0 |
| Com_show_create_func | 0 |
| Com_show_create_proc | 0 |
| Com_show_create_table | 0 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 1 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 0 |
| Com_show_events | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 17 |
| Com_show_function_status | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges | 0 |
| Com_show_procedure_status | 0 |
| Com_show_processlist | 0 |
| Com_show_profile | 0 |
| Com_show_profiles | 0 |
| Com_show_relaylog_events | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_table_status | 0 |
| Com_show_tables | 2 |
| Com_show_triggers | 0 |
| Com_show_variables | 0 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 0 |
| Com_update | 0 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 38 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 5 |
| Created_tmp_tables | 3 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 5 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 2 |
| Handler_read_key | 2 |
| Handler_read_last | 0 |
| Handler_read_next | 6 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 44 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 0 |
| Handler_write | 44 |
| Innodb_buffer_pool_pages_data | 475 |
| Innodb_buffer_pool_bytes_data | 7782400 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 22 |
| Innodb_buffer_pool_pages_free | 7716 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 8192 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 6063 |
| Innodb_buffer_pool_reads | 474 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 62 |
| Innodb_data_fsyncs | 19 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 9949184 |
| Innodb_data_reads | 484 |
| Innodb_data_writes | 27 |
| Innodb_data_written | 730112 |
| Innodb_dblwr_pages_written | 22 |
| Innodb_dblwr_writes | 4 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 7 |
| Innodb_log_writes | 5 |
| Innodb_os_log_fsyncs | 11 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 6144 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 2 |
| Innodb_pages_read | 473 |
| Innodb_pages_written | 22 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 3 |
| Innodb_rows_read | 6 |
| Innodb_rows_updated | 0 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 13394 |
| Key_blocks_used | 2 |
| Key_read_requests | 8 |
| Key_reads | 2 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Last_query_cost | 4.599000 |
| Max_used_connections | 1 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 50 |
| Open_streams | 0 |
| Open_table_definitions | 91 |
| Open_tables | 91 |
| Opened_files | 391 |
| Opened_table_definitions | 2 |
| Opened_tables | 2 |
| Performance_schema_cond_classes_lost | 0 |
| Performance_schema_cond_instances_lost | 0 |
| Performance_schema_file_classes_lost | 0 |
| Performance_schema_file_handles_lost | 0 |
| Performance_schema_file_instances_lost | 0 |
| Performance_schema_locker_lost | 0 |
| Performance_schema_mutex_classes_lost | 0 |
| Performance_schema_mutex_instances_lost | 0 |
| Performance_schema_rwlock_classes_lost | 0 |
| Performance_schema_rwlock_instances_lost | 0 |
| Performance_schema_table_handles_lost | 0 |
| Performance_schema_table_instances_lost | 0 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 16757136 |
| Qcache_hits | 0 |
| Qcache_inserts | 2 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 71 |
| Qcache_queries_in_cache | 2 |
| Qcache_total_blocks | 6 |
| Queries | 138 |
| Questions | 30 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 5 |
| Slave_heartbeat_period | 0.000 |
| Slave_open_temp_tables | 0 |
| Slave_received_heartbeats | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 68 |
| Table_locks_waited | 0 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 1 |
| Threads_running | 1 |
| Uptime | 593 |
| Uptime_since_flush_status | 593 |
+------------------------------------------+-------------+
312 rows in set (0.00 sec)
mysql> show status like '%sort%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
+-------------------+-------+
4 rows in set (0.00 sec)
mysql> #limit n,m 子句
mysql> #表示从第n条记录开始选择m条记录
mysql> select * from aminals limit 2;
ERROR 1146 (42S02): Table 'test.aminals' doesn't exist
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| employees |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| yeartest |
| z |
+----------------+
18 rows in set (0.00 sec)
mysql> select * from animals limit 2;
+----+------+
| id | name |
+----+------+
| 3 | Cat |
| 2 | Dog |
+----+------+
2 rows in set (0.00 sec)
mysql> #子查询
mysql> #是指在一个select语句中嵌套另一个select语句
mysql> #好处:
mysql> #1.子查询允许结构化的查询 这样就可以把一个查询语句的每个部分隔开
mysql> #2.子查询提供了另一种方法来执行有些需要复杂的join和union来实现的操作
mysql> #3.在许多人看来,子查询的刻度性能比较高
mysql>
mysql> #一个子查询返回一个标量(一个行 一个列 一个表) 子查询可以包括select语句可以包括的一切子句
mysql> #子查询限制: 用户不能既在一个子查询中修改一个表,又在另一个表中进行选择
mysql>
mysql> select 'a'=(select 'a') as t;
+---+
| t |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
mysql> select 'a'=(select null) as t;
+------+
| t |
+------+
| NULL |
+------+
1 row in set (0.00 sec)
mysql> #标量子查询
mysql> desc orders;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| order_id | int(11) | NO | PRI | NULL | auto_increment |
| customer_id | varchar(10) | YES | | NULL | |
+-------------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> select * from orders;
+----------+-------------+
| order_id | customer_id |
+----------+-------------+
| 1 | Jack1 |
| 2 | Jack1 |
| 3 | 9You |
| 4 | 9You |
| 5 | 9You |
| 6 | TX |
| 7 | NULL |
+----------+-------------+
7 rows in set (0.00 sec)
mysql> #现在我们利用子查询来查找员工表中每月worktime最后一个
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| Nums |
| a |
| animals |
| charTest |
| customers |
| employees |
| new_emp |
| orders |
| sales |
| sessions |
| t |
| test01 |
| timetest |
| tt |
| ttt |
| updatetime |
| yeartest |
| z |
+----------------+
18 rows in set (0.00 sec)
mysql> drop table new_emp;
Query OK, 0 rows affected (0.05 sec)
mysql> create table new_emp like employees;
Query OK, 0 rows affected (0.10 sec)
mysql> insert into new_emp select * from employees limit 500;
Query OK, 500 rows affected (0.05 sec)
Records: 500 Duplicates: 0 Warnings: 0
mysql> desc new_emp;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(10) | NO | PRI | NULL | |
| birth_date | date | YES | | NULL | |
| first_name | varchar(15) | NO | | | |
| last_name | varchar(15) | NO | | | |
| sex | char(1) | YES | | NULL | |
| worktime | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> select id, concat(first_name,' ',last_name) as name, worktime
-> from new_emp
-> where worktime in
-> (select max(worktime)
-> from new_emp
-> group by (date_format(worktime,'%Y%m')));
+-------+------------------------+------------+
| id | name | worktime |
+-------+------------------------+------------+
| 10001 | Georgi Facello | 1986-06-26 |
| 10003 | Parto Bamford | 1986-08-28 |
| 10008 | Saniya Kalloufi | 1994-09-15 |
| 10010 | Duangkaew Piveteau | 1989-08-24 |
| 10016 | Kazuhito Cappelletti | 1995-01-27 |
| 10019 | Lillian Haddadi | 1999-04-30 |
| 10020 | Mayuko Warwick | 1991-01-26 |
| 10022 | Shahaf Famili | 1995-08-22 |
| 10024 | Suzette Pettey | 1997-05-19 |
| 10026 | Yongqiao Berztiss | 1995-03-20 |
| 10030 | Elvis Demeyer | 1994-02-17 |
| 10032 | Jeong Reistad | 1990-06-20 |
| 10040 | Weiyi Meriste | 1993-02-14 |
| 10047 | Zvonko Nyanchama | 1989-03-31 |
| 10048 | Florian Syrotiuk | 1985-02-24 |
| 10051 | Hidefumi Caine | 1992-10-15 |
| 10055 | Georgy Dredge | 1992-04-27 |
| 10059 | Alejandro McAlpine | 1991-06-26 |
| 10062 | Anoosh Peyn | 1991-08-30 |
| 10066 | Kwee Schusler | 1986-02-26 |
| 10078 | Danel Mondadori | 1987-05-26 |
| 10081 | Zhongwei Rosen | 1986-10-30 |
| 10083 | Vishv Zockler | 1987-03-31 |
| 10086 | Somnath Foote | 1990-02-16 |
| 10091 | Amabile Gomatam | 1992-11-18 |
| 10092 | Valdiodio Niizuma | 1989-09-22 |
| 10093 | Sailaja Desikan | 1996-11-05 |
| 10100 | Hironobu Haraldson | 1987-09-21 |
| 10102 | Paraskevi Luby | 1994-01-26 |
| 10109 | Mariusz Prampolini | 1993-06-16 |
| 10113 | Jaewon Syrzycki | 1989-12-24 |
| 10116 | Dayanand Czap | 1985-05-28 |
| 10125 | Syozo Hiltgen | 1990-10-26 |
| 10131 | Magdalena Eldridge | 1994-11-17 |
| 10132 | Ayakannu Skrikant | 1994-10-30 |
| 10139 | Ewing Foong | 1998-03-15 |
| 10140 | Yucel Auria | 1991-03-14 |
| 10142 | Tzvetan Hettesheimer | 1993-10-28 |
| 10143 | Sakthirel Bakhtari | 1988-09-30 |
| 10146 | Chenyi Syang | 1988-06-28 |
| 10158 | Khedija Mitsuhashi | 1986-01-29 |
| 10159 | Serif Buescher | 1991-05-29 |
| 10160 | Debatosh Khasidashvili | 1989-01-30 |
| 10171 | Herbert Trachtenberg | 1989-07-22 |
| 10173 | Shrikanth Mahmud | 1992-03-21 |
| 10176 | Brendon Lenart | 1994-12-22 |
| 10186 | Shigehito Kropatsch | 1986-03-28 |
| 10191 | Zdislav Nastansky | 1986-04-10 |
| 10193 | Masaru Cheshire | 1991-07-28 |
| 10197 | Kasidit Krzyzanowski | 1993-11-22 |
| 10198 | Pranav Furedi | 1985-08-31 |
| 10199 | Kazuhisa Ranta | 1997-04-29 |
| 10201 | Idoia Kavraki | 1986-11-22 |
| 10205 | Mabhin Leijenhorst | 1993-08-23 |
| 10208 | Xiping Klerer | 1991-12-23 |
| 10209 | Yolla Ellozy | 1991-11-23 |
| 10212 | Divier Esteva | 1990-07-11 |
| 10214 | Tadahiko Ciolek | 1988-02-29 |
| 10216 | Amstein Ghemri | 1987-10-30 |
| 10218 | Zhenhua Magalhaes | 1997-01-15 |
| 10219 | Genta Kolvik | 1993-03-31 |
| 10220 | Kish Fasbender | 1992-06-25 |
| 10226 | Xinglin Plessier | 1989-10-27 |
| 10227 | Anneli Kaiser | 1994-04-24 |
| 10229 | Ulises Takanami | 1987-11-22 |
| 10230 | Clyde Vernadat | 1996-06-16 |
| 10231 | Shaowen Desikan | 1996-04-13 |
| 10234 | Arunachalam Bakhtari | 1990-11-19 |
| 10235 | Susanta Roccetti | 1995-04-06 |
| 10236 | Susumu Bade | 1996-08-30 |
| 10239 | Nikolaos Llado | 1995-05-08 |
| 10243 | Wonhee Pouyioutas | 1985-11-24 |
| 10244 | Foong Flasterstein | 1985-12-23 |
| 10250 | Serap Etalle | 1992-08-30 |
| 10251 | Alair Rosenbaum | 1992-06-25 |
| 10262 | Mahendra Maraist | 1992-07-27 |
| 10264 | Nalini Kawashimo | 1997-07-16 |
| 10269 | Taizo Oxman | 1988-07-24 |
| 10270 | Bedir Hartvigsen | 1990-04-26 |
| 10274 | Dmitri Pearson | 1991-04-21 |
| 10283 | Kauko Birjandi | 1988-05-25 |
| 10285 | Zhonghui Preusig | 1995-02-27 |
| 10286 | Saddek Gopalakrishnan | 1988-03-21 |
| 10288 | Selwyn Perri | 1994-08-29 |
| 10291 | Dipayan Seghrouchni | 1986-09-29 |
| 10295 | Kristine Velardi | 1990-08-27 |
| 10297 | Narain Oaver | 1986-05-28 |
| 10298 | Dietrich DuCasse | 1999-03-30 |
| 10302 | Faiza Baer | 1986-07-22 |
| 10305 | Hirochika Piancastelli | 1988-10-31 |
| 10306 | Heng Kilgour | 1993-09-06 |
| 10308 | Dzung Holburn | 1992-12-29 |
| 10312 | Rasiah Deyuan | 1986-08-28 |
| 10315 | Maris Angelopoulos | 1987-08-28 |
| 10318 | Mototsugu Beilner | 1985-06-29 |
| 10320 | Uinam Stasinski | 1988-11-03 |
| 10322 | Isamu Dahlbom | 1990-01-29 |
| 10325 | Arunachalam Badr | 1990-09-20 |
| 10333 | Snehasis Dymetman | 1993-01-16 |
| 10334 | Falguni Erie | 1996-12-28 |
| 10339 | Teunis Liedekerke | 1989-11-30 |
| 10340 | Djelloul Laventhal | 1987-06-05 |
| 10341 | Wilmer Greenaway | 1987-04-29 |
| 10342 | Stella Hiroyama | 1987-07-25 |
| 10344 | Uwe Garnier | 1994-06-25 |
| 10346 | Aamod Radwan | 1987-01-27 |
| 10349 | Oksana Brodie | 1991-09-28 |
| 10352 | Erzsebet Ohori | 1996-01-21 |
| 10353 | Phule Hammerschmidt | 1989-08-24 |
| 10354 | Moto Kusakari | 1996-03-26 |
| 10358 | Qunsheng Tagansky | 1991-02-19 |
| 10360 | Irene Munck | 1996-09-04 |
| 10372 | Anneli Frijda | 1985-07-30 |
| 10374 | Willard Rosin | 1993-12-08 |
| 10375 | Dante Kalafatis | 1994-05-29 |
| 10378 | Takahira Lichtner | 1990-12-30 |
| 10380 | Alejandro Kamble | 1985-03-19 |
| 10389 | Make Peir | 1995-10-31 |
| 10390 | Wanqing Bratten | 1989-05-17 |
| 10391 | Hongzue Akaboshi | 1989-12-24 |
| 10393 | Yagil DasSarma | 1989-06-23 |
| 10394 | Shawna Meriste | 1991-03-14 |
| 10397 | Irena Reutenauer | 1993-05-21 |
| 10404 | Prodip Rosti | 1988-08-28 |
| 10408 | Martijn Kaiser | 1998-10-07 |
| 10413 | Danel Impagliazzo | 1990-03-26 |
| 10414 | Yinlin Alpin | 1990-05-30 |
| 10418 | Candida Porotnikoff | 1989-04-20 |
| 10423 | Dante Cronin | 1998-09-06 |
| 10425 | Sashi Osgood | 1991-10-29 |
| 10432 | Hisao Tiemann | 1985-04-30 |
| 10433 | Reuven Dengi | 1989-02-14 |
| 10434 | Dzung Peltason | 1995-06-27 |
| 10435 | Marsha Tagansky | 1986-12-19 |
| 10436 | Yahiko Lammel | 1988-01-30 |
| 10440 | Akeel Narahara | 1994-03-31 |
| 10444 | Kazuhira Rosis | 1993-03-31 |
| 10446 | Ebru Chepyzhov | 1994-11-17 |
| 10447 | Ronghao Yavatkar | 1988-12-29 |
| 10455 | Sverrir Streng | 1989-02-14 |
| 10456 | Stepehn Hardjono | 1995-12-25 |
| 10457 | Oddvar Schlenzig | 1991-11-23 |
| 10459 | Ennio Trogemann | 1997-06-28 |
| 10460 | Shushma VanScheik | 1994-07-01 |
| 10463 | Ung Zaiane | 1987-12-25 |
| 10466 | Jiakeng Himler | 1985-09-29 |
| 10472 | Salvador Lodder | 1996-07-29 |
| 10473 | Przemyslawa Oskamp | 1987-10-30 |
| 10479 | Duro Coney | 1987-02-28 |
| 10484 | Nirmal Varley | 1995-10-31 |
| 10485 | Teruyuki Sundgren | 1985-10-27 |
| 10492 | Lobel Kumaresan | 1988-04-24 |
| 10493 | Maris Haraldson | 1992-05-16 |
| 10495 | Anyuan Zhiwei | 1985-09-29 |
| 10497 | Pramod Rabehasaina | 1992-01-22 |
+-------+------------------------+------------+
155 rows in set (0.48 sec)
mysql> #因为年的关系 所以会出现多个啊
mysql>
mysql> #相关子查询
mysql> select id, concat(first_name,' ',last_name) as name, worktime
-> from new_emp as a
-> where worktime =
-> (select max(worktime)
-> from new_emp as b
-> where a.id = b.id);
+-------+---------------------------+------------+
| id | name | worktime |
+-------+---------------------------+------------+
| 10001 | Georgi Facello | 1986-06-26 |
| 10002 | Bezalel Simmel | 1985-11-21 |
| 10003 | Parto Bamford | 1986-08-28 |
| 10004 | Chirstian Koblick | 1986-12-01 |
| 10005 | Kyoichi Maliniak | 1989-09-12 |
| 10006 | Anneke Preusig | 1989-06-02 |
| 10007 | Tzvetan Zielinski | 1989-02-10 |
| 10008 | Saniya Kalloufi | 1994-09-15 |
| 10009 | Sumant Peac | 1985-02-18 |
| 10010 | Duangkaew Piveteau | 1989-08-24 |
| 10011 | Mary Sluis | 1990-01-22 |
| 10012 | Patricio Bridgland | 1992-12-18 |
| 10013 | Eberhardt Terkki | 1985-10-20 |
| 10014 | Berni Genin | 1987-03-11 |
| 10015 | Guoxiang Nooteboom | 1987-07-02 |
| 10016 | Kazuhito Cappelletti | 1995-01-27 |
| 10017 | Cristinel Bouloucos | 1993-08-03 |
| 10018 | Kazuhide Peha | 1987-04-03 |
| 10019 | Lillian Haddadi | 1999-04-30 |
| 10020 | Mayuko Warwick | 1991-01-26 |
| 10021 | Ramzi Erde | 1988-02-10 |
| 10022 | Shahaf Famili | 1995-08-22 |
| 10023 | Bojan Montemayor | 1989-12-17 |
| 10024 | Suzette Pettey | 1997-05-19 |
| 10025 | Prasadram Heyers | 1987-08-17 |
| 10026 | Yongqiao Berztiss | 1995-03-20 |
| 10027 | Divier Reistad | 1989-07-07 |
| 10028 | Domenick Tempesti | 1991-10-22 |
| 10029 | Otmar Herbst | 1985-11-20 |
| 10030 | Elvis Demeyer | 1994-02-17 |
| 10031 | Karsten Joslin | 1991-09-01 |
| 10032 | Jeong Reistad | 1990-06-20 |
| 10033 | Arif Merlo | 1987-03-18 |
| 10034 | Bader Swan | 1988-09-21 |
| 10035 | Alain Chappelet | 1988-09-05 |
| 10036 | Adamantios Portugali | 1992-01-03 |
| 10037 | Pradeep Makrucki | 1990-12-05 |
| 10038 | Huan Lortz | 1989-09-20 |
| 10039 | Alejandro Brender | 1988-01-19 |
| 10040 | Weiyi Meriste | 1993-02-14 |
| 10041 | Uri Lenart | 1989-11-12 |
| 10042 | Magy Stamatiou | 1993-03-21 |
| 10043 | Yishay Tzvieli | 1990-10-20 |
| 10044 | Mingsen Casley | 1994-05-21 |
| 10045 | Moss Shanbhogue | 1989-09-02 |
| 10046 | Lucien Rosenbaum | 1992-06-20 |
| 10047 | Zvonko Nyanchama | 1989-03-31 |
| 10048 | Florian Syrotiuk | 1985-02-24 |
| 10049 | Basil Tramer | 1992-05-04 |
| 10050 | Yinghua Dredge | 1990-12-25 |
| 10051 | Hidefumi Caine | 1992-10-15 |
| 10052 | Heping Nitsch | 1988-05-21 |
| 10053 | Sanjiv Zschoche | 1986-02-04 |
| 10054 | Mayumi Schueller | 1995-03-13 |
| 10055 | Georgy Dredge | 1992-04-27 |
| 10056 | Brendon Bernini | 1990-02-01 |
| 10057 | Ebbe Callaway | 1992-01-15 |
| 10058 | Berhard McFarlin | 1987-04-13 |
| 10059 | Alejandro McAlpine | 1991-06-26 |
| 10060 | Breannda Billingsley | 1987-11-02 |
| 10061 | Tse Herber | 1985-09-17 |
| 10062 | Anoosh Peyn | 1991-08-30 |
| 10063 | Gino Leonhardt | 1989-04-08 |
| 10064 | Udi Jansch | 1985-11-20 |
| 10065 | Satosi Awdeh | 1988-05-18 |
| 10066 | Kwee Schusler | 1986-02-26 |
| 10067 | Claudi Stavenow | 1987-03-04 |
| 10068 | Charlene Brattka | 1987-08-07 |
| 10069 | Margareta Bierman | 1989-11-05 |
| 10070 | Reuven Garigliano | 1985-10-14 |
| 10071 | Hisao Lipner | 1987-10-01 |
| 10072 | Hironoby Sidou | 1988-07-21 |
| 10073 | Shir McClurg | 1991-12-01 |
| 10074 | Mokhtar Bernatsky | 1990-08-13 |
| 10075 | Gao Dolinsky | 1987-03-19 |
| 10076 | Erez Ritzmann | 1985-07-09 |
| 10077 | Mona Azuma | 1990-03-02 |
| 10078 | Danel Mondadori | 1987-05-26 |
| 10079 | Kshitij Gils | 1986-03-27 |
| 10080 | Premal Baek | 1985-11-19 |
| 10081 | Zhongwei Rosen | 1986-10-30 |
| 10082 | Parviz Lortz | 1990-01-03 |
| 10083 | Vishv Zockler | 1987-03-31 |
| 10084 | Tuval Kalloufi | 1995-12-15 |
| 10085 | Kenroku Malabarba | 1994-04-09 |
| 10086 | Somnath Foote | 1990-02-16 |
| 10087 | Xinglin Eugenio | 1986-09-08 |
| 10088 | Jungsoon Syrzycki | 1988-09-02 |
| 10089 | Sudharsan Flasterstein | 1986-08-12 |
| 10090 | Kendra Hofting | 1986-03-14 |
| 10091 | Amabile Gomatam | 1992-11-18 |
| 10092 | Valdiodio Niizuma | 1989-09-22 |
| 10093 | Sailaja Desikan | 1996-11-05 |
| 10094 | Arumugam Ossenbruggen | 1987-04-18 |
| 10095 | Hilari Morton | 1986-07-15 |
| 10096 | Jayson Mandell | 1990-01-14 |
| 10097 | Remzi Waschkowski | 1990-09-15 |
| 10098 | Sreekrishna Servieres | 1985-05-13 |
| 10099 | Valter Sullins | 1988-10-18 |
| 10100 | Hironobu Haraldson | 1987-09-21 |
| 10101 | Perla Heyers | 1992-12-28 |
| 10102 | Paraskevi Luby | 1994-01-26 |
| 10103 | Akemi Birch | 1986-12-02 |
| 10104 | Xinyu Warwick | 1987-04-16 |
| 10105 | Hironoby Piveteau | 1999-03-23 |
| 10106 | Eben Aingworth | 1990-12-19 |
| 10107 | Dung Baca | 1994-03-22 |
| 10108 | Lunjin Giveon | 1986-10-02 |
| 10109 | Mariusz Prampolini | 1993-06-16 |
| 10110 | Xuejia Ullian | 1986-08-22 |
| 10111 | Hugo Rosis | 1988-06-19 |
| 10112 | Yuichiro Swick | 1985-10-08 |
| 10113 | Jaewon Syrzycki | 1989-12-24 |
| 10114 | Munir Demeyer | 1992-07-17 |
| 10115 | Chikara Rissland | 1986-01-23 |
| 10116 | Dayanand Czap | 1985-05-28 |
| 10117 | Kiyotoshi Blokdijk | 1990-05-28 |
| 10118 | Zhonghui Zyda | 1990-09-13 |
| 10119 | Domenick Peltason | 1986-03-14 |
| 10120 | Armond Fairtlough | 1996-07-06 |
| 10121 | Guoxiang Ramsay | 1989-05-03 |
| 10122 | Ohad Esposito | 1992-12-23 |
| 10123 | Hinrich Randi | 1993-01-15 |
| 10124 | Geraldo Marwedel | 1991-09-05 |
| 10125 | Syozo Hiltgen | 1990-10-26 |
| 10126 | Kayoko Valtorta | 1985-09-08 |
| 10127 | Subir Baja | 1989-01-14 |
| 10128 | Babette Lamba | 1988-06-06 |
| 10129 | Armond Peir | 1985-12-10 |
| 10130 | Nishit Casperson | 1988-06-21 |
| 10131 | Magdalena Eldridge | 1994-11-17 |
| 10132 | Ayakannu Skrikant | 1994-10-30 |
| 10133 | Giri Isaak | 1985-12-15 |
| 10134 | Diederik Siprelle | 1987-12-12 |
| 10135 | Nathan Monkewich | 1988-02-19 |
| 10136 | Zissis Pintelas | 1986-02-11 |
| 10137 | Maren Hutton | 1985-02-18 |
| 10138 | Perry Shimshoni | 1986-09-18 |
| 10139 | Ewing Foong | 1998-03-15 |
| 10140 | Yucel Auria | 1991-03-14 |
| 10141 | Shahaf Ishibashi | 1993-05-06 |
| 10142 | Tzvetan Hettesheimer | 1993-10-28 |
| 10143 | Sakthirel Bakhtari | 1988-09-30 |
| 10144 | Marla Brendel | 1985-10-14 |
| 10145 | Akemi Esposito | 1987-08-01 |
| 10146 | Chenyi Syang | 1988-06-28 |
| 10147 | Kazuhito Encarnacion | 1986-08-21 |
| 10148 | Douadi Azumi | 1995-10-10 |
| 10149 | Xiadong Perry | 1986-11-05 |
| 10150 | Zhenbing Perng | 1986-11-16 |
| 10151 | Itzchak Lichtner | 1990-04-10 |
| 10152 | Jaques Munro | 1986-01-27 |
| 10153 | Heekeun Majewski | 1987-04-08 |
| 10154 | Abdulah Thibadeau | 1990-12-12 |
| 10155 | Adas Nastansky | 1990-01-05 |
| 10156 | Sumali Fargier | 1985-03-10 |
| 10157 | Nigel Aloisi | 1985-11-02 |
| 10158 | Khedija Mitsuhashi | 1986-01-29 |
| 10159 | Serif Buescher | 1991-05-29 |
| 10160 | Debatosh Khasidashvili | 1989-01-30 |
| 10161 | Hairong Mellouli | 1988-04-03 |
| 10162 | Florina Eugenio | 1991-05-01 |
| 10163 | Karsten Szmurlo | 1989-07-19 |
| 10164 | Jagoda Braunmuhl | 1985-11-12 |
| 10165 | Miyeon Macedo | 1988-05-17 |
| 10166 | Samphel Siegrist | 1993-01-01 |
| 10167 | Duangkaew Rassart | 1992-04-04 |
| 10168 | Dharmaraja Stassinopoulos | 1986-12-06 |
| 10169 | Sampalli Snedden | 1992-07-24 |
| 10170 | Kasturi Jenevein | 1986-01-02 |
| 10171 | Herbert Trachtenberg | 1989-07-22 |
| 10172 | Shigeu Matzen | 1995-10-13 |
| 10173 | Shrikanth Mahmud | 1992-03-21 |
| 10174 | Badri Furudate | 1987-06-01 |
| 10175 | Aleksandar Ananiadou | 1988-01-11 |
| 10176 | Brendon Lenart | 1994-12-22 |
| 10177 | Pragnesh Iisaka | 1993-02-06 |
| 10178 | Valery Litvinov | 1986-10-07 |
| 10179 | Deniz Duclos | 1990-10-04 |
| 10180 | Shaw Wendorf | 1986-02-25 |
| 10181 | Sibyl Nooteboom | 1988-06-22 |
| 10182 | Moriyoshi Merey | 1990-09-02 |
| 10183 | Mechthild Bonifati | 1996-08-11 |
| 10184 | Mihalis Lowrie | 1987-10-29 |
| 10185 | Duro Sidhu | 1986-03-01 |
| 10186 | Shigehito Kropatsch | 1986-03-28 |
| 10187 | Tommaso Narwekar | 1991-06-01 |
| 10188 | Christ Muchinsky | 1987-08-27 |
| 10189 | Khalid Erva | 1989-10-05 |
| 10190 | Arve Fairtlough | 1986-06-23 |
| 10191 | Zdislav Nastansky | 1986-04-10 |
| 10192 | Mohua Falck | 1988-06-13 |
| 10193 | Masaru Cheshire | 1991-07-28 |
| 10194 | Josyula Hofmeyr | 1989-05-15 |
| 10195 | Annemarie Redmiles | 1985-02-15 |
| 10196 | Marc Hellwagner | 1994-11-16 |
| 10197 | Kasidit Krzyzanowski | 1993-11-22 |
| 10198 | Pranav Furedi | 1985-08-31 |
| 10199 | Kazuhisa Ranta | 1997-04-29 |
| 10200 | Vidya Awdeh | 1985-10-16 |
| 10201 | Idoia Kavraki | 1986-11-22 |
| 10202 | Greger Lichtner | 1991-10-06 |
| 10203 | Steen Escriba | 1989-04-06 |
| 10204 | Nevio Ritcey | 1986-12-04 |
| 10205 | Mabhin Leijenhorst | 1993-08-23 |
| 10206 | Alassane Iwayama | 1988-04-19 |
| 10207 | Girolamo Anandan | 1992-10-11 |
| 10208 | Xiping Klerer | 1991-12-23 |
| 10209 | Yolla Ellozy | 1991-11-23 |
| 10210 | Yuping Alpin | 1994-05-10 |
| 10211 | Vishu Strehl | 1989-11-18 |
| 10212 | Divier Esteva | 1990-07-11 |
| 10213 | Jackson Kakkad | 1992-11-06 |
| 10214 | Tadahiko Ciolek | 1988-02-29 |
| 10215 | Xiaobin Duclos | 1987-10-19 |
| 10216 | Amstein Ghemri | 1987-10-30 |
| 10217 | Yongmin Roison | 1986-05-12 |
| 10218 | Zhenhua Magalhaes | 1997-01-15 |
| 10219 | Genta Kolvik | 1993-03-31 |
| 10220 | Kish Fasbender | 1992-06-25 |
| 10221 | Yucai Granlund | 1988-06-08 |
| 10222 | Tze Nourani | 1986-06-08 |
| 10223 | Carrsten Schmiedel | 1985-11-18 |
| 10224 | Leon Trogemann | 1988-01-09 |
| 10225 | Kellie Chinen | 1986-06-19 |
| 10226 | Xinglin Plessier | 1989-10-27 |
| 10227 | Anneli Kaiser | 1994-04-24 |
| 10228 | Karoline Cesareni | 1991-08-26 |
| 10229 | Ulises Takanami | 1987-11-22 |
| 10230 | Clyde Vernadat | 1996-06-16 |
| 10231 | Shaowen Desikan | 1996-04-13 |
| 10232 | Marko Auria | 1992-06-04 |
| 10233 | Lein Vendrig | 1985-07-05 |
| 10234 | Arunachalam Bakhtari | 1990-11-19 |
| 10235 | Susanta Roccetti | 1995-04-06 |
| 10236 | Susumu Bade | 1996-08-30 |
| 10237 | Yannis Mandell | 1989-08-11 |
| 10238 | Mototsugu Gire | 1986-11-19 |
| 10239 | Nikolaos Llado | 1995-05-08 |
| 10240 | Remko Maccarone | 1998-10-06 |
| 10241 | Ortrud Murillo | 1988-06-12 |
| 10242 | Lunjin Ozeri | 1988-01-18 |
| 10243 | Wonhee Pouyioutas | 1985-11-24 |
| 10244 | Foong Flasterstein | 1985-12-23 |
| 10245 | Ramalingam Gente | 1985-04-26 |
| 10246 | Basem Teitelbaum | 1987-07-12 |
| 10247 | Heon Riefers | 1992-08-14 |
| 10248 | Frederique Tempesti | 1991-08-13 |
| 10249 | Marie Boreale | 1991-12-08 |
| 10250 | Serap Etalle | 1992-08-30 |
| 10251 | Alair Rosenbaum | 1992-06-25 |
| 10252 | Shirish Wegerle | 1990-11-08 |
| 10253 | Zsolt Salinas | 1985-02-21 |
| 10254 | Shen Brattka | 1990-06-14 |
| 10255 | Roddy Garnick | 1993-05-12 |
| 10256 | Irene Radhakrishnan | 1985-10-12 |
| 10257 | Aiman Riexinger | 1986-08-05 |
| 10258 | Basil Ishibashi | 1985-05-17 |
| 10259 | Susanna Vesel | 1986-06-25 |
| 10260 | Alper Suomi | 1991-04-13 |
| 10261 | Mang Erie | 1993-10-20 |
| 10262 | Mahendra Maraist | 1992-07-27 |
| 10263 | Takahiro Waterhouse | 1994-02-05 |
| 10264 | Nalini Kawashimo | 1997-07-16 |
| 10265 | Ramalingam Muniz | 1989-07-13 |
| 10266 | Sukumar Rassart | 1990-05-25 |
| 10267 | Shaunak Cullers | 1996-12-11 |
| 10268 | Nishit Siochi | 1986-12-17 |
| 10269 | Taizo Oxman | 1988-07-24 |
| 10270 | Bedir Hartvigsen | 1990-04-26 |
| 10271 | Sham Eastman | 1986-05-23 |
| 10272 | Yishai Cannane | 1988-05-23 |
| 10273 | Baocai Lieblein | 1985-11-06 |
| 10274 | Dmitri Pearson | 1991-04-21 |
| 10275 | Marek Luck | 1987-09-08 |
| 10276 | Xuejun Hempstead | 1985-07-21 |
| 10277 | Isaac Schwartzbauer | 1985-06-16 |
| 10278 | Lubomir Nitsch | 1991-05-17 |
| 10279 | Barton Jumpertz | 1994-12-20 |
| 10280 | Stabislas Delgrange | 1988-03-18 |
| 10281 | Moty Kusakari | 1994-12-03 |
| 10282 | Hercules Benzmuller | 1986-06-04 |
| 10283 | Kauko Birjandi | 1988-05-25 |
| 10284 | Masali Murrill | 1997-07-02 |
| 10285 | Zhonghui Preusig | 1995-02-27 |
| 10286 | Saddek Gopalakrishnan | 1988-03-21 |
| 10287 | Marie Pietracaprina | 1992-12-28 |
| 10288 | Selwyn Perri | 1994-08-29 |
| 10289 | Shay Poulakidas | 1990-06-06 |
| 10290 | Yongmao Pleszkun | 1991-09-18 |
| 10291 | Dipayan Seghrouchni | 1986-09-29 |
| 10292 | Yucel Ghelli | 1989-06-05 |
| 10293 | Mihalis Avouris | 1992-12-12 |
| 10294 | Rutger Miara | 1996-04-08 |
| 10295 | Kristine Velardi | 1990-08-27 |
| 10296 | Petter Lorho | 1989-09-16 |
| 10297 | Narain Oaver | 1986-05-28 |
| 10298 | Dietrich DuCasse | 1999-03-30 |
| 10299 | Ipke Stentiford | 1990-01-10 |
| 10300 | Tadahiko Ulupinar | 1991-05-17 |
| 10301 | Lucien Staudhammer | 1988-05-23 |
| 10302 | Faiza Baer | 1986-07-22 |
| 10303 | Marlo Zschoche | 1990-02-05 |
| 10304 | Bernt Erie | 1992-11-16 |
| 10305 | Hirochika Piancastelli | 1988-10-31 |
| 10306 | Heng Kilgour | 1993-09-06 |
| 10307 | Nikolaos Leaver | 1991-04-10 |
| 10308 | Dzung Holburn | 1992-12-29 |
| 10309 | Prodip Schusler | 1985-06-20 |
| 10310 | Aksel Alencar | 1990-10-24 |
| 10311 | Hsiangchu Molenkamp | 1991-04-01 |
| 10312 | Rasiah Deyuan | 1986-08-28 |
| 10313 | Subbu Riexinger | 1994-10-10 |
| 10314 | Christfried Apsitis | 1986-01-16 |
| 10315 | Maris Angelopoulos | 1987-08-28 |
| 10316 | Christoper Schwaller | 1987-09-04 |
| 10317 | Arie Birge | 1986-12-10 |
| 10318 | Mototsugu Beilner | 1985-06-29 |
| 10319 | Mechthild Miyakawa | 1985-08-15 |
| 10320 | Uinam Stasinski | 1988-11-03 |
| 10321 | Guenter Ravishankar | 1991-09-24 |
| 10322 | Isamu Dahlbom | 1990-01-29 |
| 10323 | Kankanahalli Hinsberger | 1991-06-06 |
| 10324 | Bernardo Rouquie | 1988-03-19 |
| 10325 | Arunachalam Badr | 1990-09-20 |
| 10326 | Masali Czap | 1985-05-13 |
| 10327 | Roded Facello | 1987-09-18 |
| 10328 | Serenella Kawashima | 1994-01-16 |
| 10329 | Remko Shigei | 1986-01-20 |
| 10330 | Kasturi Bellmore | 1985-06-12 |
| 10331 | Arto Binkley | 1985-04-06 |
| 10332 | Masanao Bain | 1988-06-08 |
| 10333 | Snehasis Dymetman | 1993-01-16 |
| 10334 | Falguni Erie | 1996-12-28 |
| 10335 | Toshimori Bahi | 1992-04-06 |
| 10336 | Goa Rothe | 1992-01-07 |
| 10337 | Jeong Sadowsky | 1995-08-06 |
| 10338 | Heon Ranai | 1988-09-01 |
| 10339 | Teunis Liedekerke | 1989-11-30 |
| 10340 | Djelloul Laventhal | 1987-06-05 |
| 10341 | Wilmer Greenaway | 1987-04-29 |
| 10342 | Stella Hiroyama | 1987-07-25 |
| 10343 | Dinah Syrzycki | 1993-10-14 |
| 10344 | Uwe Garnier | 1994-06-25 |
| 10345 | Arra Ratnakar | 1993-11-08 |
| 10346 | Aamod Radwan | 1987-01-27 |
| 10347 | Pradeep Kaminger | 1985-12-12 |
| 10348 | Mahendra Picco | 1995-10-22 |
| 10349 | Oksana Brodie | 1991-09-28 |
| 10350 | Kristen Kavvadias | 1990-08-19 |
| 10351 | Tadahiko Strehl | 1985-03-07 |
| 10352 | Erzsebet Ohori | 1996-01-21 |
| 10353 | Phule Hammerschmidt | 1989-08-24 |
| 10354 | Moto Kusakari | 1996-03-26 |
| 10355 | Satyanarayana Cochrane | 1987-11-15 |
| 10356 | Vasilis Standera | 1988-08-06 |
| 10357 | Hausi Sidhu | 1994-04-04 |
| 10358 | Qunsheng Tagansky | 1991-02-19 |
| 10359 | Heekeun Sambasivam | 1991-05-09 |
| 10360 | Irene Munck | 1996-09-04 |
| 10361 | Seshu Sidou | 1986-10-23 |
| 10362 | Shalesh dAstous | 1988-08-24 |
| 10363 | Toshiki Muniz | 1985-09-11 |
| 10364 | Nakhoon Dengi | 1985-11-14 |
| 10365 | Rosine Granlund | 1987-06-02 |
| 10366 | Morrie Piazza | 1994-04-11 |
| 10367 | Hyuckchul Gini | 1991-06-24 |
| 10368 | Hatim Koshiba | 1991-04-05 |
| 10369 | Qunsheng Toyoshima | 1986-05-17 |
| 10370 | Clyde Fandrianto | 1992-04-04 |
| 10371 | Ioana Kirkerud | 1989-11-28 |
| 10372 | Anneli Frijda | 1985-07-30 |
| 10373 | Hongzue Heijenga | 1997-04-26 |
| 10374 | Willard Rosin | 1993-12-08 |
| 10375 | Dante Kalafatis | 1994-05-29 |
| 10376 | Fai Bale | 1989-01-14 |
| 10377 | Marl Grospietsch | 1990-05-07 |
| 10378 | Takahira Lichtner | 1990-12-30 |
| 10379 | Mikhail Rosis | 1996-07-15 |
| 10380 | Alejandro Kamble | 1985-03-19 |
| 10381 | Jiong Parfitt | 1991-12-04 |
| 10382 | Shirish Dredge | 1990-07-04 |
| 10383 | Leucio Aumann | 1991-06-19 |
| 10384 | Feiyu Luft | 1986-01-16 |
| 10385 | Khatoun Imataki | 1992-12-20 |
| 10386 | Eishiro Miyakawa | 1985-08-02 |
| 10387 | Parto Wrigley | 1987-02-19 |
| 10388 | Hironoby Kaiser | 1996-03-24 |
| 10389 | Make Peir | 1995-10-31 |
| 10390 | Wanqing Bratten | 1989-05-17 |
| 10391 | Hongzue Akaboshi | 1989-12-24 |
| 10392 | Jiann Hainaut | 1992-03-01 |
| 10393 | Yagil DasSarma | 1989-06-23 |
| 10394 | Shawna Meriste | 1991-03-14 |
| 10395 | Takahiro Deverell | 1987-02-04 |
| 10396 | Sibyl Rahier | 1986-01-11 |
| 10397 | Irena Reutenauer | 1993-05-21 |
| 10398 | Shooichi Escriba | 1990-10-12 |
| 10399 | Guenter Marchegay | 1985-05-07 |
| 10400 | Ortrud Nitto | 1993-10-17 |
| 10401 | Eckart Barriga | 1991-04-05 |
| 10402 | Volkmar Ebeling | 1987-01-02 |
| 10403 | Atreyi Mungall | 1991-09-13 |
| 10404 | Prodip Rosti | 1988-08-28 |
| 10405 | Hilary Budinsky | 1985-11-04 |
| 10406 | Sigeru Wynblatt | 1987-03-11 |
| 10407 | Ulf Siepmann | 1990-03-08 |
| 10408 | Martijn Kaiser | 1998-10-07 |
| 10409 | Mario Straney | 1997-07-09 |
| 10410 | Takahito Gecsei | 1993-10-16 |
| 10411 | Lidong Klerer | 1989-09-02 |
| 10412 | Masoud Fabrizio | 1986-05-06 |
| 10413 | Danel Impagliazzo | 1990-03-26 |
| 10414 | Yinlin Alpin | 1990-05-30 |
| 10415 | Mark Coorg | 1993-10-25 |
| 10416 | Uli Keustermans | 1989-03-24 |
| 10417 | Bingning Bakhtari | 1992-03-12 |
| 10418 | Candida Porotnikoff | 1989-04-20 |
| 10419 | Maria Bauknecht | 1992-04-25 |
| 10420 | Kaijung Riesenhuber | 1988-01-17 |
| 10421 | Divine Marzano | 1989-09-12 |
| 10422 | Greger Rubsam | 1990-12-07 |
| 10423 | Dante Cronin | 1998-09-06 |
| 10424 | Babette Straney | 1989-08-07 |
| 10425 | Sashi Osgood | 1991-10-29 |
| 10426 | Arunas Luce | 1985-07-06 |
| 10427 | Khosrow Sudbeck | 1991-11-01 |
| 10428 | Cathie Brlek | 1992-06-04 |
| 10429 | Martien Improta | 1986-03-09 |
| 10430 | Ferdinand Chenney | 1990-11-16 |
| 10431 | Patricio Bugrara | 1987-10-08 |
| 10432 | Hisao Tiemann | 1985-04-30 |
| 10433 | Reuven Dengi | 1989-02-14 |
| 10434 | Dzung Peltason | 1995-06-27 |
| 10435 | Marsha Tagansky | 1986-12-19 |
| 10436 | Yahiko Lammel | 1988-01-30 |
| 10437 | Narain Reeker | 1996-04-12 |
| 10438 | Evgueni Srimani | 1990-01-19 |
| 10439 | Jolita Jarecki | 1990-01-11 |
| 10440 | Akeel Narahara | 1994-03-31 |
| 10441 | Adel Perfilyeva | 1988-07-12 |
| 10442 | Volkmar Unno | 1988-03-13 |
| 10443 | Shichao Litvinov | 1989-08-01 |
| 10444 | Kazuhira Rosis | 1993-03-31 |
| 10445 | Junichi Kavanagh | 1987-11-04 |
| 10446 | Ebru Chepyzhov | 1994-11-17 |
| 10447 | Ronghao Yavatkar | 1988-12-29 |
| 10448 | Phule Oxenboll | 1992-03-12 |
| 10449 | Aleksandar Sudkamp | 1987-03-28 |
| 10450 | Khun Harbusch | 1990-01-17 |
| 10451 | Bodh Ranta | 1988-03-12 |
| 10452 | Werner Hasham | 1988-09-05 |
| 10453 | Tsvetan Matzel | 1985-04-02 |
| 10454 | Wonhee Badr | 1987-04-10 |
| 10455 | Sverrir Streng | 1989-02-14 |
| 10456 | Stepehn Hardjono | 1995-12-25 |
| 10457 | Oddvar Schlenzig | 1991-11-23 |
| 10458 | Gina Engelmann | 1988-07-23 |
| 10459 | Ennio Trogemann | 1997-06-28 |
| 10460 | Shushma VanScheik | 1994-07-01 |
| 10461 | Gal Karcich | 1987-08-03 |
| 10462 | Sumali Schlenzig | 1996-03-25 |
| 10463 | Ung Zaiane | 1987-12-25 |
| 10464 | Mang Maginnis | 1989-10-09 |
| 10465 | Claudi Shackel | 1987-09-01 |
| 10466 | Jiakeng Himler | 1985-09-29 |
| 10467 | Dipayan Suomi | 1988-07-14 |
| 10468 | Yoshimitsu Shobatake | 1991-05-28 |
| 10469 | Munehiko Ananiadou | 1985-06-05 |
| 10470 | Peternela Iwayama | 1988-06-01 |
| 10471 | Jouko Yamaashi | 1990-11-18 |
| 10472 | Salvador Lodder | 1996-07-29 |
| 10473 | Przemyslawa Oskamp | 1987-10-30 |
| 10474 | Kenton Garnham | 1985-09-28 |
| 10475 | Mario Rodite | 1987-01-19 |
| 10476 | Kokou Iisaka | 1987-09-20 |
| 10477 | Guoxiang Trogemann | 1989-03-04 |
| 10478 | Maik Ushiama | 1992-06-09 |
| 10479 | Duro Coney | 1987-02-28 |
| 10480 | Make Baba | 1988-05-18 |
| 10481 | Yongmao Pintelas | 1988-10-06 |
| 10482 | Goa Pleszkun | 1991-07-20 |
| 10483 | Zhiwei Anick | 1992-11-08 |
| 10484 | Nirmal Varley | 1995-10-31 |
| 10485 | Teruyuki Sundgren | 1985-10-27 |
| 10486 | Amstein Kossowski | 1987-10-08 |
| 10487 | Perla Middleton | 1992-08-14 |
| 10488 | Mihalis Heering | 1994-06-09 |
| 10489 | Elvia Homond | 1989-09-10 |
| 10490 | Huiqun Vuskovic | 1992-10-07 |
| 10491 | Garnik Narahari | 1990-01-17 |
| 10492 | Lobel Kumaresan | 1988-04-24 |
| 10493 | Maris Haraldson | 1992-05-16 |
| 10494 | Yakkov Servieres | 1986-01-18 |
| 10495 | Anyuan Zhiwei | 1985-09-29 |
| 10496 | Gretta Baig | 1987-02-26 |
| 10497 | Pramod Rabehasaina | 1992-01-22 |
| 10498 | Valter Cappelletti | 1988-02-01 |
| 10499 | Maik Luft | 1989-11-23 |
| 10500 | Vojin Narwekar | 1996-12-16 |
+-------+---------------------------+------------+
500 rows in set (0.00 sec)
mysql> #由此观之 上次的查询还有问题(统一个表中笛卡尔积好像不正确)
mysql>
mysql> exit