 |
del.icio.us |
 |
Digg |
 |
Furl |
 |
|
 |
Rojo |
| Add to OnlyWire |
 |
All or part of this article may be confusing or unclear. Please help clarify the article. Suggestions may be on the talk page. (February 2008) |
Contents |
MySQL databases
| Prog Language | Access server | Use database | List databases | List tables |
|---|---|---|---|---|
| raw MySQL access | use db; | show databases; | show tables; | |
| PHP | $db = mysql_access(host, user, password); | mysql_select_db(name, $db); | ||
| Python | db = MySQLdb.connect(host = "hostname", user = "username", passwd = "password", db = "dbname", connect_timeout = 5) | import MySQLdb | c=db.cursor(); c.execute("show databases"); c.fetchall() | c.execute("show tables"); c.fetchall() |
Reading from tables
| Prog Language | Describe | List table content | Search |
|---|---|---|---|
| raw MySQL access | describe tablename; | select field from tablename; | |
| PHP |
Writing on tables
PostgreSQL
Coming soon
See also
 |
This database-related article is a stub. You can help Wikipedia by expanding it. |
