re: Re: INSERT query crashes MySQL

2002-10-24 Thread Victoria Reznichenko
John, Wednesday, October 23, 2002, 7:06:57 PM, you wrote: >> $ perror 144 >> 144 = Table is crashed and last repair failed >> >> Your table is corrupted, try to repair it with REPAIR TABLE or >> myisamchk: >> http://www.mysql.com/doc/en/Repair.html JP> Hmm. REPAIR TABLE gives JP> | mydb

re: Re: INSERT query crashes MySQL

2002-10-23 Thread Victoria Reznichenko
John, Wednesday, October 23, 2002, 5:21:38 PM, you wrote: JP> PHP starts to output the error "Too many references: cannot splice - error JP> 144" JP> When logging into mysql, I get: JP> "Didn't find any fields in table IDRefs" JP> started with -A, I get: JP> "cannot open file: IDRefs.MYD (error:

Re: Re: insert

2002-06-07 Thread Chris Knipe
> Escape the \ > > like so: > > 'c:\\temp\\calc.exe' > > It's all in the manuals. > > Kind Regards, > > Chris Knipe > MegaLAN Corporate Networking Services > Tel: +27 21 854 7064 > Cell: +27 72 434 7582 > > - Original Message - > From: Silmara Cristina Basso > To: [EMAIL PROTECTED]

Re: Re: INSERT IF NOT EXISTS?

2002-05-28 Thread Victoria Reznichenko
Markus, Tuesday, May 28, 2002, 2:15:09 PM, you wrote: >> You can use IGNORE keyword in INSERT statement, but it's not quite the >> same as "INSERT IF NOT EXIST". If you specify IGNORE, any rows that >> duplicate an existing PRIMARY or UNIQUE key in the table >> will be ignored in INSERT: ML> Yes

RE: Re: Insert dates with PHP

2002-05-15 Thread domi
Hi ! You said anything about connecting to mysql. You need to go through 2 steps before mysql_query(). These are mysql_connect() mysql_select_db() please check the URL below, everything is explained very clearly. http://www.php.net/manual/en/function.mysql-query.php You could also tell us