Re: Resetting the auto_increment to start from 1

At 20:39 +0100 1/8/03, Stefan Hinz, iConnect (Berlin) wrote: Octavian, I've read the following in a MySQL book: It's a rather old book, which deals with MySQL 3.23, and not with MySQL 4.x. Actually, he's talking about MySQL Cookbook (p549). Which is a new book, which is why I said *may*

May I raise a question?

Dear Editor, After installed the MySQL version 3.23.53, I tried to test the MySQL by typing the following command, relevant error message appears, please advise how to fix. Command: Display Error Message: mysqlshowmysqlshow: Can't connect to MySQL server on

RE: Alter table error

Thats what I thought, but wasnt the case. The directory was open to full control by everyone. I did fix the problem though. It turns out this is an issue with windows not letting anyone edit a file that is in use. And when a table is used mysql will cache and hence windows thinks it's in use and

Re: converting text to hypertext

On 1/8/03 8:34 AM, Rick Tucker [EMAIL PROTECTED] wrote: I just imported a .csv file and one of the columns of data was websites addresses. Those addresses aren't being recognized as links when I output an html table from my queries. I'm scratching me head on how to make the conversion. I

Select * from names where words(name) = 3

Hi All, Not sure how to do this (or even if you can) but thought I would ask anyway. I have a database of names and would like to do a selection based on the number or words in a name eg the name Peter Smith has 2 words the name Peter John Smith has 3 words the name Peter John Fred Smith has 4

Re: Alter table error

It might be a permissions problem. Mysql is trying to create a temporary file to do the ALTER but cannot. Check for the write permissions/ownership on the data directory. Regard, Bhavin. - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday,

Re: My new forum

On Wed, Jan 08, 2003 at 01:31:44PM -0800, Lennart Stevens wrote: I created a new forum for all of you who do not like to dig throught tons of a-mail to find one that really matters.You can talk about Linux, mysql and pretty much whatever else is computer realted. Check it out here

Question -Subselect

How do I correct this SQL code: 2 tables there, lcopen: id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date #this condition :lcreceive.due_date current_date #only affect to : SUM(lcreceive.amount_us) #and NOT : #SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open

Re: Copying MySql database to others

Thanks everyone for your input. Stefan, From, within phpMyAdmin? snip 1. In the left frame, choose the database you want to backup / copy. 2. Click the EXPORT tab in the right frame. 3. Choose the tables in the database you want to backup. 4. Choose Structure and data. 5. Check Enclose table

optimize question

I have a php/mysql application that allows a user to add/remove/update/delete text and records from various tables. To avoid table overhead that comes when column sizes change etc - I am considering implementing an optimization query that will optimize all tables in the db every time the

Re: Book recomendations

Hi: Go look in the section where they keep the O'Reilly books and pick up MySQL Cookbook by Paul DuBois ISBN 0-596-00145-2. It is fair to say that Paul has an above average grasp of the topic. He is often quoted on this list. Regards, Doug On Wed, 08 Jan 2003 08:34:18 -0500, Charles Mabbott

sub select

Hi, I'm using MySQL 4.0.7 gamma version. I just want to know if MySQL support sub select statement. The example of sub select statement is as below. I've tried many times but then get an error. Example: select alc, fdate, sum(totalpax) from (select distinct alc, fln, fdate, totalpax from

Re: converting text to hypertext

At 17:23 -0500 1/8/03, Keith C. Ivey wrote: On 8 Jan 2003, at 12:08, Paul DuBois wrote: You must perform the conversion yourself, displaying the URL both as the href atttribute and body text of an a tag. Don't forget to URL-encode it for use in the attribute, and HTML-encode it for use in

RE: I'm new in Mysql

Please see last line comments text null, I do not believe you need the ',' between the End of statement and the ')' Try this: create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null ) ; Regards, Chuck

Fw: error in HP-UX

Hello all, I've compiled Mysql-3.23.54a in HP-UX-11.11 using gcc. It compiles ok and while running make test, i got following error. Can't create interrupt-thread (error 251, errno: 22) mysqld ended how to overcome this? plz help me asap. Advance Thanks and Regards, -sadha

Re: Load local data infile problem

At 18:39 +0100 1/8/03, Stefan Hinz, iConnect (Berlin) wrote: Charles, I posted the same problem a couple of days ago. LOCAL will not work because of a security improvement the MySQL folks applied. LOAD DATA INFILE C:\\mysql\\fred.txt INTO TABLE data_table; Hope this helps, but only a

Re: WHERE clouse

On Wed, 2003-01-08 at 15:30, Dejan Milenkovic wrote: Hi, Is there a difference in speed between these two querys: SELECT whatever, somethin_else FROM table1 WHERE 1 AND ( table1.whatever='value' OR ) SELECT whatever, somethin_else FROM table1 WHERE table1.whatever='value' OR ...

Re: Load local data infile problem

Thank you all very much for ur replies. I think using load data infile without local is all right for the time being, as the database i m going to use is pretty much going to be static with very little changes over time. so that is sufficient for me. However, if u do have any new ideas or

Re: Load local data infile problem

Thank you all very much for ur replies. I think using load data infile without local is all right for the time being, as the database i m going to use is pretty much going to be static with very little changes over time. so that is sufficient for me. However, if u do have any new ideas or

Timing in mysql

Hi: I am using expect scripts to display huge number of tables in mysql, I wonder is there any command in mysql that display out the timestamp it takes to load the databases. Thanks - Before posting, please check:

Question - subselect

How do I correct this SQL code: 2 tables there, lcopen: id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date #this condition :lcreceive.due_date current_date #only affect to : SUM(lcreceive.amount_us) #and NOT : #SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open

Re: Book recomendations

On Wed, Jan 08, 2003 at 08:34:18AM -0500, Charles Mabbott wrote: I got a gift certificate for book store. I am looking for good MySql books with reference, examples, etc? Anyone have some ideas on good books to look at MySQL by Dubois is a good starter book. Not sure how it works for the

<    1   2