Errors stating Mysql server

I just reinstalled Slackware and now have the unenviable task of getting Mysql working. What a major pain in the ***. Anyway, here are the errors. I have read manuals, searched the web, as well as the newsgroups, and still can't get it to work. No matter what permissions I change, the errors are st

Mysql,In the next few minutes you may discover your future!

HelloMysql , How are things going for you? Are you happy? Really happy? Do you have to juggle your bills? Is your need for money weighing you down? Are you stuck in a job that doesnt’t pay you enough to cover your bil

Re: mysqld refuse to die

I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] +++

mysqld refuse to die

Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road,

Header files

I installed the mysql rpms off the mysql website for 3.23.52. That works great, but when I try to configure mysql with the --with-mysql directive, it compiles with the path to /var/lib/mysql/mysql.sock which is not the one pointed to by the my.cnf file, it should be /tmp/mysql.sock. What I am ask

Re: MySQL Crashes When a Remote Connection Is Made

On Fri, Nov 08, 2002 at 10:25:01PM -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> is thought to have said: > >Description: > MySQL crashes when a remote computer attempts to make a standard > connection. Making a local connection does not cause this problem, > connecting to other systems doe

Help sending to the lists

Hi, I'm being forced to use MS Outlook/MS Exchange to to all my email at work and I cant seem to send mail to the mysql list. The list managert doesn't allow attachments but for some reason Exchange or Outlook seem to insist on send out the email as plain text AND html as MIME attachments. Has a

MySQL giving Hard Drive a WORKOUT on close and then crashing?

VER: mysql-3.23.53-win.zip Description: If I launch MySQL 3.23.38, everything is fine. If I open tables, creat db, add records whatever, no problem. When I close MySQL my hard drive is ? alot and I can do nothing except a hard reboot. I have tried quitting immediatly after l

MySQL Crashes When a Remote Connection Is Made

>Description: MySQL crashes when a remote computer attempts to make a standard connection. Making a local connection does not cause this problem, connecting to other systems does not cause this problem, but a connection from a remote computer to mySQL immediately crashes mySQL. The deta

Keep getting "Lost connection to MySQL server during query" during initial connection

Hi!, I hope someone a little more knowledgeable in mySQL can help me with this... We just got a new box setup (standard mySQL install) called BoxA, every time we try to connect to mySQL from a remote location(BoxB) we get the "Lost connection to MySQL server during query" message. The command we'

relevancy ordering

Hi there, can anyone suggest how this query could have relevancy ordering put into it? SELECT DISTINCT images.* FROM images LEFT JOIN imagekeyword ON images.imageid=imagekeyword.imageid LEFT JOIN imageformat ON images.imageid=imageformat.imageid LEFT JOIN imagelocation ON images.imageid=imageloca

query crushes server

May be this was reported already. I have windows 2000 using mysql version 4.0.3-beta-nt When I ran a query like select distinct a.* from tasks a, gnrlasoc b; mysqld-nt.exe crashes. I know this query makes no sense but it should not crush server Eugene Bendersky -

mysql list question

This may be a (hmmmpf) dumb question or maybe the docs say, but I cannot find it. When posting this list regarding sql, query, and other info :) does the list server modify the posts to a maximum width? (For all using terminals to browse?) If so what is the line width? (80 characters?) I wanted

Re: Another Defining Relationships in MySQL Question

tmb wrote: In MS Access you define relationships between Key ID fields by dragging a line on the screen from the parent table to the child table. Read up on referential integrity and InnoDB tables in the online docs at http://www.mysql.com/doc/en -- Michael T. Babcock C.T.O., FibreSpeed Ltd

RE: MySQL Installation

-Mike >I know this is OT a bit, but now I need to either re-compile PHP to get >mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I >need to do this at all? Not sure where PHP came into the picture here. Let's not confuse phpMyAdmin with MySqladmin. Different animals all tog

RE: How to port MS Access to MySQL ??

Try http://mysqlfront.sstienemann.de/ and wait a few seconds for the download to start. MySQLFront has been discontinued by the author a couple months back. See if you can get a copy before it gets pulled off the net. It is very very good. :) It is free. Mike. At 04:59 PM 11/8/2002, you wrote:

Another Defining Relationships in MySQL Question

In MS Access you define relationships between Key ID fields by dragging a line on the screen from the parent table to the child table. So, if you are enforcing "referential integrity" you can not delete data that is referred to by another table or mess up the basic db structure... (think I have th

Re: How to port MS Access to MySQL ??

Petre, Where do I get MyOdbc ?? Does it run on linux? thanks - tmb --- Petre Agenbag <[EMAIL PROTECTED]> wrote: > myodbc works fairly OK for me. > > On Fri, 2002-11-08 at 14:17, tmb wrote: > > Is there a tool for doing a quick port from MS > Access > > to MySQL? > > > > Or must you manually cr

RE: How to port MS Access to MySQL ??

Alan, 1 - what is MySQLfront? 2 - where can I get it? 3 - does it run under Linux? 4 - is it open source &/or free? 5 - or does it come with MySQL ?? thanks - tmb --- Alan McDonald <[EMAIL PROTECTED]> wrote: > MySQLfront does it all > > > -Original Message- > > From: tmb [mailto:topmailb

Re: Replication and temp tables...

Jon, - Original Message - From: "Jon Frisby" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, November 09, 2002 12:17 AM Subject: RE: Replication and temp tables... > Hrm, upon further digging it seems that this may be the offending query

RE: MySQL Installation

I know this is OT a bit, but now I need to either re-compile PHP to get mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I need to do this at all? Even at rpmfind.net is seems hard to distinguish what it is I need. Is there anyway to get a 'complete' PHP rpm somewhere? Tha

RE: Copy Records in a table...

maybe it doesn't then in MySQL - it does elsewhere Alan > -Original Message- > From: David Felio [mailto:david@;ark.org] > Sent: Saturday, 9 November 2002 1:59 > To: MySQL List > Subject: Re: Copy Records in a table... > > > Is the implementation of this different than the docs say? Acc

RE: How to port MS Access to MySQL ??

MySQLfront does it all > -Original Message- > From: tmb [mailto:topmailbox@;yahoo.com] > Sent: Friday, 8 November 2002 23:18 > To: [EMAIL PROTECTED] > Subject: How to port MS Access to MySQL ?? > > > Is there a tool for doing a quick port from MS Access > to MySQL? > > Or must you manua

RE: Replication and temp tables...

Hrm, upon further digging it seems that this may be the offending query: # at 416149583 #021107 16:50:31 server id 1 log_pos 416149583 Intvar SET INSERT_ID=6437606; # at 416149611 #021107 16:50:31 server id 1 log_pos 416149583 Query thread_id=19890708 exec_time=0 error_code=0 SET TIMESTAMP=1036716

RE: MySQL Installation

Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the server package, but MySql.com has it in the client's: $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin /usr/bin/mysqladmin /usr/share/man/man1/mysqladmin.1.gz sql, query ~Kelly W. Black PS IN the future check out

Geting continuous errors from Table handler (Error 127)

Hi, I have a mysql installed ona RedHat 7.3 machine. The problem is that I am getting the error 127 many times. Each time I repair the table and after some time (1-2 hours) it happens again. Any comments? I am using the RPM shipped with Redhat 7.3. Bellow are the logs: Thanks in advance, Hamid

Re: multiple mysql query in PHP mysql_query?

At 13:30 -0800 11/8/02, Qunfeng Dong wrote: Hi, Can anybody give me a simple example of using PHP's mysql_query to perform mulitple mysql queries. I If you mean an example of a single call to mysql_query() that performs multiple queries, no one will be able to show you an example. It doesn't wo

Re: Question regarding nested select

At 11:25 -0800 11/8/02, [EMAIL PROTECTED] wrote: Hi, Does version 2.23.52 supports the use of nested select? There is no such version. I assume you mean 3.23.52? Queries such as you show below are not supported until 4.1. I want to write a query based on a group where I do a count of somet

Re: mysql 4.x for debian?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 06 November 2002 20:48, Jeremy Zawodny wrote: > Actually, you should work with the current mysql maintainer for > Debian. I'm sure he'd be thrilled to have official help from MySQL > AB. Of course I would not mind helping and assisting

multiple mysql query in PHP mysql_query?

Hi, Can anybody give me a simple example of using PHP's mysql_query to perform mulitple mysql queries. I am using MySQl 3.23, trying to use create temporary table and insert ... select to overcome the lack of union operation in that verion of MySQL. Thanks!Qunfeng Dong

RE: MysQL Installation

Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike > -Original Message- > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > Sent: Friday, November 08, 2002 2:17 PM > To: '[EMAIL PROTECTED]'; [EMAIL PRO

RV: Unixware 7.1.0

Hi : I have a server with SCO Unixware 7.1.0 , I like install a Mysql Version that includes Replication with other Mysql servers... Which version could i install for this ??? Tomás García - Before posting, please check: htt

sql test

This is a test to the sql list. I sent a message concerning MySQL+NFS problems and it didn't go through. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http://www.mysql.com/ma

NFS Problem

I have mysql installed and working on Solaris 9 using the binaries from the mysql site. I have an NFS server running under Debian GNU/Linux 3.0. I am able to mount NFS mounts on the Solaris box from the Linux box without any problems. I'm able to read/write without incident. Now here comes the pro

Re: Returning an Auto-Increment Field/Thanks

Thanks to all for the responses. Especially to those who pointed my to documentation. Regards -tim- * Cliff <[EMAIL PROTECTED]> [021108 08:32]: > You can use the function : mysql_insert_id() to get the value you've just added. > Please see http://www.mysql.com/doc/en/mysql_insert_id.html for more i

Question regarding nested select

Hi, Does version 2.23.52 supports the use of nested select? I want to write a query based on a group where I do a count of something for each group. In SQL Server 7 it would look something like this, select a.department ,(select count(*) from empdb where gender='m' and department=a.department)

Re: MysQL Installation

On Fri, 2002-11-08 at 14:12, SpyProductions Support Team wrote: > > I just installed the most recent version of MySQL with an RPM (through > webmin interface), but it doesn't seem to have installed a > mysqladmin.anyone know why? :) > > Thanks! > > -Mike > Probably you just installed the s

RE: MysQL Installation

Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support@;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed the most recent version of MySQL with an RPM (throug

MysQL Installation

I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - Before posting, please check: http://www

RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

Several things. Don't use root to connect remotely. Run mysqld as a userid on the server not root. You may need to grant on mysql database for more than localhost. Such as (Note this grants all privileges to all databases. See mysql docs for restricted access) GRANT * ON *.* TO 'userid' IDENT

Re: Error connecting to Mysql via Apache/PHP - Access Denied(Newbie)

On Fri, 2002-11-08 at 16:51, [EMAIL PROTECTED] wrote: > I am trying to connect to my Mysql DB via Apache and PHP, but I get the > following error: " Warning: MySQL Connection Failed: Access denied for > user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3 > Could not connect" C

mysql data base backup

Hi , Is there a easy way to back up the mysql data base via scheduler thanks Stanley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archiv

Re: Returning an Auto-Increment Field

Hi, select last_insert_id(); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Tim Johnson" <[EMAIL PROTECTED]> T

Re: Returning an Auto-Increment Field

I think that the mysql function LAST_INSERT_ID() is what you need. Tim Johnson wrote: Hello All: If I am adding a row to a table that has an auto-increment field, is there a way to query MySQL for the value of that field, once the new row is added? TIA -- --

Returning an Auto-Increment Field

Hello All: If I am adding a row to a table that has an auto-increment field, is there a way to query MySQL for the value of that field, once the new row is added? TIA -- Tim Johnson <[EMAIL PROTECTED]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com --

RE: accessing mysql from C

mysql_connect() is deprecated function. Try using mysql_real_connect(). I've used and haven't experience any problems with it. http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql _real_connect Sean -Original Message- From: Rahul Amaram-RollNo.286 [mailto:rah

Re: accessing mysql from C

Hi, Take a look in mysql.h. #ifdef USE_OLD_FUNCTIONS MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd); int STDCALL mysql_create_db(MYSQL *mysql, const char *DB); int STDCALL mysql_drop_db(MYSQL *mysql, const char *DB); #define mysql

Re: Load (messy) data file

At 9:39 -0600 11/8/02, Ray wrote: is there a way to have mysql skip columns from the data file when loading the data? No. You'll be better off preprocessing the file first (or use your temp file approach; that'll work, too). i am getting a text delimited data file from an outside source that

Re: accessing mysql from C

At 22:04 +0530 11/8/02, Rahul Amaram-RollNo.286 wrote: whenever i try to execute a C file which uses the mysql_connect method i get the following error. mysql_connect() is obsolete. Use mysql_real_connect() instead. undefined reference to mysql_connect Please note that I have tried th

RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

I tried this. The error I received is: error: 'Access denied for user: 'root@localhost' (Using password: NO)' Is there another option? |-+> | | "Dan Rossi" | | || | || |

Re: mysqld_multi

On Thu, 7 Nov 2002, Chris Raymer wrote: > Yes, that is what I meant. Thank you for the clarification and response. > Any ideas on maximizing *server* performance besides the usual db-specific > optimizations like indexing? If not too much trouble, could you give me a > brief explanation why I wo

accessing mysql from C

whenever i try to execute a C file which uses the mysql_connect method i get the following error. undefined reference to mysql_connect Please note that I have tried the following options. gcc -lmysqlclient file.c gcc -L /usr/lib/mysql -lmysqlclient file.c gcc -L /usr/lib/mysql -I /usr/incl

RE: privileges when moving from mysql 3.23 to 4.0

never mind it worked now , had to restart the server heh -Original Message- From: Dan Rossi [mailto:daniel@;electroteque.org] Sent: Saturday, November 09, 2002 3:25 AM To: Dan Rossi; [EMAIL PROTECTED] Subject: RE: privileges when moving from mysql 3.23 to 4.0 i used this mysql_fix_privil

MySQL - version to install?

I've got to do a fresh install of mysql on a webserver (a new server, so it isn't overwriting anything). Does anyone have any info as whether I should use just MySQL or MySQL-MAX? What is the difference? Thanks! :) -Mike -

RE: privileges when moving from mysql 3.23 to 4.0

i used this mysql_fix_privilege_tables hoping it would migrate about 100 user database privileges, but it doesnt seem to have done the job what else do i need to do ? as i said before i dont particularly want to have to reset and regrant everyones passwords. -Original Message- From: Dan Ro

Re: how do you define a relationship?

Hammons Randy G SSgt 612 ACOMS/SCXX wrote: Unfortunately this goes well beyond the scope of my original question. Although the inputs that you all have provided thus far have been a very good read, I still don't grasp the concept of defining a relationship. Is it simply referring to a primary ke

RE: mysql permissions

thank you victoria! -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: Friday, November 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: re: mysql permissions Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a user (

RE: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

mysqladmin -u root password setpassword ? and dont use root for normal access -Original Message- From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com] Sent: Saturday, November 09, 2002 2:51 AM To: [EMAIL PROTECTED] Subject: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

re: try again

Jalene, Friday, November 08, 2002, 1:29:53 AM, you wrote: JJ> I have a Redhat linux box which has MySQL 3.23.52 loaded on it. I have JJ> mysql front loaded on a windows xp box which I am trying to use to JJ> connect to the mysql server. The error I am getting when trying to make JJ> a connectio

re: DATETIME + days

Silmara, Thursday, November 07, 2002, 10:05:37 PM, you wrote: S> I executed the following statement: S> UPDATE Table1 S> SET date_adm=date_adm+2 S> where date_adm='2002-10-30'; S> the result was...-00-00 S> I´m working with Mysql-max-nt 3.23.39. S> What´s wrong? Use DATE and TIME function

re: mysql permissions

Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a user (besides root) that can show databases, Use Show_db_priv after 4.0.2, before 4.0.2 user can see all databases if mysqld is running without --skip-show-database option. SS> show tables SS> from every database, Us

Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)

Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: " Warning: MySQL Connection Failed: Access denied for user: 'root@jws-portald' (Using

2 way replication possible ?

I'm currently trying to figure out a solution for the following situation: A small event-management company will expand to a site in another town. The existing office runs a homemade MS-Access DB application that I want to migrate to a more viable database server like MySQL. The two sites will

RE: mysql permissions

grant all ? -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Saturday, November 09, 2002 1:46 AM To: '[EMAIL PROTECTED]' Subject: mysql permissions i need to create a user (besides root) that can show databases, show tables from every database, lock all

Load (messy) data file

is there a way to have mysql skip columns from the data file when loading the data? i am getting a text delimited data file from an outside source that is updated daily. however the data is defined as having 10 blank fields in it, and in the first 9000 records 7 more fields are just not used,

RE: Copy Records in a table...

This style of insert does not work in MySQL. The two table names must be different. -Original Message- From: Alan McDonald [mailto:alan@;meta.com.au] Sent: Thursday, November 07, 2002 9:56 PM To: Doug Coning; [EMAIL PROTECTED] Subject: RE: Copy Records in a table... insert into mytabl

RE: perl dbi and mysql question

yeah, but i was looking for a function. mostly just to see if a matching function to dbh->tables() existed. -Original Message- From: Grigor, Peter [mailto:pgrigor@;aseedge.com] Sent: Friday, November 08, 2002 10:07 AM To: 'Shon Stephens'; '[EMAIL PROTECTED]' Subject: RE: perl dbi and mysql

RE: perl dbi and mysql question

Of course, you could have also used: $stmt = $db->prepare("show databases"); Peter <^_^> -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:50 AM To: Shon Stephens; '[EMAIL PROTECTED]' Subject: RE: perl dbi and mysql question

Re: Copy Records in a table...

Is the implementation of this different than the docs say? According to the manual, I didn't think this would work: "* The target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query because it's forbidden in ANSI SQL to SELECT from the same table into

Re: perl dbi and mysql question

No clue of dbi/dbd but the query SHOW DATABASES does what it tells. STIBS - Original Message - From: "Shon Stephens" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 3:44 PM Subject: perl dbi and mysql question > i am using perl dbi with dbd::mysql. i know tha

RE: perl dbi and mysql question

eureka! i found it! @dbs = $dbh->func('_ListDBs'); -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:45 AM To: '[EMAIL PROTECTED]' Subject: perl dbi and mysql question i am using perl dbi with dbd::mysql. i know that using th

mysql permissions

i need to create a user (besides root) that can show databases, show tables from every database, lock all tables, and flush all tables. what permissions should i grant to this user? thanks, shon [don't bounce me as spam] mysql sql query ---

perl dbi and mysql question

i am using perl dbi with dbd::mysql. i know that using the dbi function, $dbh->tables (), will list all the tables in a database. is there a function that will show all the databases on a server? thanks, shon - Before posting, pl

Re: How to port MS Access to MySQL ??

Yep, ODBC works great. Make a connection from Access to MySQL and mirror the access db into MySQL. STIBS > myodbc works fairly OK for me. > > On Fri, 2002-11-08 at 14:17, tmb wrote: > > Is there a tool for doing a quick port from MS Access > > to MySQL? > > > > Or must you manually create all the

Re: DATETIME + days

20021030 + 2 = 20021032 That is not a valid date. You can't use regular math functions on dates. Check out the date and time functions in the manual. Silmara wrote: I executed the following statement: UPDATE Table1 SET date_adm=date_adm+2 where date_adm='2002-10-30'; the result was...-00-0

RE: True/False

According to http://www.mysql.com/doc/en/Column_types.html BIT & BOOL -- These are synonyms for TINYINT(1). DÆVID. > -Original Message- > From: Oluwagbamila Oyekanmi > > Use the data type BOOL which takes a 1 or 0 character or use > CHAR and then you can use Y or N for Yes/No. Or how

Re: True/False

Use enum. Rgds Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com - Original Message - From: "Tony Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 4:56 PM Subject: True/False > I am new to MySQL and I am attempting a new proje

Re: How to port MS Access to MySQL ??

Hi, Use DBTools DBManager. It import/converts from MSAccess, DBF (Dbase, CLipper, FoxPro), Paradox, ODBC e MSExcel into MySQL with just a few clicks. Of course it only works in Windows. http://www.dbtools.com.br []s Crercio O. Silva - Original Message - From: "tmb" <[EMAIL PROTECTED]>

Re: How to port MS Access to MySQL ??

myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: > Is there a tool for doing a quick port from MS Access > to MySQL? > > Or must you manually create all the tables & sql > statements in MySQL and then export the MS Access data > to a comma delimited file... then import it in

How to port MS Access to MySQL ??

Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables & sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb _

SELECT slow after adding INDEX on MERGE table

I have 3 identical tables with approx 150,000 row each. These tables have currently no indexes. If I do a specific query on each table it takes approx 3 seconds per table. Doing the same query on the MERGE tables takes approx 8.5 seconds. I then created an index on the tables (identical index on e

complicated query

hi, i am trying to move one of the databases we have in access to mysql and i have come accross a query that mysql doesnt like: SELECT Managers.Manager, Agents.Agent, Modules.Module, Messages.MLevel, Messages.Title, MessageInstance.Name, MessageInstance.Info, PolicyRuns.JobNo, Policies.Policy F

GROUP BY - CONCAT query question?

Hi, You can try the following. Store the result of your query into a temporary table, say tp, with two columns tc (ticketID) and pname (pipelineName). Run the following query : select concat("select @c:='';","select tc, (@c:=concat_ws("","",@c,pname)) as x, length(@c) from tp where tc=", tc," o

Re: True/False

Use the data type BOOL which takes a 1 or 0 character or use CHAR and then you can use Y or N for Yes/No. Regards, 'Gbamila - Original Message - From: "Tony Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 12:26 PM Subject: True/False > I am new to MyS

RE: True/False

You could use an integer (0 or 1) or an enum with the values 'y' or 'n' -Original Message- From: Tony Roberts [mailto:troberts@;momuk.com] Sent: Friday, November 08, 2002 4:26 AM To: [EMAIL PROTECTED] Subject: True/False I am new to MySQL and I am attempting a new project to help me lear

re: Unique identifier in MySQL

Yves, Friday, November 08, 2002, 5:31:28 AM, you wrote: YA> Hope this makes sense, I am totally new with using MySQL. YA> How would I create a unique ID number for a table, for, say, a field named YA> UserID for example? Take a look at AUTO_INCREMENT column: http://www.mysql.com/doc/en/exam

re: errors

Philippe, Friday, November 08, 2002, 10:51:14 AM, you wrote: PD> I downloaded mysql and i try to install it now (on slackware) PD> It's unpacked, i did everything as root. PD> But ./configure ends with mysql ended and ./bin/mysqld & ends also because PD> it can't write to a file (or more). PD> No

re: Ok, i want to restart the mysql

Fajar, Friday, November 08, 2002, 11:37:44 AM, you wrote: FP> But, before I remove the mysql installation, I want to restart it first so FP> that it reads my.cnf file, and see if it corrects the problem. FP> How do I restart the mysql from command prompt? FP> I'm using RH6.2 without XWindows. s

re: Error 2013

mazin, Friday, November 08, 2002, 5:50:55 PM, you wrote: m> I have been facing this problem since from many months. m> The problem is that when i try to connect mysql from the remote place using m> mysqld -h 192.168.1.1 -u temp -p m> it ends up with the error ERROR 2013: Lost connection to MySQL s

re: Quote command and special characters

Adam, Friday, November 08, 2002, 5:06:47 AM, you wrote: AY> Ok, I tried using the QUOTE() function exactly how they have it on the string page in the online manual. Needless to say, this has not worked at all...I get an sql syntax error every time. If AY> anyone else has had this problem or kn

re: How to make INNER JOIN right?

Putte, Friday, November 08, 2002, 11:09:11 AM, you wrote: PK> I have two tables wich I need to join together. I use INNER JOIN but there PK> is one problem. PK> I have a master table, where is a column where I have a WHERE clause, wich I PK> use as criterion for SELECT. PK> The second table has so

True/False

I am new to MySQL and I am attempting a new project to help me learn. I the past I have used a Boolean data type for True/False, Yes/No type data. What data type should be used to achieve the storage of this type of data in MySQL? I have bought the reference manual (a good buy IMHO) but so far c

Re: JDBC Connection Pooling Not Quite Right?

Hi, Rick, > Hi. I hope this is the right place to discuss this, now that the drivers are > part of the official MySQL stuff. If not, please let me know where I should > post this. Thanks. The Java list - [EMAIL PROTECTED] - would probaby be more appropriate than the general list, but otherwise t

DATETIME + days

I executed the following statement: UPDATE Table1 SET date_adm=date_adm+2 where date_adm='2002-10-30'; the result was...-00-00 I´m working with Mysql-max-nt 3.23.39. What´s wrong? best regards, Sil - Before posting, plea

JDBC Connection Pooling Not Quite Right?

Hi. I hope this is the right place to discuss this, now that the drivers are part of the official MySQL stuff. If not, please let me know where I should post this. Thanks. I've been using the 2.0.14 version of the drivers, and just recently switched to using the pooled connections supplied by JDBC

Re: Ok, i want to restart the mysql

Fajar Priyanto wrote: Hmm, thanks all.. But, before I remove the mysql installation, I want to restart it first so that it reads my.cnf file, and see if it corrects the problem. How do I restart the mysql from command prompt? I'm using RH6.2 without XWindows. /etc/init.d/mysqld restart Max

re: RE: LEFT JOIN selects with ORDER BY and WHERE and LIMIT missing results

Kevin, Tuesday, November 05, 2002, 12:55:41 PM, you wrote: KD> I've shrunk the dataset down as far as I can to continue to reproduce this KD> issue, but the .gz file is still 1.3MB KD> Running this on 4.0.3 produces the correct results. 4.0.4 doesn't. KD> fetch http://www.dragondata.com/ditsy.gz

re: Re: Problem creating InnoDB tables.

David, Wednesday, November 06, 2002, 10:00:45 PM, you wrote: DAF> - Original Message - DAF> From: "Victoria Reznichenko" <[EMAIL PROTECTED]> DAF> To: <[EMAIL PROTECTED]> DAF> Sent: Wednesday, November 06, 2002 11:47 AM DAF> Subject: re: Problem creating InnoDB tables. >> David, >> Tuesda

Ok, i want to restart the mysql

Hmm, thanks all.. But, before I remove the mysql installation, I want to restart it first so that it reads my.cnf file, and see if it corrects the problem. How do I restart the mysql from command prompt? I'm using RH6.2 without XWindows. Thanks.

How to make INNER JOIN right?

Hi there, I have two tables wich I need to join together. I use INNER JOIN but there is one problem. I have a master table, where is a column where I have a WHERE clause, wich I use as criterion for SELECT. The second table has some details for rows, wich fulfil the WHERE clause. I have an ID for

  1   2   >