| sub-categories and articles |
|
| |
|
 cdrom_books_mysql |
add
|
| mysql_5_doc |
add
|
| mysql_c |
add
|
| mysql_perl |
add
|
| mysql_php |
sample php mysql functions
|
| mysql_sql |
add
|
| releases |
add
|
| scripts |
add
|
| spools |
add
|
| src |
add
|
--->create new sub-category
|
 column_types.htm |
add
|
master_slave.htm |
add
|
mysql_admin.htm |
add
|
mysql_backup.htm |
add
backing up
|
mysql_functions.htm |
aggregate and date functions
sql functions
|
mysql_i18n.txt |
mysql encoding issues
mysql and i18n internationalization
|
mysql_install.htm |
add
installing mysql
- one instance
- two or more instances
- how to
|
|
mysql_intro.htm |
add
introduction to mysql
|
mysql_sql.htm |
example sql mysql select update insert delete sql samples
sql examples
SQL queries in mysql are entered to the RDBMS through the mysql command line utility, through scripts (php,C,C++) and some also via the mysqladmin utility, e.g. mysqladmin -p create DATABASENAME.
- alter
- create and drop table
- create and drop database
- create and drop users
- delete
- grant and revoke
- insert
- load data
- rename
- select
- mysql specific metadata commands: show, describe
- update
- sql functions: aggregate/group functions, case, cast, concat, coalesce, coalesce, quote, last_insert_id, substring index, todays
|
|
mysql_users.htm |
add
|
mysql_utilities.htm |
mysqladmin, safe_mysqld, utilities
utilities
|
mysqldump.sh |
samples of mysql_dump with data and without data and dropping a whole database and dropping only certain selected tables only
#!/bin/sh
#mysqldump --add-drop-table dict_explicit english_english
#mysqldump --add-drop-table --no-data dict_explicit english_english
#mysqldump dict_explicit g4_write_aaec g4_write_aaed g4_write_aaopinions g4_write_acet g4_write_linksenglish --no-data > dict_explicit.sql
#mysqldump dict_explicit g4_write_aaec g4_write_aaed g4_write_aaopinions g4_write_acet g4_write_linksenglish --skip-add-drop-table > dict_explicit.txt
|
mysqldump.txt |
myqsldump text
#!/bin/sh
present=`date +%b%d%y`
mysqldump -uxxxxxxx -pxxxxx --databases horseclass > $present.sql
|
replication.htm |
add
master and slave status
|
table_design.htm |
outline of mysql table design strategy
table and data types -- table creation
|
--->upload your article
|
User submitted category site links |
|
strings file December
- 1. MySQL AB :: MySQL 5.0 Reference Manual :: 10.5.2 COLLATE Clause Precedence
-
MySQL Manual
URL: http://dev.mysql.com/doc/refman/5.0/en/charset-collate-precedence.html - 10KB - 14 Feb 2007
|
-->submit a page from your site dealing with mysql to the sirfsup! web directory for listing |
