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
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. T
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
on 2/28/01 4:18 PM, Kinney Baughman at [EMAIL PROTECTED] wrote:
> Hi,
>
> I'm trying to encrypt credit_card numbers in MySQL 3.23.33. I want to
> decrypt them when I retrieve them.
>
> I've tried:
>
> mysql> insert into payment (payname1,ccaccount) values
> ("Kinney",encode(''
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 documente
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 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 who
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 i
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 (addr) select distinct addr from
You would p
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.
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 bui
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 r
I am new here...
I am in the process of migrating a site built with FileMaker Pro to MySQL
and PHP mostly because filemaker's web capabilities are too limiting. In one
situation, we have a database of about 20,000 rows that contains two text
columns. One is the full text of a resume and the other
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
thi
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
Ok, I have decided to try to get 3.23.32 built but I have a problem. I'm
building on Mac OS X Public Beta (Darwin) and the docs say it should
recognize this platform and work easily. It does configure, build and
install without a hitch, but it won't run.
I'm configuring it to install in /usr/loca
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 ch
18 matches
Mail list logo
