發表文章

目前顯示的是有「managing data base in mySQL」標籤的文章

Few basic operation mysql after installation...

圖片
After installing mysql server and python client connector, I need to know how to set up a data base and read write it, I don't need something super fancy, just simply usable for adding rolls and readable for others. http://www.mysqltutorial.org/   is a site seems nice to me to read...there is a basic tutorial Manage Database in MySQL Under windows mysql server, the is a MySQL command line client, open it, it would ask for the password, which is what we have entered during installation. Once entered, try SHOW DATABASES ; it would list out what are the databases available. capital or not is not an issue, but always end with ; we can use 1 CREATE DATABASE [ IF NOT EXISTS ] database_name ; to create data base,and use show to see it. as linux system, we can use up arrow to find previous used commands. No matter you use capital letter for database name or not, it will always in 小寫 Tell mysql which database to be used: 1 U...