sql 基礎--mysql 5

標籤：

mysql5.6 安裝 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html

md中輸入:net start mysql,服務啟動成功

mysql -u root -p（第一次登入沒有密碼，直接按斷行符號過）,登入成功！

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema |+--------------------+3 rows in set (0.00 sec)mysql> use mysqlDatabase changedmysql> show tables;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || event || func || general_log || help_category || help_keyword || help_relation || help_topic || innodb_index_stats || innodb_table_stats || ndb_binlog_index || plugin || proc || procs_priv || proxies_priv || servers || slave_master_info || slave_relay_log_info || slave_worker_info || slow_log || tables_priv || time_zone || time_zone_leap_second || time_zone_name || time_zone_transition || time_zone_transition_type || user |+---------------------------+28 rows in set (0.00 sec)

　　

sql 基礎--mysql 5