MySQL operators

2006-09-21 Thread molemenacer
I have a query that searches on a number of criteria and would like help on the last line I have included my code below: where jobs.statusid in (6) and ifnull(jobs.currworkerid,'') like '%' and jobs.dictatorid like '%' and jobs.custcode like '%' and jobs

Trying to open a big sql script

2007-04-19 Thread molemenacer
Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open this file. Does anyone have any suggestions as to a program that can do this

Re: Trying to open a big sql script

2007-04-19 Thread molemenacer
or > so > chunks and write out to a series of smaller files. Edit the smaller > files, > then use shell command to cat them all back into one bigger file. > > HTH, > Dan > > > On 4/19/07, molemenacer <[EMAIL PROTECTED]> wrote: >> >> >> Hi all,