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
Publisher resources
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
FPGAs: Instant Access
FPGAs are central to electronic design! The engineers designing these devices are in need of essential …
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Credible Checklists and Quality Questionnaires
Credible Checklists and Quality Questionnaires starts off with an examination of the critical but commonly overlooked …
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …