Re[2]: Update

2001-09-21 Thread Igbar Foosenhopper
JSaur, >Hello Igbar, > >thank you for your script. >Bud I need to change just word "with". Woman with hammer was just example. >There is text about 1000 words in one fied, and I need to change just a >short string. >I show you another example. > >CREATE TABLE my_table(c1 int NOT NULL PRIMARY KEY,

Re: Update

2001-09-20 Thread Igbar Foosenhopper
Hello JSaur, Here is a php script i whipped up for you. Hope it helps Please Please PLEASE update your data before running this script. I have tried a version of this on a data table here but changing column names etc for testing the changing back can always lead to some error. One thing you

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Igbar Foosenhopper
FYI .. I just tried this my self with CREATE TABLE 010823 (tstamp TIMESTAMP (14) , name VARCHAR (10) not null , PRIMARY KEY (tstamp), INDEX (name)) and got ... MySQL said: You have an error in your SQL syntax near '010823 (tstamp TIMESTAMP (14) , name VARCHAR (10) not null ,

Re: Can't connect to source

2001-09-05 Thread Igbar Foosenhopper
Hello Roland, Basically users are defined with their 'hostname'. So if i dial in from my isp it might be [EMAIL PROTECTED] so I have to define rights to that user. Along with the manual bit below .. you might want to get Paul DuBois's great book on Mysql. This bit is from the manual .. 7.35

Re: Reply-to and this list

2001-08-30 Thread Igbar Foosenhopper
Hello Carl, Reply to All seems to work Thursday, August 30, 2001, 2:13:56 AM, you wrote: CT> A quick question: How come the mailing list software CT> doesn't add a reply-to header? Is this intentional to CT> keep replies off the mysql list, and if so why? CT> I'll try to remember to reply to th

Create Table Syntax for DEFAULT

2001-08-23 Thread Igbar Foosenhopper
Is it possible to use current_date (mysql function) to generate a default for a column? If so .. what would the syntax look like. I have tried several things and it doesn't seem to like it. If not .. how could I generate a default of todays date (of course dependent on the date of insert)? Tha