RE: RE: load data infile question

-Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 6:55 AM To: [EMAIL PROTECTED] Subject: re: RE: load data infile question Hi! >On Tuesday 25 March 2003 19:54, Salada Duncan wrote: > >> I was able to work around the probl

RE: load data infile question

3 9:06 AM To: [EMAIL PROTECTED] Subject: re: load data infile question Hi! On Friday 21 March 2003 20:41, Salada Duncan wrote: >> I am using MySQL 3.23.49 and have started having a problem with the "load >> data infile" command. >> >> I recently created a new user w

RE: load data infile question

-Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 9:06 AM To: [EMAIL PROTECTED] Subject: re: load data infile question Hi! On Friday 21 March 2003 20:41, Salada Duncan wrote: >> I am using MySQL 3.23.49 and have started ha

load data infile question

Hi everyone, I am using MySQL 3.23.49 and have started having a problem with the "load data infile" command. I recently created a new user with select,insert,update,and delete on one table only (tableA). Because I want the user to be able to use "load data infile" to load records into tableA, I

Can it be true?

Is it possible? Can it really be true? I check the website daily and watch the lists eagerly. As I looked at the website just now, I saw it... Database Server Production: 4.0.12 Did I miss the announcement? Is the website jumping the gun? Or am I the first to find out? ;-) oh, please let it

RE: multiple simultaneous DBI connections?

Perhaps I'm missing something, but couldn't you essentially have it both ways. What about allowing your method that initiates the object optionally accept a reference to a DBI object? If a DBI object reference is passed, your object will use that. If one isn't passed, have it open a new connecti

RE: Warning suppression?

This warning is being generated by PHP not by MySQL. Take a look at http://www.php.net/manual/en/faq.databases.php#faq.databases.mysqlresource If you haven't changed anything in your code, you might be using a function in your query that was made obsolete in the new version of MySQL. Check your

RE: fulltext indexes

Maybe this could help? Try changing the name of the index on the second table you 've created Thanks for the idea, but I think I've discovered the problem. Perhaps I chose my search phrase a little TOO well. It seems the problem occurs because of the 50% restriction for fulltext searching. Fr

fulltext indexes

I having some strange things occur with doing fulltext searches. I'm not exactly sure how to tackle this problem, so I figured I would send it out and see if anyone has any ideas or has seen this before. Background: I have been investigating the use of MySQL to do fulltext searches on emails. Th

RE: MySQL 4.0.11 is released

This is a new beta development release, adding new features and fixing recently discovered bugs. Has the release gone backward to beta? Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: Lenz Grimm

Finding functions in manual (was RE: formatting query output)

uncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 9:45 AM To: mysql users Cc: Salada, Duncan; 'Rob' Subject: Re: formatti

RE: formatting query output

Why 2 CONCATs? Why not simply: mysql -Be "select CONCAT(host,'.',domain) from easyadmin.vsites where adminuser="davidtg" Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: Rob [mailto:[EMAIL PROTECT

RE: mysql privs table level security

It seems like you are getting privileges systems mixed up. The MySQL server has its own privileges system that is separate (sort of) from the filesystem privileges system. All queries within MySQL will be handled by the MySQL server privilege system. Within that system, you are able to control a

RE: problems creating fulltext index

Thanks for the tip about the 14 columns, Sergei and Dan. I reduced the number of columns by two and the index seemed to build just fine. I would like to make a suggestion though. I originally tried to create the fulltext index with more than 16 columns and received an error saying that I could h

RE: problems creating fulltext index

Hi! > -Original Message- > From: Erlend Hopsø Strømsvik [mailto:[EMAIL PROTECTED]] > > > -Original Message- > > From: Salada, Duncan [mailto:[EMAIL PROTECTED]] > > > > > > Hello everyone, > > > > I'm running Ver 8.39

problems creating fulltext index

Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point

RE: Perl DBI or C++ API Help!

For Perl... Take a look at the data_sources DBI class method http://search.cpan.org/author/TIMB/DBI-1.32/DBI.pm#DBI_Class_Methods or the ListDBs MetaData Method for DBD::mysql http://search.cpan.org/author/JWIED/DBD-mysql-2.1020/lib/DBD/mysql.pod#Priva te_MetaData_Methods Duncan

RE: Error in SELECT

I see two problems. 1. You seem to be missing a left parentheses (, or you could just get rid of the right paren. 2. You need to change "CurrentlyEmployed= AND". The lack of a value will cause problems. Duncan --- Duncan Salada Titan Systems Corpora

RE: publishing mysql database to cd-rom

I saw something mentioned here once about a product called Microweb. I have never used it nor do I know anyone that has used it. For what it's worth, I think the website is here http://www.indigostar.com/microweb.htm. Duncan --- Duncan Salada Titan Sy

RE: Logging In Errors

Stop mysqld and start it again using the --skip-grant-tables command line option. -- FROM THE MANUAL AT http://www.mysql.com/doc/en/Command-line_options.html This option causes the server not to use the privil

RE: data-type help with NULL entries

>>1) What is a syntax example for inserting a NULL into a column? insert into projects set costing=NULL >>2) If a NULL is inserted into a column with a float type, does that NULL show up as anything else other than NULL? Like my 0.00 for example. Is that actually mysql's way of showing a NULL f

RE: Store pictures in DB

You can store pictures in a BLOB field, but it is generally recommended that you simply store the filename of the picture. -Original Message- From: Roland Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:35 AM To: [EMAIL PROTECTED] Subject: Store pictures in DB Can I

RE: subquery syntax

Try this: SELECT Contacts.FirstName, Contacts.LastName FROM Users,Contacts WHERE Contacts.ContactId = Users.ContactId AND Users.UserName = 'Doug' AND Users.UserPassword = 'Crock'); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:56

RE: timestamp primary key's value improperly changing on sql update

The is the proper, documented functionality of the timestamp field. An exerpt from http://www.mysql.com/doc/D/A/DATETIME.html is below: The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multipl

Verizon.net auto-reply

Is anyone else getting auto-replies from [EMAIL PROTECTED] when they post to the list? Duncan [p.s. SQL just for the nice filter] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

finding values in TableA not in TableB

I'm sure this question has been asked before, but I received an error while attempting to search the list archives - so I apologize for redunancy. I have two tables, events and events_terms, that have a common key, events_ID. Now I want to find the rows in events_terms that have an events_ID t

RE: using currentdate in queries

You'll probably want to use SUBDATE instead. http://www.mysql.com/doc/D/a/Date_and_time_functions.html Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Jeff O'Neal [mailto:[EMAIL P

RE: Not Liked!

Shouldn't the NOT be right before the LIKE: SELECT * FROM books WHERE title LIKE '%php%' AND title NOT LIKE '%perl%' Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Jonathan Davi

RE: Update

For one of two reasons (probably) - and I think you found a bug: 1. The syntax in your "set" clause is wrong. It should be "set alternatepreference='C',AltContactID='1'" *Notice the use of a comma instead of "and"* 2. The row that matched the conditions in the "where" clause may already be s

RE: Strange query issues

Are the first three machines closing their connections correctly? Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Gabriel [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002

RE: help with index/query

> -Original Message- > From: Gerald Clark [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 11:11 AM > To: Salada, Duncan > Cc: '[EMAIL PROTECTED]' > Subject: Re: help with index/query > > > what about > select Url from table where Ref = &#x

help with index/query

I am hoping I can get some help with a difficulty I am having with a table of mine. I am going to give a lot of background info, so please bear with me. First, let me say that I using 3.23.49. Now some info about the table. It currently has 5687391 rows. There are 3 columns in the table: ID (i

RE: Benchmark

http://www.mysql.com/doc/M/y/MySQL_Benchmarks.html Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Kathy Reyes [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 19, 2002 1:51 PM >

RE: Getting a text field in a table....

I don't believe you specify a size for a column of type TEXT. Only types CHAR and VARCHAR take a size. http://www.mysql.com/doc/B/L/BLOB.html says: "A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB differ only in

RE: site search

I'm with you on that. Many times we preach against "reinventing the wheel", but sometimes doing that can help you learn an awful lot about "the wheel". I also find that some of my best learning comes from taking on a hard project and just trying to make my own solution to it. Anyway... You migh

RE: source install problem - solaris2.6

uncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Salada, Duncan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 06, 2002 8:14 AM > To: '[EMAIL PROTECTED]' >

source install problem - solaris2.6

Hello all, I am having some problems with installing 3.23.49 from source. Below is the output from mysqlbug with my additions to help explain the problem. Any help would be great - my experience with this kind of stuff is not that great. >Description: I am trying to upgrade from 3.20.3

RE: Access denied for user: (from perl script)

Are you using the latest version of DBI? Also, your "if ($dbh) {" seems a little backward. According to the DBI docs, "If the connect fails (see below) it returns undef and sets $DBI::err and $DBI::errstr." So shouldn't your conditional be "if (!$dbh) {". Perhaps you are actually connecting. I'

RE: How to rewrite this statement.

http://www.mysql.com/doc/J/O/JOIN.html says that "INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition." So you could use this instead: SELECT FORUMCAT1.LASTPOST, USERS.USER