tailieunhanh - MySQL Basics for Visual Learners PHẦN 3

Bây giờ bạn có thể cung cấp cho các lệnh để thêm / xóa / sửa đổi gì trong máy chủ MySQL, nhưng không phải máy tính Linux chạy trên. Tại dấu nhắc mysql, gõ: CREATE DATABASE us_presidents; sau đó nhấn ENTER. Cửa sổ sẽ giống như sau: Type: xuất cảnh sau đó nhấn ENTER. Cửa sổ Konsole nên đóng | Tip Both the MySQL server and the Linux computer itself can have root users who can add delete modify anything. The passwords for each are independent however. textbook is not the Root account password of your Linux computer. It s the root password for the MySQL server. In the previous string of commands you logged into the MySQL server as its root user so the password textbook applies to the MySQL server. You can now give commands to add delete modify anything in the MySQL server but not the Linux computer it runs on. GETTING STARTED WITH MYSQL 23 Create a new database 1. At the mysql prompt type CREATE DATABASE us_presidents then press ENTER. The window should look like this 24 GETTING STARTED WITH MYSQL Tip Now that you re logged into the MySQL server you re giving MySQL commands. Unlike Linux commands MySQL commands need a semicolon on the end to execute. The CREATE DATABASE command created a database called us_presidents in the MySQL server. If ever you mistakenly end a command string with a character other than a semicolon. CREATE DATABASE us_presidents . then press ENTER there is no way to fix that command. Just add a semicolon to the new line you are on CREATE DATBASE us_presidents If the command is valid it will execute. If there was an error in the command string and it s invalid adding a semicolon here will execute it and MySQL will give an error. GETTING STARTED WITH MYSQL .