All pastes #985073 Raw Edit

Stuff

public text v1 · immutable
·published 2008-04-14 19:35 UTC
rendered paste body
mysql> select * from Manager_Skills limit 0, 100;
+---------+-----------------------+---------------------------+
| ID      | Skill Category        | Skill Description         |
+---------+-----------------------+---------------------------+
| 2331381 | INDUSTRY SECTOR       | MANUFACTURING - OTHE      | 
| 2331381 | THOMSON INDUSTRY      | T_MAN OF TV & TELEPHONE   | 
| 2331381 | NO OF EMPLOYEES       | 200-499                   | 
| 2331382 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2331382 | MISC                  | IT MANAGER                | 
| 2331389 | LOCATION              | MIDLANDS - EAST           | 
| 2331389 | CM_SKILL              | COGNOS                    | 
| 2331389 | LEGACY                | IBM (ALL CODES)           | 
| 2331389 | CM_SKILL              | DATAWAREHOUSING           | 
| 2331389 | CM_LOCATION           | EAST MIDLANDS             | 
| 2331389 | INDUSTRY SECTOR       | RETAIL BANK/BUILDING SOC  | 
| 2331389 | CM_SKILL              | PC                        | 
| 2331389 | THOMSON INDUSTRY      | T_MAN OF CHEMICAL PRODS   | 
| 2331389 | NETWORK/COMMS/SUPPORT | UNIX                      | 
| 2331389 | CM_LOCATION           | WEST MIDLANDS             | 
| 2331389 | NO OF EMPLOYEES       | >500                      | 
| 2331389 | INDUSTRY SECTOR       | HOUSEHOLD GOODS AND TE    | 
| 2331389 | CM_SKILL              | COBOL                     | 
| 2331389 | LEGACY                | MAINFRAME                 | 
| 2331456 | INDUSTRY SECTOR       | FMCG                      | 
| 2331456 | INDUSTRY SECTOR       | FOOD PRODUCERS AND PRO    | 
| 2331456 | LOCATION              | MIDLANDS - WEST           | 
| 2331465 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2331467 | INDUSTRY SECTOR       | FTSE 250                  | 
| 2331467 | CM_SKILL              | DATAWAREHOUSING           | 
| 2331467 | INDUSTRY SECTOR       | RETAIL BANK/BUILDING SOC  | 
| 2331467 | NO OF EMPLOYEES       | >500                      | 
| 2331467 | LOCATION              | LONDON & SOUTH EAST       | 
| 2331467 | BUSINESS INTELLIGENCE | OLAP                      | 
| 2331467 | THOMSON INDUSTRY      | T_RETAIL TRADE            | 
| 2331530 | MISC                  | IT MANAGER                | 
| 2331530 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2331534 | INDUSTRY SECTOR       | LOGISTICS                 | 
| 2331534 | INDUSTRY SECTOR       | TRANSPORT                 | 
| 2331539 | INDUSTRY SECTOR       | TRANSPORT                 | 
| 2331539 | CLIENT STATUS         | INVALID UK POSTCODE       | 
| 2331539 | LOCATION              | LONDON - CITY (WC and EC) | 
| 2331539 | INDUSTRY SECTOR       | DISTRIBUTION              | 
| 2331540 | INDUSTRY SECTOR       | DISTRIBUTION              | 
| 2331540 | CLIENT STATUS         | INVALID UK POSTCODE       | 
| 2331540 | LOCATION              | LONDON - CITY (WC and EC) | 
| 2331540 | INDUSTRY SECTOR       | TRANSPORT                 | 
| 2331685 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2331686 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2331753 | CLIENT STATUS         | CLIENTS-MARKETING         | 
| 2331753 | THOMSON INDUSTRY      | T_W SALERS TRADE/COMMISSI | 
| 2331753 | NO OF EMPLOYEES       | 100-199                   | 
| 2331830 | MISC                  | IT MANAGER                | 
| 2331830 | INDUSTRY SECTOR       | MANUFACTURING - OTHE      | 
| 2331843 | MISC                  | IT MANAGER                | 
| 2331843 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2331901 | THOMSON INDUSTRY      | T_OTHER BUSINESS ACTIVITY | 
| 2331901 | NO OF EMPLOYEES       | 100-199                   | 
| 2331901 | LOCATION              | SOUTH - WEST              | 
| 2331943 | NETWORK/COMMS/SUPPORT | SUPPORT                   | 
| 2331943 | NO OF EMPLOYEES       | >500                      | 
| 2331943 | THOMSON INDUSTRY      | T_HOTELS AND RESTAURANTS  | 
| 2331949 | NETWORK/COMMS/SUPPORT | NETWORKING (ALL CODES)    | 
| 2331949 | MISC                  | IT MANAGER                | 
| 2331949 | INDUSTRY SECTOR       | SOFTWARE AND COMPUTER     | 
| 2331983 | MISC                  | IT MANAGER                | 
| 2331983 | CM_SKILL              | C++                       | 
| 2331983 | CM_SKILL              | UNIX                      | 
| 2331983 | CM_SKILL              | C                         | 
| 2331983 | CM_SKILL              | SQL                       | 
| 2331994 | MISC                  | IT MANAGER                | 
| 2332046 | CLIENT STATUS         | INVALID UK POSTCODE       | 
| 2332046 | NETWORK/COMMS/SUPPORT | SUPPORT                   | 
| 2332046 | INDUSTRY SECTOR       | SOFTWARE AND COMPUTER     | 
| 2332046 | LOCATION              | LONDON - EXCLUDING CITY   | 
| 2332046 | CM_SKILL              | SIEBEL                    | 
| 2332046 | CM_SKILL              | VB                        | 
| 2332048 | INDUSTRY SECTOR       | MANUFACTURING - OTHE      | 
| 2332204 | INDUSTRY SECTOR       | TELECOMMUNICATION SERV    | 
| 2332204 | NETWORK/COMMS/SUPPORT | TELECOMMS                 | 
| 2332204 | MISC                  | IT MANAGER                | 
| 2332204 | THOMSON INDUSTRY      | T_OTHER BUSINESS ACTIVITY | 
| 2332204 | NO OF EMPLOYEES       | 200-499                   | 
| 2332205 | NO OF EMPLOYEES       | 200-499                   | 
| 2332205 | THOMSON INDUSTRY      | T_OTHER BUSINESS ACTIVITY | 
| 2332205 | NETWORK/COMMS/SUPPORT | TELECOMMS                 | 
| 2332205 | INDUSTRY SECTOR       | TELECOMMUNICATION SERV    | 
| 2332243 | BANKING/FINANCE       | FINANCE MARKETING         | 
| 2332243 | MISC                  | IT MANAGER                | 
| 2332243 | THOMSON INDUSTRY      | T_FINANCIAL INTERMEDIATIO | 
| 2332243 | NO OF EMPLOYEES       | >500                      | 
| 2332244 | INDUSTRY SECTOR       | SOFTWARE AND COMPUTER     | 
| 2332256 | INDUSTRY SECTOR       | SOFTWARE AND COMPUTER     | 
| 2332301 | BANKING/FINANCE       | FINANCE INVEST./BANKING   | 
| 2332301 | MISC                  | IT MANAGER                | 
| 2332328 | INDUSTRY SECTOR       | ACCOUNTANCY               | 
| 2332330 | INDUSTRY SECTOR       | SOFTWARE AND COMPUTER     | 
| 2332330 | LOCATION              | LONDON - EXCLUDING CITY   | 
| 2332330 | CM_SKILL              | UNIX                      | 
| 2332330 | NETWORK/COMMS/SUPPORT | NETWORKING (ALL CODES)    | 
| 2332330 | CM_SKILL              | C#                        | 
| 2332509 | THOMSON INDUSTRY      | OTHER BUSINESS ACTIVITY   | 
| 2332509 | THOMSON INDUSTRY      | T_OTHER BUSINESS ACTIVITY | 
| 2332509 | NO OF EMPLOYEES       | 200-499                   | 
| 2332509 | INDUSTRY SECTOR       | TELECOMMUNICATION SERV    | 
+---------+-----------------------+---------------------------+
100 rows in set (0.00 sec)