• Personal tools
  • 38.107.191.105
  • Talk for this IP
  • Create an account or log in
• Toolbox
  • What links here
  • Related changes
  • Special pages

SQL

From How2s

Table of contents

1 List databases 2 List tables of database 'wikidb' 3 List index of table 'user' in database 'mysql' 4 show contents of table 'user' in database 'mysql' 5 Non-Aggregates in the result set

List databases

show databases;

List tables of database 'wikidb'

show tables from wikidb;

List index of table 'user' in database 'mysql'

show index from user from mysql;

show contents of table 'user' in database 'mysql'

select * from mysql.user;

or, alternatively:

use mysql; select * from user;

Non-Aggregates in the result set

If you need non-aggregates in the result set, it can be a real pain. Use max, min etc. to get nice workarounds. Example

select first 30 w.owner, u.gender max(w.created) from weblog w, usercore u where w.owner=u.nick \ 
group by w.owner, u.gender order by max(w.created) desc

(Firebird/Interbase SQL syntax!) This shows a list with 30 entries of all the users that have AT LEAST ONE weblog post done recently.