...
| Code Block |
|---|
mysql> SHOW CREATE TABLE pfx_dw.user_dim\G *************************** 1. row *************************** Table: user_dim Create Table: CREATE TABLE `user_dim` ( `user_sk` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`user_sk`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> SELECT name FROM user_dim; +---------------+ | name | +---------------+ | Administrator | | bar | | foo | | foobar | | fubar | | jburk | | perforce | | root | | shinya | +---------------+ |
| No Format |
|---|
mysql> SHOW CREATE TABLE pfx_dw.user_dim\G
*************************** 1. row ***************************
Table: user_dim
Create Table: CREATE TABLE `user_dim` (
`user_sk` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`user_sk`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
mysql> SELECT name FROM user_dim;
+---------------+
| name |
+---------------+
| Administrator |
| bar |
| foo |
| foobar |
| fubar |
| jburk |
| perforce |
| root |
| shinya |
+---------------+
|
Get a count of all jobs for a particular user:
...