HELP: MySQL Dynamic Structure

[Ryan Hatch]

backends to look at
column properties instead of just our columns - we'll
truly reach a Dynamic database environment!  But without
this - it's SO much more work for everyone!  A headache
for the programmer, a nightmare to just add one column,
then add it into all that code, keep the new code all in
a versioning system, and then redistribute standalone
client applications.  When with dynamic column
properties... all one would have to do is make a column
and (for example) mark it visible.

One SQL statement... One minute of time.

Am I missing something here that all other programmers
are using?  Am I embarassing myself as some intermediate
programmer?  Perhaps... but in my humble opinion 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 in advance.


Regards,

-Ryan Hatch
 Database Administrator
 HiTech Enterprises, Inc.
 825 Ontario Road
 Green Bay, WI  54311
 (920) 465-4600


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Transaction isolation

[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-versioning, so be sure to read carefully

Ki Mien wrote:

> Hi all,
>
> We need to prevent Dirty Reading.
>
> How can we perform transaction isolation in mySQL? Are the following: 
>TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED, 
>TRANSACTION_READ_UNCOMMITTED, TRANSACTION_NONE supported by MySQL? Or has anyone 
>tried any other alternatives?
>
> cheers,
> Ki Mien
>
> 
> Take part in the Penning on Squares Chinese Essay Writing Contest.
> Submit your masterpieces or vote for your favourite works, and win attractive prizes.
> Be there or be SQUARE!
> http://sea.litcontest.lycosasia.com
>
> cOntact @ Lycos 
> = 20MB for email and filestore + lots of other goodies...
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: columb structure

[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 on DALNet, G3X7


Chris Knipe wrote:

> Multiple subnets :/
>
> columns like this:
> octet1, octet2, octet3, octet4
> 195,196,192,23
> 232,196,231,11
>
> This would then be seen as a duplicate
>
> Kind Regards,
>
> Chris Knipe
> MegaLAN Corporate InterNetworking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Myk Melez" <[EMAIL PROTECTED]>
> To: "Chris Knipe" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 22, 2002 8:43 PM
> Subject: Re: columb structure
>
> > Chris Knipe wrote:
> >
> > >I'm currently storing them into varchar(16), although I've been thinking
> of
> > >doing it as for smallint columns, but then I can't be 100% certain I
> won't
> > >get duplicates.
> > >
> > Why not?  Just define a UNIQUE index across all four smallint columns,
> > and MySQL will throw an error if you attempt to insert a duplicate
> > record into the table.
> >
> > -myk
> >
> >
> >
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Root user Access denied - Please Help

[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
> Then typing and update statement like
> > Update user set password = "somepassword" where user="root";
> After doing this I typed because I could still get into mysql without a
> password % mysqladmin -u root status % mysqladmin -u root reload
>
> I think what I should have done is typed - update user SET password =
> PASSWORD("somepassword") where user ="root".
>
> Now I can't get into mysql at all as root, with the password I set.
>
> I get the error message "Access denied for user 'root@localhost' (using
> password =YES)"
>
> I have tried to restart mysql with the --skip-grant-tables option but I
> still can't get in as root?
>
> How do I fix this? Can anyone help?
>
> Anya Miretsky
> Computer Technology Dept.
> Brooklyn Botanic Garden
> 1000 Washington Avenue
> Brooklyn, NY  11225
>
> (718)623-7265
> [EMAIL PROTECTED]
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: update query fails

[Ryan Hatch]

be aware... linux/unix table names are case sensitive.  if you're using Win32 MySQL
on your system, the query might work, but on the ISP side, if it's a *NIX system...
you must have the correct capitalization.

moreover, if any of your variables contain a single quote character ( ' ), 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 queries, like on how many fields one
> can update at the same time?
>
> The first  update query works just fine, the second does not work at all:
>
> working :
> " update memberscopy set password='$password' where name =
> '$f_name' and surname ='$f_surname' "
>
> not working:
> " update memberscopy
> set rank='$rank',
> cname='$cname',
> caddress='$caddress',
> ctel='$ctel',
> cfax='$cfax',
> cmobile='$cmobile',
> cemail='$cemail',
> curl='$curl',
> btype='$btype',
> hq='$hq',
> quali='$quali',
> experi='$experi',
> inhouse='$inhouse',
> resid='$resid',
> ptel='$ptel',
> pfax='$pfax',
> pmobile='$pmobile',
> pemail='$pemail',
> marital='$marital',
> spouse='$spouse',
> children_number='$children_number',
> children_names='$children_names',
> hobbies='$hobbies',
> membership='$membership',
> pcont='$pcont',
> lastup=now()
> where name = '$f_name' and surname = '$f_surname'  "
>
> The 2nd query works (for some fields only) on my local machine, but not
> on the ISP's server
>
> Thanks for your help.
>
> Sven
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: transactions on MySQL (innoDB)

[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 wrote:

> Hello
> I can't create innoDB tables in db MySQL to do
> rollback and commit
> transactions.
> I try to modify the my.cnf file with the instructions
> that I find in manuel.pdf but it don't work.
> Can you help me please ?
> Thanks.
>
> Ps : i'm french. :-)
>
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: What does this message mean

[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
>Ariste Software
>2200 D Street Extension
>Petaluma, CA 94952
>707-773-4523
>[EMAIL PROTECTED]
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: newbie help

[Ryan Hatch]

Sorry for the confusion.  I have not checked www.MySQL.org in such a 
long time.

I was referring to the period of time when NuSphere (Progress) had owned 
MySQL.org and appeared to be falsely representing themselves as the 
MySQL developers.

I'm sure you now know what I intended.

Regards,

-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
>
> # nslookup mysql.com
> Name:mysql.com
> Address:  64.28.67.70



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: newbie help

[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 from a text file.
>
>I have only 9 coloums , most varchar, one char, one smallint (autoincrement)
>
>when i load the data (tab de-limeted) it goes fine but i get one Warning.
>
>
>I found on mysql.org that i need to INTO OUTFILE and look for errors,...but i 
>dont see any? 
>None of the coloums are overunning, all data types seem correct...
>
>What else could be going on? 
>
>could i just ignore the warning?
>
>
>thank you
>
>bd
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Help! Deciding on Java/C++ ?

[Ryan Hatch]

Hi all...

I'm about to start heavy development of an application with MySQL at the
backend.  However, I need some help
deciding on what language to approach the project from.

What are the ACTUAL speed comparisons - JDBC vs MySQL++  ??  How is the
speed of ODBC (Win vs Linux?)?

Are there any existing base classes representing MySQL's Server /
Database / Table / Field / Tuple?   I need a solid
object-oriented MySQL programming foundation before I start hacking at
the project.   I would rather not reinvent the
wheel if such classes already exist.

I would really appreciate any 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 thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php