I am new to both PHP and MySQL (I have experience in ASP) and am trying
to get my server running both. I can connect to the MySQL server under
DOS using the command line and can create new databases this way. I want
to create a web data site so I need to accomplish this via HTML. I have
tried to
hi,
i'm having the following problem that sort of makes my life miserable :-)
i've been working on a search script that could take a query like this:
(car and bus) or apple not (orange and table)etc.
...basicly any logical statement...and return the right references based on
searching
Hi list,
I have a question that hopefully someone can help me with.
We have a mysql database which contains 3000 records, and these records need
to be searched.
The table has 4 fields which need to be searched, so we created a full text
index for the 4 fields. Now 1 of the fields contains
OK quick question, Is there a limit to the amount of data the can
be defined
when I create a field as a set.
64. RTFM.
I am looking to have about 39
words in there
at the moment I have them in another table and have an index pointing to
them, but would like to move them to a set. if
At 4:50 PM +1000 9/15/01, mike wrote:
I am new to both PHP and MySQL (I have experience in ASP) and am trying
to get my server running both. I can connect to the MySQL server under
DOS using the command line and can create new databases this way. I want
to create a web data site so I need to
Now that I have the correct Install procedure for the Perl DBI and MySQL
DBD,
Where is the most common and preferred Location for the Install??
I was considering the following.
/usr/local/
/usr/local/share/
/usr/share/mysql
/usr/share/perl5/
Sometimes a script or program
Subject:
intro mysql book
Date: Fri, 14 Sep 2001 14:18:29 -0700 (PDT)
From: another oracle dba [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Can someone recommend an intro MySQL book. I'm looking for a
book with info on MySQL
I think your confusion stems from the fact that
a AND b NOT c
is not a valid boolean expression. You probably
mean to say
a AND b AND NOT c
Lezz Giles
- Original Message -
From: "Libor Maty" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 15, 2001 5:25 AM
Other than the manual, Sam's Teach Yourself MySQL in 21 Days is a great
book.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: rjtalbo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 15, 2001 3:24 PM
Subject: intro mysql book
Subject:
i use the paradox and i want move my apps to mysql, but how?
Regards
otro correo: [EMAIL PROTECTED]
---
Runbox Mail Manager - www.runbox.com
Free online email application
-
Before
Bob,
As soon as you compiled and installed perl itself, the Config
module of perl will tell any Makefile.PL driven package where to
install itself: under the directory structure of perl.
I don't know for sure, but I suppose DBI DBD installs via
Makefile.pl script... If not, do a perl -V to see
The www.mysql.com/Contrib/Examples Webpages doesn't exit anymore,
please tell me where I can get samp_db, or another sample for me
learn mySQL.
--
Best regards
Jack Su
-
Before posting, please check:
At 1:54 PM -0700 9/15/01, Jack Y. Su wrote:
The www.mysql.com/Contrib/Examples Webpages doesn't exit anymore,
please tell me where I can get samp_db, or another sample for me
learn mySQL.
It's available at:
http://www.kitebird.com/mysql-book/
--
Best regards
Jack Su
--
Paul DuBois,
I've found the answer to my problem in the bdb source...
From bdb/include/db.src:
#defineDB_LOCK_DEADLOCK(-30996)/* Deadlock. */
So the question is: how can a bunch of simultaneous connections that only
work on 1 table create a deadlock. And how can I write my code to avoid this
Hi list,
Can anyone recommend an ERD modeler for MySQL?
I've tested the evaluation version of Dezign for databases and while I
like it and was able to generate an initial schema with it, I couldn't get
it to create SQL to alter the schema after I had modified the initial ERD.
(I was only able
I can totally understand that, but the problem is, my queries are only
interested in one row each ( accessed by primary key ). Perhaps it has to do
with the extra unique index?
The flow is this:
insert row.
grab newly created primary key ( autoincrement ) + generate a unique 32 byte
char string
As I said, I don't know anything about BDB, but I don't see how they could
possibly prevent chaos without locking both all table pages and all index
pages that are being modified by a transaction. And indeed, that would make
a deadlock possible for multi-phase updates on the same row and thereby
Paradox should allow you to export your data in some sort of flat file
format, such as comma separated values (CSV). If so, you can use the MySQL
mysqlimport program or the MySQL load data infile 'filename' into
table... statement to load the flat files into your MySQL database.
- Original
Hello All!
Can someone recommend an intro MySQL book. I'm looking for a
book with info on MySQL
Yes, as others have said, the Paul Dubois book is -excellent.-
Teach Yourself MySQL in 21 Days ...SAMS..by Maslakowski.. (Takes you
from Ignorant to Working Project).
Avoid it like the PLAGUE.
MYSQL
I have a table with a date field. I have a query that needs to output
only if NOW()ed3(date field) ed2 is datetime.
The issue is this:
select * from thesites where ED3NOW()
ED3='1999-12-31 00:00:00'
the above query will output when ED3 is as above. NOW()='2001-09-15
18:10:44'
???
At 8:22 PM -0700 9/15/01, Carl Schrader wrote:
MYSQL
I have a table with a date field. I have a query that needs to output
only if NOW()ed3(date field) ed2 is datetime.
ed3? ed2?
The issue is this:
select * from thesites where ED3NOW()
ED3='1999-12-31 00:00:00'
the above query will output
hello.
My server uses SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250,
and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build
with the support of mysql.
The mysql server has several databases that are used by several virtual hosts.
I
On Sat, Sep 15, 2001 at 01:12:31AM -0500, Ed Carp wrote:
In http://slashdot.org/article.pl?sid=01/09/13/154222mode=thread, it is
written:
- Writing and reading to the same innodb MySQL tables can be done since it
does row-level locking. But as load increases, it can start being less than
On Wed, Sep 12, 2001 at 07:55:05PM +0200, Sander Pilon wrote:
Dear List,
I need to store a set of flags in SQL, as in 20 true or false
values. The logical choice seems to be the SET type, but does it
use an index?
I don't think so... It is implemented as a bitmask behind the scenes.
It
On Wed, Sep 12, 2001 at 03:18:37PM +0200, Marcin Pyla wrote:
Hello,
How I can make my mysql faster ? Can I compile it with special
options ?
(1) good database design
(2) properly indexed tables
(3) write fast queries
(4) tune the mysql server
(5) add hardware if still necessary
Here's an
hello.
My server uses SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250,
and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build
with the support of mysql.
The mysql server has several databases that are used by several virtual hosts.
I
26 matches
Mail list logo
