mysql with java

Hi, Is there any examples on developing a java interface with mysql? Thanks, Denny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Perl DBI

Hi, How can i use Perl DBI to create tables in mysql? Denny __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yaho

Error in installing mysql

Hi, I am new to linux and i currently trying to install mysql on my redhat 7.1. I always got this error message at the end of the make "Internal error: Segmentation fault.". I wonder if anyone would tell me what's going on? My machine is running on cyrix P133 with 32MB ram.

Simple GROUP / ORDER problem

Hello, If got a simple sessions table basically holds a session id and datetime field for last modification also a session type, so I can have several records with the same session id, with different types and different modification time. I want to get the latest modified record for any given sess

BOOLEAN Vs NON-Boolean

Hello, I've just upgraded to 4.1 for boolean search facilities, but I think I may lose more than I 've gained. I just really need the "+keyword1 keyword2" functionality so all results must contain keyword1, but I then need to order by relevance score which I've lost. Is it worth performing two n

MAX select problem

Hello, I'm trying to get the date and amount of the most visits to my site over a given time period using : SELECT max(visits) as maximum FROM visit WHERE (((visit_date >= '$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id)) This gives me the right figure, but when I try to

Duplication of records within the same table.

Hello, I've got a table with a simple structure: site_id, page_id,header_text,main_text.. I just need to duplicate existing records with a new site_id, so : 1,1,Hello,some text.. 1,2,Hello Again, some more text... gets copied to 2,3,Hello,some text.. 2,4,Hello Again, some more text... page_i

Character Set Problem

Hello, this is probably quite simple but I've got a text file that has non-english characters, when I view it I see : 'Découvrez un réseau européen d'hôtels et de restaurants beignant dans une atmosphère conviviale et familliale' I've imported this straight into my myisam DB which is set up

Re: Character Set Problem

Is it possible to change the character set just for an individual table and if so which character set should I try to display this european characters? Cheers, Lee - Original Message - From: "Sumito_Oda" <[EMAIL PROTECTED]> To: "Lee Denny" <[EMAIL PROTECTED

Fulltext search Strategy - Need Help

Hello, I'm doing fairly straight forward fulltext searches, but I want to nest them - basically do a keyword search on 'phrase 1' and then search the results this returns for 'phrase 2', for example if phrase 1 is 'ford' and phrase 2 is 'focus' - I search once for 'ford' and then go through the re

Tricky Date Query

Hello, I need to perform a select that compares two dates I need to return all records that haven't had date_2 set after a given number of days since date_1. I'm sure this can be done in one query but I just can't get my head around this one. Can anyone help? Cheers, Lee -- MySQL General M

Database Design and Bianry Operations

is a more efficient method using binary operations (only one field populated with zeros and ones) but I can't find anything to help in the manuals. Any thoughts? Lee Denny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Notifying User when DB is Updated via browser

atest applications. Is there any way of using some sort client-server technology to alert the user, via the browser that a new entry has appeared in the DB - I'm already sending an email but this is still not the best solution. Thanks in advance, Lee Denny -- MySQL General Mailing Lis

Migration to MySQL from flatfiles

d I need to consolidate to a single auth source Can anyone point me in the right direction? Denny Snyder Network Engineer Susquehanna Communications 1050 E. King St York, PA 17403 Office: (717)771-2613 Fax:(717)843-5400 [EMAIL PROTECTED] [EMAIL PROTECTED] "Nothing in life is worse t

Quick REGEXP problem

Hello, Can any one tell me why $sql="SELECT * FROM table WHERE pcsort REGEXP '^".$parts[0]."[0-9]'"; (pcscot being a CHAR(10), $parts[0] being a single alpha charcater.) works OK in 3.23 but not in 3.22. I'm trying to find UK postcodes such as e17 but not ee17. All the best, Lee --

Speed problem with sorted select statements

NULL | 3418459 | where used; Using index; Using temporary; Using filesort | +---+---+-+--+-+ --+-+--+ 1 row in set (0.00 sec) Fix: Synopsis: Speed problem with sorted select statements Sub

JDBC problems

I'm trying to use the mm.mysql JDBC drivers on windows NT I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted it into my jdk1.2.2/jre/lib/ext folder. I try to connect with import java.sql.*; public class dbconnect { public static void main(String[] args) { String ur