The Visibooks Guide to MySQL BasicsVisibooks, LLC |
Contents
Getting Started | 1 |
Administering Databases | 49 |
Working with Tables | 71 |
Running Queries | 85 |
Securing a database | 105 |
Webenabling | 115 |
Common terms and phrases
Adams Federalist Apache Web server assign fields backups backups/us_presidents.sql CGI script CHAR 25 chmod Click the button Close the MySQL command string connection to database connectionInfo CREATE TABLE name database dbh->disconnect database information database my dbh database us_presidents Datatype DELETE disconnect from database execute query Exit the Konsole exit then press fields to variables GRANT ALL PRIVILEGES hardware database home directory host="localhost Jack Hanson John Adams Ken Jones Konsole window KWrite last name Linspire Linux command Linux computer MySQL client MySQL database connection MySQL server mysql u root mysqldump u root name table Open the Konsole ORDER BY last party passwd PERL presidents presidents.pl press ENTER query my query query results quote.name_id=name.id random.cgi random.pl results should look root mysql root p us_presidents root password Root user sth->execute sth->finish textbook then press Thomas Jefferson Type us_presidents database us_presidents.sql userid usr/bin/perl usr/lib/cgi-bin Web browser window should look