HELP: MySQL Dynamic Structure

2002-05-31 Thread Ryan Hatch
ion and in light of what I've been exposed to, I feel there is a significant need for dynamic schema properties or something very similar. Please advise. I appreciate everyone's time and help... much thanks i

Re: Transaction isolation

2002-05-22 Thread Ryan Hatch
are you familiar with the different MySQL table types? they are: MyISAM BDB Gemini InnoDB but InnoDB is the most robust, supports row-level locking, ACID transactions (no dirty reads), and foreign key restraints... read up on it here: http://www.innodb.com but InnoDB does multi-versioni

Re: columb structure

2002-05-22 Thread Ryan Hatch
you're not making much sense to me in your first post... you wanted make sure every IP you have is unique, correct? Do an ALTER TABLE with "UNIQUE(octet1, octet2, octet3, octet4)". or am I not understanding your question? Regards, -Ryan Hatch * remember me? yesterday #php

Re: Root user Access denied - Please Help

2002-05-22 Thread Ryan Hatch
yes, you needed to use the PASSWORD( ) function mysqladmin -h hostname -u user password 'new password' -Ryan Hatch "Miretsky, Anya" wrote: > I tried to create a password for the root user in a new installation of > MySQL by typing > % mysql -u root mysql >

Re: update query fails

2002-05-22 Thread Ryan Hatch
x27; ), it will screw up your SQL statement. make sure you run all your variables through a filter to check for single quotes. either backslash them out ( \ ) or prevent your users from using them. -Ryan Hatch Sven Bentlage wrote: > Hi everyone! > > Are there any limitations on update q

Re: transactions on MySQL (innoDB)

2002-05-22 Thread Ryan Hatch
please let us know the SQL query you are trying, and a DESCRIBE TABLENAME so we can see how your table(s) are laid out. also, please tell us what you actually changed in your my.cnf file by the way, before you can do transactions, you must set the AUTOCOMMIT variable to 0 -Ryan Hatch a a

Re: What does this message mean

2002-05-11 Thread Ryan Hatch
I have been receiving this same error message every time I post. ?? anybody? Todd Cary wrote: >I am receiving this message from MySQL: > >+++ >Sorry. Your message could not be delivered to: > >w3d3demo (Mailbox or Conference is full.) >+++ > >What am I missing? > >Todd >-- >Dr. Todd Cary >Arist

Re: newbie help

2002-05-09 Thread Ryan Hatch
gards, -Ryan Hatch --- Steve Buehler wrote: > What makes you think that it is an imposter site? They both have the > same IP address, they are both the same site. > # nslookup mysql.org > Name:mysql.org > Address: 64.28.67.70 >

Re: newbie help

2002-05-09 Thread Ryan Hatch
"bd"... Two things here: 1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. and 2.) You haven't given us the warning / error message you received. -Ryan Hatch [EMAIL PROTECTED] wrote: >I just created a database and tried to LOAD 1 line of data

Help! Deciding on Java/C++ ?

2002-05-07 Thread Ryan Hatch
help, tips, etc. that you guys could provide. Much thanks! -Ryan Hatch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre