Book description
MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Both products are free for nonprofit use and cost a small amount for commercial use. Even a small organization or web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your web site's visitors for their interests and preferences and put up a fresh web page that tallies the results. Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a web page becomes its own interface to the database. This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material. Topics include:
Introductions to simple database design and SQL
Building, installation, and configuration
Basic programming APIs for C, C++, Java (JDBC), Perl, and Python
CGI programming with databases in C and Perl
Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl
Table of contents
-
MySQL & mSQL
- Preface
-
I. Getting Started with MySQL and mSQL
- 1. Introduction to Relational Databases
- 2. Database Design
- 3. Installation
- 4. MySQL
- 5. mSQL
- 6. SQL According to MySQL and mSQL
- 7. Other Mid-Range Database Engines
- II. Database Programming
-
III. Reference
- 15. SQL Reference
- 16. MySQL and mSQL System Variables
- 17. MySQL and mSQL Programs and Utilities
-
18. PHP and Lite Reference
-
PHP
- abs
- addslashes
- asort
- bindec
- ceil
- chdir
- chgrp
- chimed
- chown
- chop
- chr
- clearstack
- clearstatcache
- closedir
- closelog
- cos
- count
- crypt
- date
- dblist
- decbin
- dexhex
- decoct
- doubleval
- echo
- end
- ereg
- eregi
- ereg_replace
- eregi_replace
- escapeshellcmd
- eval
- exec
- exit
- exp
- fclose
- feof
- fgets
- fgetss
- file
- fileatime
- filectime
- filegroup
- fileinode
- filemtime
- fileowner
- fileperms
- filesize
- filetype
- floor
- flush
- fopen
- fputs
- fpassthru
- fseek
- fsockopen
- ftell
- getaccdir
- getenv
- gethostbyname
- gethostbyaddr
- getimagesize
- getlastaccess
- getlastbrowser
- getlastemail
- getlasthost
- getlastmod
- getlastref
- getlogdir
- getmyinode
- getmypid
- getmyuid
- getrandmax
- getstartlogging
- gettoday
- gettotal
- gettype
- gmdate
- header
- hexdec
- htmlspecialchars
- imagearc
- imagechar
- imagecharup
- imagecolorallocate
- imagecolortransparent
- imagecopyresized
- imagecreate
- imagecreatefromgif
- imagedestroy
- imagefill
- imagefilledpolygon
- imagefilledrectangle
- imagefilltoborder
- imagegif
- imageinterlace
- imageline
- imagepolygon
- imagerectangle
- imagesetpixel
- imagestring
- imagestringup
- imagesx
- imagesy
- include
- initsyslog
- intval
- isset
- key
- link
- linkinfo
- log
- log10
- logas
- max
- md5
- microtime
- min
- mkdir
- mktime
- msql
- mysql
- mysql_affected_rows
- msql_close
- mysql_close
- msql_connect
- mysql_connect
- msql_createdb
- mysql_createdb
- msql_dbname
- mysql_dbname
- msql_dropdb
- mysql_dropdb
- msql_fieldflags
- mysql_fieldflags
- msql_fieldlen
- mysql_fieldlen
- msql_fieldname
- mysql_fieldname
- msql_fieldtype
- mysql_fieldtype
- msql_freeresult
- mysql_freeresult
- mysql_insert_id
- msql_listdbs
- mysql_listdbs
- msql_listfields
- mysql_listfields
- msql_listtables
- mysql_listtables
- msql_numfields
- mysql_numfields
- msql_numrows
- msql_numrows
- msql_regcase
- msql_result
- mysql_result
- msql_tablename
- mysql_tablename
- next
- octdec
- opendir
- openlog
- ord
- parse_str
- passthru
- pclose
- phpinfo
- phpversion
- popen
- pos
- pow
- prev
- putenv
- quotemeta
- rand
- readdir
- readfile
- readlink
- reg_match
- reg_replace
- reg_search
- rename
- reset
- return
- rewind
- rewinddir
- rmdir
- rsort
- setcookie
- seterrorreporting
- setlogging
- setshowinfo
- settype
- shl
- shr
- sin
- sleep
- sort
- soundex
- sprintf
- sqrt
- srand
- strchr
- strstr
- strtr
- stripslashes
- strlen
- strrchr
- strtok
- strtolower
- strtoupper
- strval
- substr
- symlink
- syslog
- system
- tan
- tempnam
- time
- umask
- uniqid
- unlink
- unset
- urldecode
- urlencode
- usleep
- virtual
-
Lite
- chdir
- chmod
- chop
- close
- ctime
- echo
- fprintf
- gethostbyaddr
- gethostbyname
- getpid
- getpwnam
- getpwuid
- includeFile
- kill
- link
- mkdir
- msqlConnect
- msqlClose
- msqlDataSeek
- msqlEncode
- msqlFetchRow
- msqlFieldSeek
- msqlFreeResult
- msqlInitFieldList
- msqlListDBs
- msqlListField
- msqlListTables
- msqlNumRows
- msqlQuery
- msqlSelectDB
- msqlStoreResult
- open
- pid
- printf
- read
- readln
- readtok
- rename
- rmdir
- setContentType
- sleep
- split
- stat
- strftime
- strseg
- sub
- substr
- symlink
- system
- test
- time
- time2unixtime
- tr
- truncate
- umask
- unixtime2*
- unlink
- urlEncode
-
PHP
-
19. C Reference
- MySQL C API
- mysql_affected_rows
- mysql_close
- mysql_connect
- mysql_create_db
- mysql_data_seek
- mysql_debug
- mysql_drop_db
- mysql_dump_debug_info
- mysql_eof
- mysql_errno
- mysql_error
- mysql_escape_string
- mysql_fetch_field
- mysql_fetch_field_direct
- mysql_fetch_fields
- mysql_fetch_lengths
- mysql_fetch_row
- mysql_field_seek
- mysql_field_tell
- mysql_free_result
- mysql_get_client_info
- mysql_get_host_info
- mysql_get_proto_info
- mysql_get_server_info
- mysql_info
- mysql_init
- mysql_insert_id
- mysql_kill
- mysql_list_dbs
- mysql_list_fields
- mysql_list_processes
- mysql_list_tables
- mysql_num_fields
- mysql_num_rows
- mysql_ping
- mysql_query
- mysql_real_connect
- mysql_real_query
- mysql_reload
- mysql_row_tell
- mysql_select_db
- mysql_shutdown
- mysql_stat
- mysql_store_result
- mysql_thread_id
- mysql_use_result
- mSQL C API
- msqlConnect
- msqlSelectDB
- msqlQuery
- msqlStoreResult
- msqlFreeResult
- msqlFetchRow
- msqlDataSeek
- msqlNumRows
- msqlFetchField
- msqlFieldSeek
- msqlNumFields
- msqlClose
- msqlListDBs
- msqlListTables
- msqlListFields
- msqlListIndex
-
20. Python Reference
-
Module: MySQL
- Method: MySQL.connect( )
- Method: connection.selectdb( )
- Method: connection.do( )
- Method: connection.query( )
- Method: statement_handle.affectedrows( )
- Method: statement_handle.numrows( )
- Method: statement_handle.fields( )
- Method: statement_handle.fetchrows( )
- Method: connection.listdbs( )
- Method: connection.listtables( )
- Module: mSQL
-
Module: MySQL
-
21. Perl Reference
- Installation
-
DBI.pm API
- use
- DBI::available_drivers
- DBI::bind_col
- DBI::bind_columns
- DBI::bind_param
- DBI::connect
- DBI::data_sources
- DBI::do
- DBI::disconnect
- DBI::dump_results
- $DBI::err
- $DBI::errstr
- DBI::execute
- DBI::fetchall_arrayref
- DBI::fetchrow_array
- DBI::fetchrow_arrayref, DBI::fetch
- DBI::fetchrow_hashref
- DBI::finish
- DBI::func
- DBI::neat
- DBI::neat_list
- DBI::prepare
- DBI::quote
- DBI::rows
- DBI::state
- DBI::trace
- DBI::commit, DBI::rollback, DBI::ping
- Attributes
-
Msql.pm API
- use Msql
- Msql::connect
- Msql::createdb
- Msql::database
- Msql::dropdb
- Msql::errmsg
- Msql::getsequenceinfo
- Msql::host
- Msql::listdbs
- Msql::listfields
- Msql::listindex
- Msql::listtables
- Msql::query
- $Msql::QUIET
- Msql::quote
- Msql::selectdb
- Msql::shutdown
- Msql::Statement::as_string
- Msql::Statement::dataseek
- Msql::Statement::fetchcol
- Msql::Statement::fetchhash
- Msql::Statement::fetchrow
- Msql::Statement::isnotnull
- Msql::Statement::isnum
- Msql::Statement::isprikey
- Msql::Statement::length
- Msql::Statement::listindices
- Msql::Statement::maxlength
- Msql::Statement::name
- Msql::Statement::numfields
- Msql::Statement::numrows
- Msql::Statement::table
- Msql::Statement::type
- Msql::sock
- Msql::*_TYPE
- $Msql::VERSION
- Mysql.pm API
- 22. JDBC Reference
- Index
- Colophon
Product information
- Title: MySQL and mSQL
- Author(s):
- Release date: July 1999
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565924345
You might also like
book
Managing & Using MySQL, 2nd Edition
MySQL is a popular and robust open source database product that supports key subsets of SQL …
book
Sams Teach Yourself MySQL in 21 Days, Second Edition
MySQL is the most widely installed open-source database. Approximately 3.5 million MySQL servers are in use …
book
MySQL® Phrasebook
The MySQL Phrasebook is a pocket guide that is jam-packed with useful and essential code "phrases" …
book
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 …