Re: help on creating missing ids

Dimitar Vasilev wrote: Hi Shawn, Thanks for your response. I'm trying to assign uniquely a user id per share holder within the whole list, not within each company. Suppose we have a person John Smith that holds shares both in MonkeyBusiness and NoSuchThing. I'd like to give him an id that is the

RE: Finding empty feilds

Thanks! -Original Message- From: Gary Josack [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 2:47 PM To: Stephen Sunderlin Cc: mysql@lists.mysql.com Subject: Re: Finding empty feilds NULL does not equal "", " ", "null", "0", 0 or any other variation. Those are all values. N

data position changes when 'Load Data infile'......

Hi Friend, Today I was testing the command 'Load data infile ...' command ( http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html ) in my system. That time I was surprised when I put select statement in that table. The scenario as follows : In a text file which is to be loaded, I am having da

Re: Finding empty feilds

NULL does not equal "", " ", "null", "0", 0 or any other variation. Those are all values. NULL is the lack of a value. IS NULL and IS NOT NULL are operators specific for working with NULL values. Stephen Sunderlin wrote: I was able to delete them using the CreateDate timestamp. For future ref

RE: Finding empty feilds

I was able to delete them using the CreateDate timestamp. For future reference what is the difference between = and is if I may ask. Thanks. -Original Message- From: Gary Josack [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 1:20 PM To: Stephen Sunderlin Cc: mysql@lists

Re: Finding empty feilds

Stephen Sunderlin wrote: I executed an insert...select and some empty fields were inserted into a table. I'm trying to delete these empty fields but a look up for: FIELD = '' FIELD = 'null' FIELD = '0' FIELD = '[SPACE]' Returns nothing. What should I be looking for to delete these empty f

Finding empty feilds

I executed an insert...select and some empty fields were inserted into a table. I'm trying to delete these empty fields but a look up for: FIELD = '' FIELD = 'null' FIELD = '0' FIELD = '[SPACE]' Returns nothing. What should I be looking for to delete these empty fields? Thanks. -- MySQL G

Re: help on creating missing ids

2007/9/22, Shawn Green <[EMAIL PROTECTED]>: > > Hello Dimitar, > > Dimitar Vasilev wrote: > > Hi all, > > I have a table shares that consists of > > company id, shareholder id, shareholder name. > > Company id and shareholder id are decimal digits; shareholder name is > text. > > Due to some missin

Re: query kills mysqld

Will Nordin wrote: MySQL Ver 8.41 Distrib 5.0.27 Intel Xeon 3.60 GHz 2.0 G of RAM Windows Server 2003 Service Pack 1 The following query will sometimes work and sometimes fail. When it fails it kills the mysqld service and requires it to be restarted. Sometimes if I add additional i

Re: help on creating missing ids

Hello Dimitar, Dimitar Vasilev wrote: Hi all, I have a table shares that consists of company id, shareholder id, shareholder name. Company id and shareholder id are decimal digits; shareholder name is text. Due to some missings of my initial data, I'd like to create a unique id for the sharehold

Slave Bin Log Question

I have executed a strategy for backup where I stop a slave and do a mysqldump with --master-data. Both master and slave are 4.1.20 My assumption was that the log coordinates in the dump file would provide me with the place to replay the log for a point in time recovery. What I learned today