Set password for Replace xxxx with your chosen password Query all the users and their password from database "mysql" table "user" For ease of use, we shall shorten and rename the directory to " d:\myproject\ mysql". MySQL will be unzipped as " d:\myproject\ mysql-5.5.xx-win32". I suggest that you unzip into " d:\myproject". DO NOT unzip into your desktop (because it is hard to locate the path).
How to Install MySQL 5.5 and Get Started STEP 1: Download and Install MySQL No UNDO!!! Introduction to MySQLĪ MySQL database server contains one or more databases (aka schemas).
UPDATE class101 SET gpa = gpa + 1.0 WHERE name = 'Tan Ah Teck'ĬREATE TABLE class101 (id INT, name VARCHAR(50), gpa FLOAT)ĭROP TABLE class101 // Delete the table. UPDATE class101 SET gpa = 5.0 // ALL rows INSERT INTO class101 VALUES (88, 'Mohammed Ali', 4.88) DELETE -ĭELETE FROM class101 // Delete ALL rows!!! The wildcard _ matches one (any) character. The wildcard % matches zero or more (any) characters Use operator "LIKE" for pattern matching. Comparison operators are: =, >, =, (!=). The wildcard * denotes all the columns. SQL strings use single quotes (instead of Java/C/C++'s double quotes). SELECT * FROM class101 WHERE gpa > 3.0 OR name LIKE '%T_n%' ORDER BY gpa DESC, name ASC SELECT name, gpa FROM class101 WHERE name = 'Tan Ah Teck' We could issue these SQL commands, which are intuitive, to query the database or manipulate data: - SELECT.