Difference between revisions of "MySQL"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
 
(→‎Working Notes: criticisms section)
Line 2: Line 2:
  
 
The MySQL package (at least in Linux) comes with a number of helper utilities, including [[MySQL Administrator]] and [[MySQL Query Browser]]. The Administrator utility is useful for making backups, and the Query Browser serves as a front-end for interacting with databases. The Query Browser is, however, somewhat buggy as of version 4.
 
The MySQL package (at least in Linux) comes with a number of helper utilities, including [[MySQL Administrator]] and [[MySQL Query Browser]]. The Administrator utility is useful for making backups, and the Query Browser serves as a front-end for interacting with databases. The Query Browser is, however, somewhat buggy as of version 4.
 +
==Criticisms==
 +
MySQL has been criticized by at least one user of lacking production-quality features, with version 5.0 only just starting to add them, where as other [[FOSS]] alternatives such as [[PostgreSQL]] had such features in their very earliest versions. MySQL has also been criticized for bad performance, e.g. locking entire tables when it only should have locked a row, as well as general incompatibility (Editor's note: with what?). (See also [[Wikipedia:MySQL#Criticisms of MySQL]])
 
==Working Notes==
 
==Working Notes==
 
* To work around the Query Browser bug which won't let you edit a blank table, create the first entry using MySQL's command line interface:
 
* To work around the Query Browser bug which won't let you edit a blank table, create the first entry using MySQL's command line interface:
Line 22: Line 24:
  
 
...where ''yourhost'' is the name of your MySQL server, and can be anything that can resolve to an IP address, e.g. localhost, yourmachinename, yourserverdomain.com, or an actual IP address (I think).
 
...where ''yourhost'' is the name of your MySQL server, and can be anything that can resolve to an IP address, e.g. localhost, yourmachinename, yourserverdomain.com, or an actual IP address (I think).
 +
 
==Links==
 
==Links==
 
* [http://mysql.com/ MySQL] Home Page
 
* [http://mysql.com/ MySQL] Home Page
 
** [http://dev.mysql.com/doc/refman/4.1/en/ Version 4.1 Manual]
 
** [http://dev.mysql.com/doc/refman/4.1/en/ Version 4.1 Manual]

Revision as of 23:43, 8 November 2005

computing: software: MySQL

This page is a seed article. You can help HTYP water it: make a request to expand a given page and/or donate to help give us more writing-hours!

MySQL is a FOSS database engine and server. It fills roughly the same niche as Microsoft SQL Server.

The MySQL package (at least in Linux) comes with a number of helper utilities, including MySQL Administrator and MySQL Query Browser. The Administrator utility is useful for making backups, and the Query Browser serves as a front-end for interacting with databases. The Query Browser is, however, somewhat buggy as of version 4.

Criticisms

MySQL has been criticized by at least one user of lacking production-quality features, with version 5.0 only just starting to add them, where as other FOSS alternatives such as PostgreSQL had such features in their very earliest versions. MySQL has also been criticized for bad performance, e.g. locking entire tables when it only should have locked a row, as well as general incompatibility (Editor's note: with what?). (See also Wikipedia:MySQL#Criticisms of MySQL)

Working Notes

  • To work around the Query Browser bug which won't let you edit a blank table, create the first entry using MySQL's command line interface:
woozle@camilla:~ $ mysql -hyourhost -uyourusername -pyourpassword
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12531702 to server version: 4.1.13-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use yourdatabasename
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> insert into urole (fieldname) values("sample value");
Query OK, 1 row affected (0.05 sec)

mysql>

...where yourhost is the name of your MySQL server, and can be anything that can resolve to an IP address, e.g. localhost, yourmachinename, yourserverdomain.com, or an actual IP address (I think).

Links