what affects the rows in the host table of database mysql? is it when a
particular host logs in the server's mysql console? or is it when a user
browses a web file that launches a script to access a database? or both?
thanks
jembo
You never considered reading the manual, eh?
Look up types in the manual - check out TEXT type
-Jason Garber
IonZoft.com
At 08:12 AM 10/18/2001 -0500, Purcell, Scott wrote:
Hello,
I am working on a school project and I want to use mysql db, as a back end.
Anyway, I want to make a column
Neil,
Please indicate what you mean by converting the string x to a percent
value???
-Jason Garber
www.deltacron.com
At 08:51 AM 9/21/2001 +1000, Neil Silvester wrote:
Another PHP problem has kept me up all night, scouring through my database
books and trying everything I could think of. I
I thought this may be helpful to anyone that is having this problem.
I tried to back up my database using mysqldump:
[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata |
gzip /home/pad/dbbackup/20010908a.gz
Enter password:
# Connecting to localhost...
# Retrieving table
Regarding error 127 from table handler...
I thought this may be helpful to anyone that is having this problem:
I tried to back up my database using mysqldump:
[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata |
gzip /home/pad/dbbackup/20010908a.gz
Enter password:
#
First, Try this:
NOT EQUAL is != rather than
$query =
SELECT * FROM question WHERE answer != '1' AND id250 ORDER BY id DESC;
$result =
mysql_query($query) or die('MySQL Query Failed. Error '.mysql_errno().':
'.mysql_error());
$number = mysql_num_rows($result);
-Jason Garber
Lead
Jeremy,
Do you stay up all night also, reading and responding to the MySQL mailing
list? :)
Thanks for the answer on your MySQL setup. I had mistakenly taken 15
connections to be 15 queries. However, I am impressed with the preformance
of MySQL. Do you have any data on how many
, you wrote:
On Thu, Aug 23, 2001 at 04:32:57AM -0400, Jason G. wrote:
NOT EQUAL is != rather than
Really? I've used them both with good success. Where does one
succeed and the other fail?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax
Another tip that I have used ALOT...
When a query fails, go to the command line and try executing it and
variations of it there to find the problem.
-Jason Garber
At 10:48 AM 8/23/2001 +0200, you wrote:
This is the error I get: MySQL Query Failed. Error 1030: Got error -1 from
table
If I am not mistaken...
You could write a script that uses PHP to look at the database, create a
file, and download it to the browser over an HTTPS connection (128 bit
ssl). You would need some sound security protecting access to the download
page. You could use the same script to accept a
I am not sure about the primary key.
You can create a UNIQUE index on (field1, field2, field3, field4)...
(I have done this)
This will prevent any duplicate rows from being inserted.
Hope it Helps,
-Jason Garber
Lead Programmer - pulseaday.com
At 08:07 AM 8/23/2001 -0400, you wrote:
Hi
Is
11 matches
Mail list logo