MySQL-Ch05

Size: px

Start display at page:

Download "MySQL-Ch05"

지원 길
5 years ago
Views:

1 MySQL P A R T 2 Chapter 05 Chapter 06 Chapter 07 Chapter 08

2 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)

3 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

4 PART 2,. NULL.. State City Sales AZ Mesa $94, Phoenix $17, subtotal $117, CA Los Angeles $118, Oakland $38, Subtotal $157, ============================== TOTAL $274, State. $,.,. mysql..,.,,.. SQL,, 330 MySQL(2/e)

5 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

6 PART 2 UNIX MySQL.,..,. MySQL,. MySQL SQL MySQL sampdb.. MySQL. MySQL, MySQL,.. MySQL.,,. MySQL..,,,.,, MySQL 332 MySQL(2/e)

7 Chapter 05..,,. MySQL,..,,..,.. MySQL,. MySQL,., MySQL,,.,, MySQL.,. MySQL. MySQL,. MySQL.. MySQL. MySQL MySQL., MySQL., MySQL(2/e) 333

8 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. MySQL. MySQL API,. MySQL., mysql, mysqladmin, mysqldump MySQL. DBI DBD(Database Driver) Perl, ( DBD MySQL ). 334 MySQL(2/e)

9 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

10 PART 2 > TIP C API C. MySQL,. MySQL C API. C MySQL, Java API., Perl DBI MySQL PHP MySQL C MySQL. > TIP 336 MySQL(2/e)

11 Chapter 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

12 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)

13 Chapter 05. DBD., MySQL., DBI.. Perl DBI API, MySQL DBD MySQL, G Perl DBI.. > TIP Perl, PHP. Perl, PHP. PHP API. PHP. PHP, PHP..., PHP, IP. <?php echo $_SERVER["REMOTE_ADDR"];?>.. MySQL(2/e) 339

14 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 ("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)

15 Chapter API. C, DBI, PHP API.,,.,., MySQL C, C!. API. API API MySQL..,,, ,.,, cron. cron.,..,? MySQL(2/e) 341

16 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 ,.,. cron.,.,.,, 342 MySQL(2/e)

17 Chapter 05.,.. API API. API.,.,.,,,....,,,.. C, Perl PHP, C Perl PHP. C.,., C, C..., MySQL., Apache, Apache. MySQL(2/e) 343

18 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)

19 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., ). ID. ID,., (, ).. MySQL(2/e) 345

20 PART 2. Perl PHP, Apache.,., Apache suexec ID (, Apache.x Apache.x. Apache.x ID ID ) ,., MySQL API. Perl PHP C, C API...!,,..,.., PHP Perl / ( ID/ ). C. C,,..,. C 346 MySQL(2/e)

21 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

22 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)

23 Chapter 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

24 PART 2 DBI. MySQL, msql, PostgreSQL. DBI, DBI >connect( ). PHP,. PEAR. 350 MySQL(2/e)

01_피부과Part-01

01_피부과Part-01 PART 1 CHAPTER 01 3 PART 4 C H A P T E R 5 PART CHAPTER 02 6 C H A P T E R CHAPTER 03 7 PART 8 C H A P T E R 9 PART 10 C H A P T E R 11 PART 12 C H A P T E R 13 PART 14 C H A P T E R TIP 15 PART TIP TIP