RE: Facing some problem in installation

If you are NOT installing as root, you are trying to create mysql.sock in an area where you don't have write permission. what is the --prefix you supplied to ./configure ? -Original Message- From: Manisha [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:18 PM To: [EMAIL

RE: Performance Problem - LEFT JOIN

Try SELECT tableA.* FROM tableA WHERE NOT EXISTS (select * from tableA, tableB, tableC where tableA.id tableB.idA and tableA.id tableC.idA) -Original Message- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 2:46 PM To: Guilherme Cc: [EMAIL

RE: SQL Syntax (May be OT)

Use LIKE '%KEYWORD%' At least this works for Oracle -Original Message- From: David Durham [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 3:39 PM To: [EMAIL PROTECTED] Subject: SQL Syntax (May be OT) If this question is off topic, please let me know. I have a description

RE: usage of mysql command

download mysql module of perl from cpan.org. Barnali -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:08 PM To: [EMAIL PROTECTED] Subject: usage of mysql command Hello all, How to use mysql command in perl script? I want to lock the db

RE: usage of mysql command

the write lock before the read lock. Lock one table at a time until the thread gets all locks. For READ ONLY, use LOCK TABLES table name WRITE Barnali Persistent Systems Pune, India -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:50 PM

RE: help !

Please let me know the entries of host and user table of 'mysql' database. You need to provide the access to remote machine through these tables. -Original Message- From: Brett Whittaker [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 9:05 PM To: MySQL Cc: Brett Whittaker Subject:

RE: OpenBSD source build, server client not talking

Is there any reason you are opting for static linking ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 11:11 AM To: [EMAIL PROTECTED] Subject: OpenBSD source build, server client not talking Description: I have just built MySQL on an

RE: Performance / Stresstest of MySQL

with mysql source) benchmark. Hope this helps Barnali -Original Message- From: Lasse Laursen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 1:24 PM To: [EMAIL PROTECTED] Subject: Performance / Stresstest of MySQL Hi, We are doing some optimization of our MySQL databases (tweaking

RE: Question about datadir redirection for MYSQL

Just check if you have the write permission on the mapped drive. Barnali -Original Message- From: Ashley Chew [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Question about datadir redirection for MYSQL Hi I

RE: Create DataBase tabe for a user

You have to create the database (poll) before doing any operation on it. Use ~mysql/scripts/mysql_install_db.sh to create a database. There may be an SQL command also to create the database - just check the mysql command reference. Regards Barnali -Original Message- From: [EMAIL