MySQL P A R T 2 Chapter 05 Chapter 06 Chapter 07 Chapter 08
05 Chapter MySQL MySQL. (, C, Perl, PHP),. 5.1 MySQL., mysqldump, mysqlimport, mysqladmin, mysql. MySQL. mysql,. SQL. MySQL... MySQL ( ). MySQL,. MySQL., MySQL, 328 MySQL(2/e)
Chapter 05. MySQL,., mysql MySQL. mysql SQL.. SQL,.,., curses S Lang, X window Tcl/Tk,. SELECT.,,,.. INSERT, REPLACE, UPDATE SQL,. MySQL,., MySQL,. MySQL,. MysQL.. mysql.. MySQL(2/e) 329
PART 2,. NULL.. State City Sales ------------------------------ AZ Mesa $94,384.24 Phoenix $17,328.28 ----------------------- subtotal $117,712.52 ------------------------------ CA Los Angeles $118,198.18 Oakland $38,838.36 ----------------------- Subtotal $157,036.54 ============================== TOTAL $274,749.06. State. $,.,. mysql..,.,,.. SQL,, 330 MySQL(2/e)
Chapter 05. SQL,,. mysql (batch) SQL, mysql, force.,.. SQL, mysql.. LAST_INSERT_ID( ) AUTO_INCREMENT, SQL.. SQL..,. mysql., mysql..... SQL mysql MySQL(2/e) 331
PART 2 UNIX MySQL.,..,. MySQL,. MySQL SQL MySQL sampdb.. MySQL. MySQL, MySQL,.. MySQL.,,. MySQL..,,,.,, MySQL 332 MySQL(2/e)
Chapter 05..,,. MySQL,..,,..,.. MySQL,. MySQL,., MySQL,,.,, MySQL.,. MySQL. MySQL,. MySQL.. MySQL. MySQL MySQL., MySQL., MySQL(2/e) 333
PART 2. API. 5.2, MySQL C C MySQL. API(application programming interface)., MySQL C. MySQL. C C, MySQL C API MySQL. Perl, PHP, Python, Ruby, C++, Tcl API. Java (Java C / ). MySQL API. http://www.mysql.com/portal/development/html/ MySQL. MySQL API,. MySQL., mysql, mysqladmin, mysqldump MySQL. DBI DBD(Database Driver) Perl, ( DBD MySQL ). 334 MySQL(2/e)
Chapter 05 MySQL MySQL. PHP. PHP, MySL,. PHP Personal Home Page,. PHP PHP PHP: Hypertext Preprocessor, GNU( GNU s Not UNIX ). DBI, PHP MySQL. API. API API. API. API., API,.. API. API, A,. MySQL,. (!) MySQL and Perl for the Web(New Riders, ) MySQL Cookbook(O Reilly, ). MySQL DBI. Perl PHP Python DB API Java JDBC MySQL. MySQL(2/e) 335
PART 2 > TIP 5.2.1 C API C. MySQL,. MySQL C API. C MySQL, Java API., Perl DBI MySQL PHP MySQL C MySQL. > TIP 336 MySQL(2/e)
Chapter 05 5.2.2 DBI API Perl. API API,. DBI Perl ([. ] ). DBI(DataBase Interface).. DBD(DataBase Driver). MySQL DBI DBD DBD::mysql. Mysql Mysql modules, msql MySQL. DBD::mysql msql MySQL. Application level Perl script $dbh = DBI->connect ("DBI:mSQL:...");...or... $dbh = DBI->connect ("DBI:mysql"...");...or... $dbh = DBI->connect ("DBI:Pg:..."); Database Interface level Perl interpreter DBI Database Driver level msql/mysql driver Postgres driver Other DBDs RDBMS level msql server MySQL server Postgres server Other servers DBI. DBI,. DBI DBD, MySQL(2/e) 337
PART 2. DBD DBI, DBI.... DBI.,., MySQL. $dbh = DBI->connect ("DBI:mysql:..."); PostgreSQL msql,. $dbh = DBI->connect ("DBI:Pg:..."); $dbh = DBI->connect ("DBI:mSQL:...");. DBI.,., DBI. RDBMS SQL. SQL. SQL,., SQL,., MySQL SHOW TABLES,. DBD., MySQL DBD,. 338 MySQL(2/e)
Chapter 05. DBD., MySQL., DBI.. Perl DBI API, MySQL DBD MySQL, G Perl DBI.. > TIP 5.2.3 Perl, PHP. Perl, PHP. PHP API. PHP. PHP, PHP..., PHP, IP. <?php echo $_SERVER["REMOTE_ADDR"];?>.. MySQL(2/e) 339
PART 2 (, ). <html> <head> <title>u.s. Historical League</title> </head> <body bgcolor="white"> <p>welcome to the U.S. Historical League Web Site.</p> <?php # USHL home page $conn_id = @mysql_connect ("cobra.snake.net", "sampadm", "secret") or exit (); mysql_select_db ("sampdb") or exit (); $result_id = mysql_query ("SELECT COUNT(*) FROM member") or exit (); if ($row = mysql_fetch_row ($result_id)) print ("<p>the League currently has ". $row[0]. " members.</p>"); mysql_free_result ($result_id);?> </body> </html> PHP HTML, <?php?>..., HTML PHP,. DBI PHP., C API., PHP MySQL PHP MySQL C (DBI PEAR, PHP Extension and Add-on Repository. PEAR DBI PEAR::DB PHP. pear.php.net ). 340 MySQL(2/e)
Chapter 05 5.3 API. C, DBI, PHP API.,,.,., MySQL C, C!. API. API API MySQL..,,,. 5.3.1,.,, cron. cron.,..,? MySQL(2/e) 341
PART 2?? API. C,. C. C Perl PHP,. Perl C., Perl. CGI.pm., Perl MySQL. CGI.pm DBI MySQL. PHP,., PHP, MySQL PHP. PHP (, ),., C Perl., Perl C.,,, Perl. 5.3.2,.,. cron.,.,.,, 342 MySQL(2/e)
Chapter 05.,.. API API. API.,.,.,,,....,,,.. C, Perl PHP, C Perl PHP. C.,., C, C..., MySQL., Apache, Apache. MySQL(2/e) 343
PART 2 Apache. Apache Perl PHP, Apache., Apache CGI. Apache CGI(Common Gateway Interface). Apache Apache. Apache Perl PHP mod_perl mod_php. Perl PHP,. CGI.,. Apache....,.,,.., Apache.? Apache. Apache, Apache., Apache., Apache,,. 344 MySQL(2/e)
Chapter 05 Perl PHP ( mod_perl mod_php ),? PHP,. PHP Perl, Perl. PHP,,. PHP Zend,, Perl. PHP PHP ( PHP PHP ). PHP, PHP PHP. PHP PHP, PHP. Perl PHP Perl. Apache mod_php mod_perl. PHP. Perl,.. Perl. Perl., Apache (, Apache mod_perl., Perl. Apache mod_perl., http://perl.apache.org/docs/ ). ID. ID,., (, ).. MySQL(2/e) 345
PART 2. Perl PHP, Apache.,., Apache suexec ID (, Apache.x Apache.x. Apache.x ID ID ). 5.3.3,., MySQL API. Perl PHP C, C API...!,,..,.., PHP Perl / ( ID/ ). C. C,,..,. C 346 MySQL(2/e)
Chapter 05.,. Perl PHP,., C. Perl PHP. C,. PHP Perl..,.,?,,?..,.,., Perl DBI PHP API C. API Perl PHP MySQL C MySQL., MySQL Perl PHP C. MySQL, API.. C malloc( ) free( ). Perl PHP., Perl PHP,. MySQL(2/e) 347
PART 2 Perl PHP. C,., C,.,., Perl PHP,. (,,. C, ).. C API., C API. API, (out of sync),. Perl PHP.,. C. Perl PHP,.. C MySQL C API. C C++. Perl Perl ( Apache ). (CPAN, Comprehensive Perl Archive Network ). Perl,.? cpan.perl.org, MIME,. PHP, PHP PEAR. 348 MySQL(2/e)
Chapter 05 5.3.4 MySQL..,, MySQL..,??, API. DBI DBI API. PHP DBI. PHP C API.,.,. PHP PEAR. C API. MySQL.. RDBMS RDBMS,. DBI PHP,., DBI PHP. DBI MySQL(2/e) 349
PART 2 DBI. MySQL, msql, PostgreSQL. DBI, DBI >connect( ). PHP,. PEAR. 350 MySQL(2/e)