Shouldn't you have on line 7
print (OK 2 );
and not
print (OK 2 )
Im not a PHP person but thats what I noticed in your code. And if ;
terminates a command that can't be helping
magic words sql database
-Original Message-
From: MTF [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16,
I'm not for sure but when you create a user you can allow that user to only
connect from specific locations. Such as localhost or from anywhere or even
a specfied locationm 123.222.111.2. Not sure if this will help at all??
Good Luck.
-Original Message-
From: stephane parenton
Try this program. Go to http://www.artronic.hr/mysql/index.htm and get
mysqladmin. Its a windows client to manage mysql databases. You then can
put in the ip address of the computer you want to connect to that is running
a mysql database. So you would put your win2000 server ip. Then put in a
I'm not a database god, but why would you want to store binary data in a
varchar feild when there are feilds of type binary to do store that type of
data? How can binary be upper or lower case?
-Original Message-
From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]]
Sent:
Without knowing more detail about the data and the requirements of that data
its hard to say how the database structure should be. To say I am right
over you and you are right over me is pointless. Its very dependant on the
data. I agree you can have a entity with 75+ attributes and its not
Can you compile a win32 version of this? Or will there be a binary for
win32 soon?
Thanks
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 4:51 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: MySQL 3.23.38
Sorry its early for me and I didnt read the bottom of this email. Sorry:)
-Original Message-
From: Robert Henkel [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 8:40 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: MySQL 3.23.38
With relational database design you can more then likely break that 75
column table down into many different tables. Look up information on NORMAL
FORM this will help you design an effective database. Usually from what I
know and have been taught 3rd normal form is as low a level as you want
Have you noticed a significant speed decline using Gemini tables?
RH
-Original Message-
From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 11:31 AM
To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED]
Subject: RE: InnoDB, BDB, and Gemini
Goodday to you
Well with tables not normalized you will more then likely at some point in
get redundant data at some point. For instance I enter Joe smith with phone
of 123-123-1222 then Joe Smith buys a new home keeps the other home and now
has two active phone number with on table you would have to reenter
PREVIOS THREAD ON THIS TOPIC: Hope it helps
Hi,
Make sure that MySQL on your OS supports 5000 connections !
Check OS specific restrictions in MySQL documentation.
Regards
--
Joseph Bueno
NetClub/Trader.com
John Barton wrote:
Try putting a line like the following in your my.cnf file:
This
Well normally its not the best to add columns after the fact if the design
met the specs. But this is not always the case. As we all now the specs
change about every hour.
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:49 PM
To:
I take that back the word not the best shouldnt be used. I should of said
in a perfect world we shouldnt have to add columns.
-Original Message-
From: Robert Henkel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:56 PM
To: 'Joshua J. Kugler'; [EMAIL PROTECTED]
Subject: RE
When you say you moved the data base I'm assumeing you are meaning you
reinstalled MySQL then moved the db files over to the new install? Each
data base goes into its own directory. So the database files for the
database named thedb would be in a subdirectory called thedb of the
directory data
So those of us not in the world of HA, mission critical would be equivalent?
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:20 PM
To: Billy Passauer
Cc: carlos ospina; [EMAIL PROTECTED]
Subject: Re: MySQL HA
On Wed, May 09, 2001 at
15 matches
Mail list logo