Re: Cannot set auto-increment value to a specific number

On Saturday, 13. April 2002 23:31, Alex Duffield wrote: > Ignore this ---Get around silly filter -- sql,query > > >> Description: > > Using myisamchk -A=nn reports success but does nothing! > > > I found this problem is being had by many, but have never come across a > solution.. > > Is there so

[newbie] better practice techniques

I'm just wondering.. say i have a members table as my main table in MYSQL.. and in that table i have a field named month, that will be one of twelve options. would it be better practice to have the month field linked to another table called months and have the month table populated with the val

Re: Transferring Databases

You need to login to the mysql client program and then use the source command: for example login with: mysql -u root -p once running type: source dumpfilename.sql If you can't do it this way, consider using an alternate GUI program like mysql-front (mysqlfront.de). That's

Transferring Databases

Hi-- I'm trying to transfer information from a MySQL database on one server to a MySQL database on another server. I am using PHPMyAdmin. For small tables in the database, no problem. I just do the dump (data and structure) to a file. Then i either copy the contents of that file into the 'Run S

Re: Got error 127 from table handler

On Thursday, April 11, 2002, at 11:07 AM, Michael Widenius wrote: > I do get most hard bug reports forwarded to me and I haven't seen > anything that would indicate that symlinking databases is something > that many people do or that it could explain any of the problems I > have seen. > > The lin

Re: Cannot set auto-increment value to a specific number

At 14:31 -0700 4/13/02, Alex Duffield wrote: >Ignore this ---Get around silly filter -- sql,query >>> Description: >Using myisamchk -A=nn reports success but does nothing! -Ann for the short form (no = unless you use the long option) > > >I found this problem is being had by many, but have neve

Re: trouble with join

On Saturday 13 April 2002 4:34 pm, Samwise Gamgee wrote: > I am trying to update a table with information from that same table and > another table. I have two tables, player and goalie, for a hockey pool. > The field pool_points is total points for forwards, goals * 2 for > defencemen and point

trouble with join

I am trying to update a table with information from that same table and another table. I have two tables, player and goalie, for a hockey pool. The field pool_points is total points for forwards, goals * 2 for defencemen and point + wins * 2 + ties + shutouts * 5. The goalie table is separa

Cannot set auto-increment value to a specific number

Ignore this ---Get around silly filter -- sql,query >> Description: Using myisamchk -A=nn reports success but does nothing! I found this problem is being had by many, but have never come across a solution.. Is there some way to manually set the auto_increment or not??!!!? -- Alex Duffield C

RE: Bill-of-Materials

Since MySQL does not yet support stored procedures, and this problem requires looping logic, I'm guessing no. You will have to use whatever language you are using to access MySQL to do it. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message-

RE: remote connection/users

Check the docs on GRANT. Sounds like you have an incorrect host. Either set the host to % on your current record (manually and then FLUSH PRIVILEGES) or figure out the hostname from the machine you are trying to connect from and grant yourname@hostname the necessary privileges. =C= * * Cal Eva

Bill-of-Materials

Hello! As a newbie to MySQL (and used to be running DB2), I'm looking for a way to explode a bill-of-materials table. Is there any support for recursive SQL in MySQL, for example by using standard common table expressions? Thanks in advance! Lennart Henäng Henfield AB Sollentuna, Sweden ---

remote connection/users

I am new with mysql. I have the latest version installed on a win2k = machine. I am trying to access mysql DB from another machine. It = returns invalid username/password, but if i connect locally with the = same login info it connects fine. What do i have to do to allow any = remote host to

RE: I have been warned...

Did you check the log file? * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Adam Sent: Friday, April 12, 2002 7:51 PM To: mysql mailing list Subject: I have been warn

What is the completion hash??

> > >Can anyone tell me what the completion hash is please? > >Where can I find documentation about the completion hash? > >Thanks in advance, > >Balteo. sql,query > - Before posting, please check: http://www.mysql.com/manu

Regexps & Order By

Hi, Can anyone point me towards some detaile info on using regular expressions within queries. What I'd like to do is a search and replace in the order by field. For various rather long winded reasons it is necessary for us to put latex syntax directly into our db fields so for example Surnam

How does DISTINCT really work ?

Hi, I wonder how works DISTINCT when using it with the following join. Ex : mysql> SELECT DISTINCT topic FROM searchmainhardwarefr7,searchjoinhardwarefr7 WHERE searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND (mot='test') AND date >= '2002-03-24' ORDER BY date DESC LIMIT 0,2

Query regarding FILE HANDLING

Hello, I read the MySQL Reference Manual for version 3.23.49. I tried some C API's, but was stuck up trying to insert data from a file into the MySQL database. Please help me out as i could not find any material on FILE HANDLING in MySQL C API. Thanking You in anticipation... Ritu Sing

Question

Hello, i read the MySQL Reference Manual for version 3.23.49. I tried some C API's, but was stuck up when trying to insert data from a file into the MySQL database. Please help me out as i could not find any material on FILE HANDLING in MySQL C API. Looking forward to read from your side as e

connect from foreign host

I can use mysql server with all ways from localhost. But, there is no connection from any foreign host. I have two linux server. One of is mysql server. I try to connect from other server to mysql server. mysql -u user -h mysql.ser.adress -p and answer from mysql connection: Can't connect to

Re: load file from remote host

Jim, Saturday, April 13, 2002, 2:00:55 AM, you wrote: JP> Is it possible to load a file from a remote host as data type blob? This JP> needs to be done from within the C API. Only using MySQL - no, with other programs/languages yes ... -- For technical support contracts, goto https://order.