FsseInfo: MySQL Design & Query

Revision [750]

Last edited on 2008-10-02 11:17:27 by FsseInfo

Additions:

MysqlAdmin
MySqlCommand
MysqlDump

Deletions:

mysqladmin
mysqldump
mysql

Revision [232]

Edited on 2006-10-06 12:43:16 by FsseInfo

Additions:

MySqlFunctions

Revision [227]

Edited on 2006-10-05 12:13:39 by FsseInfo

Additions:

MySqlDataDefinition

Revision [223]

Edited on 2006-10-05 12:12:13 by FsseInfo

Additions:

==Other MySql Client Utilities==
[[http://dev.mysql.com/doc/refman/4.1/en/client-utility-overview.html MySql Client and Utility Programs]]

Deletions:

MySqlAdministration
MySqlDataDefinition

Revision [217]

Edited on 2006-10-05 12:04:00 by FsseInfo

Additions:

===MySQL Management & Operation===
MySqlAdministration
MySqlDataDefinition
MySqlDataManipulation (SIUD aka CRUD)
===MySQL GUI Tools===
===MySQL Command Line Tools===

Deletions:

SQL Design & Query
==MySQL GUI Tools==
==MySQL Command Line Tools==
==MySQL User Management==
MySqlCreateUserPermission (use mysql or WebMin)
MySqlCreateUserDatabase (use mysql or WebMin)
==MySQL Administration==
MySqlFlush
Note : After you've changed permissions you need to flush the privileges
%%
> flush privileges
%%
MySqlShow
==MySQL Data Definition==
MySqlCreateDatabase (use mysql or WebMin)
MySqlCreateTable
MySqlAlterTable
MySqlDescribe
MySqlExplain
==MySQL Data Manipulation (SIUD aka CRUD)==
MySqlSelect
MySqlInsert (including "insert ... select" )
MySqlUpdate
MySqlDelete

Revision [215]

Edited on 2006-10-05 11:57:20 by FsseInfo

Additions:

mysqladmin
mysqldump
mysql
==MySQL Administration==
MySqlFlush
Note : After you've changed permissions you need to flush the privileges
MySqlDescribe
MySqlExplain

Deletions:

$ mysql
After you've changed permissions you need to flush the privileges

Revision [213]

Edited on 2006-10-05 11:49:06 by FsseInfo

Additions:

==MySQL Data Manipulation (SIUD aka CRUD)==

Deletions:

~~==MySQL Data Manipulation==~~

Revision [196]

Edited on 2006-10-04 03:56:49 by FsseInfo

Additions:

==MySQL User Management==
After you've changed permissions you need to flush the privileges
> flush privileges

Revision [142]

Edited on 2006-09-20 12:52:46 by FsseInfo

Additions:

>>http://dev.mysql.com/
>>===MySQL Design & Query===
==MySQL GUI Tools==
==MySQL Command Line Tools==
==MySQL Data Definition==
MySqlCreateTable
MySqlAlterTable
==MySQL Data Manipulation==

Deletions:

====MySQL Design & Query====
===MySQL Command Line Tools===
===MySQL GUI Tools===
===MySQL Data Definition===
===MySQL Data Manipulation===

Revision [115]

Edited on 2006-09-14 05:33:14 by FsseInfo

Additions:

====MySQL Design & Query====
SQL Design & Query
===MySQL Command Line Tools===
%%
$ mysql
%%
===MySQL GUI Tools===
[[http://dev.mysql.com/downloads/workbench/1.0.html MySQL Designer]] & DB Reverse Engineering tool
[[http://dev.mysql.com/downloads MySQL Administrator]]
[[http://dev.mysql.com/downloads/query-browser/1.1.html MySQL Query Browser]]
===MySQL Data Definition===
===MySQL Data Manipulation===
MySqlSelect
MySqlShow
MySqlInsert (including "insert ... select" )
MySqlUpdate
MySqlDelete

Deletions:

====MySQL Designer & Reverse Engineering====
http://dev.mysql.com/downloads/workbench/1.0.html
====MySQL Query Browser====
http://dev.mysql.com/downloads/query-browser/1.1.html
====MySQL Create Database====
====MySQL Create User Permission====
====MySQL Create User Database Access====

Revision [35]

The oldest known version of this page was created on 2006-06-19 11:33:00 by FsseInfo