Left Join 左连接查询，以左边为主表。 1 select a.*,b.name from a left join b on a.id = b.a_id; Right Join 右连接查询，以右边为主表。 1 select b.*,a.name from a right join b on a.id = b.a_id; Inner Join 内连接查询，以左右表交集。 1 select a.*,b.* from a inner join b on a.id = b.a_id; In 范围查询 1 select a.* from a where a.id in ('1','3') Exist 是否存在……

阅读全文

[mysqld] socket = /tmp/mysql.sock datadir = /usr/local/mysql/data tmpdir = /tmp port = 3030 back_log = 3000 character_set_server = utf8 max_connect_errors = 100 max_connections = 650 max_user_connections = 650 max_heap_table_size = 64M max_allowed_packet = 1024M max_binlog_size = 500M thread_stack = 256K interactive_timeout = 7200 wait_timeout = 86400 sort_buffer_size = 704KB read_buffer_size = 704KB read_rnd_buffer_size = 352KB join_buffer_size = 352KB net_buffer_length = 16K thread_cache_size = 100 ft_min_word_len = 4 transaction_isolation = READ-COMMITTED tmp_table_size = 2097152 table_open_cache = 2000 skip_name_resolve core-file lower_case_table_names = 1 log_bin_trust_function_creators = 1 log-bin = /usr/local/mysql/data/mysql-bin.log log-bin-index = /usr/local/mysql/data/master-log-bin.index log-error = /usr/local/mysql/data/master-error.log relay-log = /usr/local/mysql/data/slave-relay.log relay-log-info-file = /usr/local/mysql/data/slave-relay-log.info relay-log-index……

阅读全文

专业阿里编译 请参考：alisql编译 写在前面 适用环境：mac os x(unix), linux 等 2016年阿里的云栖大会上，开源了alisql，称双11就是alisql的成功案例。而且还说vs mysql 5.7 ,性能有70%的提升。 不管真的假……

阅读全文