on 3/20/01 1:20 PM, Bryan Coon at [EMAIL PROTECTED] wrote:
Sorry for the ambiguity, I was trying to make a really generic select
statement. I just meant that if 'where a = A.a' has no matches, but 'where
b = B.b' or 'where c = C.c' does match, the query returns what did match,
and just
I installed 3.23.27 for Mac OS X from the binaries.
When installing PHP, I ran into problems with duplicate symbol names between
libmysqlclient.a and System.framework. I also got a similar error building
DBD::mysql. In both cases, the duplicate symbols were strto* functions.
I built PHP with
on 3/13/01 12:41 AM, Gilles Dumangin at [EMAIL PROTECTED] wrote:
I would like to extract the contents of a database to use it in a ASCII
format. It is a addresses database and I want to use it in Excel. I have
tried Mysqldump but it gives me the CREATE and INSERT statements all the
time.
on 3/8/01 3:40 PM, Scott Wang at [EMAIL PROTECTED] wrote:
select distinct addr from tablename outfile filename.txt
But how can I write the data to another table or even
replace the information in the table with the output info?
insert into another table (addr) select distinct addr from
on 3/6/01 9:35 PM, Chris Toth at [EMAIL PROTECTED] wrote:
Ok, I've been battling this SELECT statement for the better part of the day.
The SELECT statement is this:
SELECT DISTINCT request.id AS requestid, request.date, request.type,
request.status,
faculty.f_name, faculty.l_name,
on 3/7/01 6:39 PM, Cindy at [EMAIL PROTECTED] wrote:
How would I copy ONE table from a database over to another?
I used this last time:
mysqldump -h mysql.io.com -u DB1 -p --opt DB1 ! backup-file.sql
mysql -h mysql.io.com -u DB2 -p DB2 backup-file.sql
But it copies the whole
on 3/8/01 12:13 AM, Jennifer at [EMAIL PROTECTED] wrote:
I'm trying to do a SELECT * INTO OUTFILE and I get an error saying that it
can't create the file and Errcode 2. I've tried searching the archives,
but for some reason it keeps crashing my browser.
On my system (Mac OS X) errcode 2 in
on 3/5/01 12:28 AM, Cho Bum Rae at [EMAIL PROTECTED] wrote:
Do you know how to import TXT file into mysql DB?
Because of big size txt file, I cannot input data into DB manually.
Is there easy way to solve that problem?
Cho:
Look at mysqlimport, which comes with mysql. It is well documented
on 3/3/01 4:54 PM, Jonathan Dugan at [EMAIL PROTECTED] wrote:
and I follow what is says:
shell mysql -u root mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
It sounds like you've _already_ set a root password, so you need to specify
it:
mysql -u root -p
on 2/26/01 8:07 AM, Rolf Hopkins at [EMAIL PROTECTED] wrote:
Actually, at the file system level, yes, you're right. But database level
security, not necessarily. Check you have the right permissions for a start
At least in my case, the drop _almost_ succeeds. The table files are
deleted.
on 2/26/01 2:59 PM, G. Adam Stanislav at [EMAIL PROTECTED] wrote:
At 09:11 26-02-2001 -0700, Geoff Coffey wrote:
Errno 21 on my system is EISDIR -- 'is a directory', which doesn't seem to
be an error at all...
It is an error (that is why it starts with an 'E'). Appendix C of
POSIX
I just installed mysql 3.23 and then ran a script to create a database I had
previously been using in an older version. I have a couple questions.
First, how can I make a drop database statement not fail if the database
doesn't exist. A book I was using seemed to say:
drop database dbname if
Has anybody successfully built 3.23 on Mac OS X Public Beta? Does anybody
know if the version it supposedly builds under is a later beta? I still
can't seem to get it to work properly.
Thanks,
Geoff
-
Before posting, please
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote:
Making search engines is not a trivial thing, but this may be an
aproach...
I appreciate all the replies. In my original post I also asked about the
FULL TEXT index type. If I may ask again, has anyone had any experience with
on 2/1/01 4:05 PM, Sander Pilon at [EMAIL PROTECTED] wrote:
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote:
Making search engines is not a trivial thing, but this may be an
aproach...
I appreciate all the replies. In my original post I also asked about the
FULL TEXT
15 matches
Mail list logo