RE: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

character. (e.g. z*) > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > ChoiSaehoon schrieb: > > I tried it, then it gives the following error message > > > > mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls > > z

RE: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

-0500 > Subject: Re: mysqldump syntax - dumping only specific tables starting with a > certain character. (e.g. z*) > From: jlyons4...@gmail.com > To: saeho...@hotmail.com > CC: mysql@lists.mysql.com > > try something like: > > mysqldump -u(user) -p (db-name) `ls z*` &g

mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

Is there a way to dump only specific tables starting with a certain character? For example, I only want to dump tables starting with the character 'z'. The following doesn't work. mysqldump -u(user) -p (db-name) z* > (filename) Do I have to use regular expression here? Please hel

RE: Data structure for matching for company data

Thanks for the resource! Arthur. SIC seems to be great for most industries, but not for high-tech industries. (e.g. it doesn't have Internet or software etc) Still a great tip, though. Thanks again! :) Date: Fri, 27 Mar 2009 19:13:51 -0500 Subject: Re: Data structure for matching for com

RE: Data structure for matching for company data

ry > >id(fk)...? > > Yes, you've got it. In the matching (usually called "bridging") table, > any company or industry can appear multiple times, but no combo can > appear more than once. > > PB > http://www.artfulsoftware.com > > --

Data structure for matching for company data

I'm a complete newbie, so please feel free to help me here! I simplified my problem as below: 1. Thousands of companies (i.e. company names) 2. 200 industries. Each company has tree-type(?) industry info. (Industry, Sub-industry. Say, each industry has 10 sub-industry information. (10X20))