Regarding mysql.sock file

Hello all, I am working with the replication of mysql with selected db. While i was trying to do that suddenly slave machine's mysql.sock file was deleted. So i am not able to enter into mysql. May i know whether there is any other way to get it(mysql.sock) back as i restarted mysql quite ample

Re: Once more: MS Word & MyODBC !?!?!

Hi Butch, > I included the links to MySQL.com for the ODBC Drivers (Win2k/XP or Win98). > I am running Win2k and XP Pro so I know it works well with them. > Make sure you run setup.exe from the directory you unzipped the files. > The last step for install on the ODBC is setting up a DSN: > Next

MyODBC & MS Word & MS Query

Hello ! I got MS Query working, but only in interactive mode. I tried to record the Word activities to following makro: -snip --- snap - ActiveDocument.MailMerge.OpenDataSource Name:="", ConfirmConversions:= _ False, ReadOnly:=False, LinkToSource:=False, AddToRecentFiles:=False,

Re: Bandwidth Throttling?

On Thu, Jan 31, 2002 at 05:31:02PM -0500, Gary Huntress wrote: > As you can see from my signature, I run FreeSQL.org. Over the past > year I have had great success and grew in a manageable fasion. > Believe it or not, I've been hosting this site on a cable modem. Up > until recently, bandwidth

Re: Bug in UNIQUE?

In the last episode (Feb 01), Carsten Gehling said: > > >The SQL below illustrates what I believe is a bug in MySQL up to > > >and including 3.23.47. Essentially I need a unique key where one > > >or more of the component fields of the unique key can be NULL. > > >What seems to happen is that you

Re: Bug in UNIQUE?

From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Jude Insley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Subject: Re: Bug in UNIQUE? > >The SQL below illustrates what I believe is a bug in MySQL up to and > >including 3.23.47. Essentially I need a unique key where one or more of > >the component field

problem sorting integer

Hi all, I have been using mysql since long time. But suddenly I noticed that, there is no function for sorting intervalues from the tabel. Clarifying more If I have a set of employee numbers and i need to sort them in descending order, I found that it gives erroneous results. The query is

Re: Update syntax

You can't in a single SQL statement in MySQL: MySQL does not allow updates based upon joins. Program around it using whatever language (perl, php, etc.) that you're running the SQL statements from. - Original Message - From: "Vadim Kulikov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

Re: 'Automating Mailing Facility'

I'm not sure what MS-SQL's automated mailing thing does exactly, so it depends what you want to use it for. It's easy to make a script that generates email based on the contents of the database. If you want it to generate an email when there's a server error or something, I don't think you can d

Re: 'Automating Mailing Facility'

Um.. RDBMS != Bulk Mailer sreedhar wrote: > > Hi All, > > Is there any possiblity 'Automating Mailing Facility' like in MS-SQL in > MySQL. If not, which mid range database is suitable for me for my project. > > regards, > sreedhar > > -

'Automating Mailing Facility'

Hi All, Is there any possiblity 'Automating Mailing Facility' like in MS-SQL in MySQL. If not, which mid range database is suitable for me for my project. regards, sreedhar - Before posting, please check: http://www.mysql.c

Re: Starting MySQL (w/ InnoDB) for the firs time

In the last episode (Jan 31), Eric Mayers said: > How can I tell when the database is ready to go (preferably from a shell > script)? while ! mysqladmin status > /dev/null 2>&1 ; do sleep 10 ; done -- Dan Nelson [EMAIL PROTECTED]

Starting MySQL (w/ InnoDB) for the firs time

Hi Everyone, I'm using MySQL with 5 2gb InnoDB data files in a system that an end user will install. My problem is that the first time InnoDB starts up after installation it takes a long time for it to build its data files. The delay is annoying (any ways to make this faster?) but acceptable,

Update syntax

Greetings: I'm trying to update a table T1 based on the condition which is a result of the key join table A and table B the following command works with SYBASE but doesn't with MySQL: update A,B set A.field2='test' where A.field1=B.field1 and B.field5='test2' What's the correct syntax for

show processlist oddities

Personally I feel that I have a pretty good understanding on MySQL locking, however I am confused by the output I've received from "SHOW PROCESSLIST" at seemingly random times. At the end of this message is the output from "SHOW FULL PROCESSLIST." ALL queries from output are shown. ALL WHERE clau

Re: installation directories and non-root execution

This is a RedHat thing. They make the RPMs. The MySQL guys make the tarballs. I use the tarballs, and put them in /usr/local/mysql-version, with a symlink from /usr/local/mysql to the "current" version. That way, I can have more than one version installed, and switch between them (handy for u

Re: mysql in WinME problem cant start

At 19:55 -0500 1/31/02, [EMAIL PROTECTED] wrote: >I got WinME with intallation of mysql 3 23 47 for Win > >I try to start with c:\mysql\bin\mysqld >this gives me an error "cannot initialize as 'innodb_data_file_path' is >not set" and keeps coming up even tho I set "skip-innodb" >if I get this erro

installation directories and non-root execution

I am an experienced database developer (Sybase on Solaris mostly) but new to MySQL on Linux (so please feel free to redirect me to a more suitable forum if that is appropriate). Question 1: I have just downloaded and installed the RPM version of MySQL 4.0 on a RH7.1 system. In reading the doc

Re: Missing values in an INT type column

you could possibly do this. well first, is there a fix size for the extension ? i.e 3 digit or 4 digits. if so, you could easily fill a table with a script with all the ranges of extensions, say that table is called static_extension then you can do the "not in" join select * from static_extens

Missing values in an INT type column

I hope this doesn't sound like a stupid question. Is there anyway of finding missing values in an INT column type? Say I have a telephone extension guide. Using the MIN() and MAX() functions I am able to find the start and end ranges. But what about finding the extensions that are not allocated.

Re: Plz help w/ query

Anthony, I'm inclined to agree with Rick, but that will not solve the problem - in fact I'll suggest using MySQL_fetch_assoc() instead! What is the data type for the date_done column? If it is not a string type, then you don't want to enclose the zero-constant value in quotation marks. Do you

Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting started

Paul, my Server is up and running! It was at least the "&" at the line's end. Many thanks to you, Egor and Michael and all who helped. It was nice working with you. Helmuth [EMAIL PROTECTED] PS.: -> stop the server (control-Z) did not work, but killing within another terminal window did. ---

Re: Does MySQL work with VMWare?

On Thu, Jan 31, 2002 at 11:02:11AM -0600, BD wrote: > > I have a Win2k machine and want to know if it is practical for > development purposes to run MySQL in a VMWare linux window. Has > anyone tried it? Are there any caveats? TIA I've done the opposite. I've run MySQL in Win98 via VMWare on Lin

about a mysql facility

Hi all, Imagine a php script query a database wich is down. Is there any facility that allow me to query the mysql database again when it will be up. Or is the only way a sql batch generated and a periodically crontab script wich 'mysqladmin ping' the server and and launch this batch when ready.

Re: Bandwidth Throttling?

Accidentally sent a bit too early > > My question is this. Database server network usage is very asymmetric, > incoming queries are small, outbound datasets are probably considerably > larger.Given that I will now be further limiting outbound flow without > really impacting the arrival rate

dbf2mysql

Greetings! Before I give any details of my problem...may I ask questions concerning dbf2mysql here? If the answer is no, where do I go? I sent email to maarten, but the address was faulty. Thanks for any help/suggestions. John F. Godfrey, Pastor Grandville Assembly of God, Grandville, MI US

Possible bug? Or ignorance on my part?

Is there any kind of UPDATE query limitation that would not allow me to make the following update? Basically my update is updating to the same text, only without the '[' and ']' from around the url. Only mysql is not updating the record. If I try updating to something else (like add an "as

Re: MyODBC Guru's Having MyODBC Woes

Hey Samy; re. could not find odbc.ini This is reported by the ODBCConfig when it can not find the odbc.ini but it is usually looking for the User one (the one in your home dir) - so it goes on to create it and you should not get this message anymore. If you continue to get the message then it

synchronising a mysql database on different servers

I know abouts MySQL's Replication, but i don't think this will help me This is the situation: I'm working for a (small) company with 4 offices in different parts of the country. I've constructed a database in mysql and made an interface in PHP that should be accessible for all 4 offices. I don't

RE: Is this possible in one SQL statement

mysql> select distinct a.* from tableA a left join tableB b1 using(id), tableB b2 where a.id=b1.id && b1.id=1 && b2.id=3; -Original Message- From: Steen Rabol [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 2:51 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: Is this possibl

Re: DBD::Mysql on Mac OS X

At 13:54 -0500 1/31/02, John Tsangaris wrote: >I am trying to install mysql, DBI, and DBD::mysql on MacOS X. > >My problems are in the DBI and DBD::mysql part. > > >Has anyone successfully installed the DBI and DBD::mysql perl modules on >this platform? > >I'm running into troubles in the fact tha

Re: Is this possible in one SQL statement

I want to select all the records in table A which have record in Table B where field1 is equal to 3 and have a record in Table B where field1 is equal to 1, in other word two records (or more) must exist in Table B in order to give me a record from Table A like this select * from table_a, tabele

RE: Is this possible in one SQL statement

Hard to understand your example: b_field2 is not part of your table b table structure; your example table b rows are missing either their ID field or the non-existent b_field2 and the explanation as to why table A rows A1 and A3 would qualify is not clear when the values 1 and 3 are not relate

RE: Quick SQL querie on count and embedded SELECT

SELECT COUNT(p.artID) AS LCNT FROM pages p WHERE p.siteID = 1 -Original Message- From: Nick Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 8:20 AM To: [EMAIL PROTECTED] Subject: Quick SQL querie on count and embedded SELECT Hi all, I want to do this, SELECT COUN

RE: Plz help w/ query

Do away with that wretched MYSQL_ASSOC. I've seen it cause much pain and misery. It is not needed. while ($row_1=mysql_fetch_array($result_1)) -Original Message- From: Anthony Rodriguez [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 7:32 AM To: [EMAIL PROTECTED] Subject: P

RE: Is this possible in one SQL statement

Please restate the following more completely. I think some typos got in there. If not, then we need more detail of what you really want. the condition is then value 1 and 3 and the record I want is A1 and A3 due to the fact that a recorc exists in table B with a value of on and one record with

Is this possible in one SQL statement

Is this possible in a single select statement ? table A id (Unique), a_field1,a_field2,a_field3 table B id(NOT unique), b_field1 Id in table B is a ref to id in table A Now i would like to select all the id's from table A which have records i table B where b_field1 is 1 and b_field2 is

Re: how to test JDBC driver!

You can find all kind of programs all over the internet to do this (and more). Or: String driver="org.gjt.mm.mysql.Driver"; //or whatever you are using String url = "jdbc:mysql://yourip:3306/yourdatabase"; Class.forName(driver); java.sql.Connection connection = java.sql.DriverManager.getConnection

DBD::Mysql on Mac OS X

I am trying to install mysql, DBI, and DBD::mysql on MacOS X. My problems are in the DBI and DBD::mysql part. Has anyone successfully installed the DBI and DBD::mysql perl modules on this platform? I'm running into troubles in the fact that, god bless them, whoever decided to put unix on a mac

bdb table data deleted

>Description: Hi all, I'm not exactly sure whether this is a bug or that I'm just the following proper procedures for starting and stoping the database and flushing logs. But I do have repeatable test cases below.(terminal screen dumps) I'm using version 3.23.36 with BDB tables: Basically my da

how to test JDBC driver!

I have installed and configured JDBC driver to work with MySql 3.23.47. Does anyone know how to test to see that JDBC driver is working properly? Is there a test file? thanks --rahad - Before posting, please check: http://ww

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.

Re: Does MySQL work with VMWare?

Joel Wickard wrote: > why not run cygwin? I run postgres on my win2k box through cygwin. It > would be less resource intensive. Or even better, run the native Windows port. It's quite a good one. -- Shankar. [ database table query sql ] -

Re: SV: MySQL on the Playstation2? (OT? You betcha)

I'm glad you spelled it out. When it first started I thought you were refering to IBM PS/2 computer, silly me. On Thu, 31 Jan 2002 [EMAIL PROTECTED] wrote: > Date: Thu, 31 Jan 2002 16:01:46 +0100 > From: [EMAIL PROTECTED] > To: [EMAIL PROTEC

Fw: Does MySQL work with VMWare?

why not run cygwin? I run postgres on my win2k box through cygwin. It would be less resource intensive. > - Original Message - > From: "BD" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, January 31, 2002 9:02 AM > Subject: Does MySQL work with VMWare? > > > > I have

Re: bdb table crashes?

Kalok Lo writes: > I've had many problems with BDB table crashes. > Up until now, I haven't really cared, running safe_mysqld, the database just > restarts, and things proceed as normal. > > But recently I've had some strange behaviour, where table data is deleted > after an "alter table" stateme

Re: Erroneous results from a join after a delete

John Heitmann writes: > Thanks for the quick response. > > > > select t1.*, t2.name from t1, t2 where t2.id=t2_id; > > > > The above is actually expected behaviour, as you are not doing a join > > at all, but a full Cartesian product. > > That t2_id is actually from t1. Sorry for the confusing

Does MySQL work with VMWare?

I have a Win2k machine and want to know if it is practical for development purposes to run MySQL in a VMWare linux window. Has anyone tried it? Are there any caveats? TIA Brent - Before posting, please check: http://www.my

E_FAIL error.

Hi! I made a query like: str_q = "desc mytable;" calling ado, and writing to an excel sheet the Field, Type, Null, etc... Everithing is ok, while the rsADO.Movenext find a record, where the default value is NULL. /My Test table is below./ So, the first record like this is a1. At here i've got an

sql question: aggregation and concatenation?

The following SQL statement: mysql> SELECT equipment_name FROM equipment; Returns the following resultset: +---+ | equipment_name| +---+ | Easel | | Paper Grocery Bag | | Paper Plates | | Colored Pencils | +---+ Is it possi

Re: Bug in UNIQUE?

At 16:49 + 1/31/02, Jude Insley wrote: >Hi, > >The SQL below illustrates what I believe is a bug in MySQL up to and >including 3.23.47. Essentially I need a unique key where one or more of >the component fields of the unique key can be NULL. What seems to happen >is that you can add "duplicate

Bug in UNIQUE?

Hi, The SQL below illustrates what I believe is a bug in MySQL up to and including 3.23.47. Essentially I need a unique key where one or more of the component fields of the unique key can be NULL. What seems to happen is that you can add "duplicate" rows if the value is NULL. Has anyone come

Re: bdb table crashes?

I've had many problems with BDB table crashes. Up until now, I haven't really cared, running safe_mysqld, the database just restarts, and things proceed as normal. But recently I've had some strange behaviour, where table data is deleted after an "alter table" statement. Upon looking through the

Re: 97% CPU MySQL freeze Problem

Hi, I think this is more than a threads problem. If your machine has run fine with this software for more than two years and you have not made any changes, then I doubt that the threads problems would be 'suddenly' affecting you this badly. Could you be having hardware problems at this point

Re: Re: Erroneous results from a join after a delete

On Thu, Jan 31, 2002 at 05:16:23PM +0100, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply t

Re: Really good idea on Performance Tuning???

At 03:02 PM 1/30/2002 , you wrote: >At 12:22 PM 1/30/2002 -0600, you wrote: > >I sent a reply back to JW about his problem on performance tuning and > came up with I thought a really good idea. But there weren't any bites so > I thought I start it on a new thread. > >I'd like to point out that I

Re: Really good idea on Performance Tuning???

At 02:38 PM 1/30/2002 , you wrote: >What is the best source of information about >performance tuning MySQL? I saw that Jeremy's proposed >book was to include a lot of coverage on this topic -- >are there other sources? Is the online doc the best >place so far? I would first rely on Heikki's sugg

RE: Once more: MS Word & MyODBC !?!?!

First things first... I included the links to MySQL.com for the ODBC Drivers (Win2k/XP or Win98). I am running Win2k and XP Pro so I know it works well with them. Make sure you run setup.exe from the directory you unzipped the files. The last step for install on the ODBC is setting up a DSN: F

Re: Erroneous results from a join after a delete

John Heitmann writes: > Hello, > > I have come across a possible bug in MySQL that causes NULL values to > be erroneously returned from a join. > > Problem: An inner join between two tables succeeds, but one column is > erroneously returned as all NULL if the join occurs after a delete in > tabl

Erroneous results from a join after a delete

Hello, I have come across a possible bug in MySQL that causes NULL values to be erroneously returned from a join. Problem: An inner join between two tables succeeds, but one column is erroneously returned as all NULL if the join occurs after a delete in table 1. Platforms Tested: 3.23.43 (Solar

RE: MySQL on the Playstation2? (OT? You betcha)

> Aye. Neither is a matchbox-sized webserver any good. Still > someone made it. > :-) > > - Carsten > query :-) ...though not as small (or even as useful) as a matchbox- sized server, certainly more interesting in terms of power supply: http://world.std.com/~fwhite/spud/ / Carsten -- Carsten

thanks

Thanks to all who responded to my message from yesterday re: the text field (or column) sizes available in MySQL. I've now gotten the download of the manual and will be pouring over that today in order to pursure further answers to questions specific to our project. Your quick replies and suggest

BDB Transactions and "Deleted" Data

Has anyone had the following problem or anything related to this ? I've had some problems where my data gets "deleted" after I add or drop a column. The scenario is as follows. 1)mysql daemon is running. 2)make a structure change to table/add or drop column 3)stop and restart mysql daemon 4)look

RE: Please clarify the doubt

MYSQL does not support STORED PROCEDURE, TRIGGERS or VIEWS. maybe, someday... -Original Message- From: Narendra [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 12:34 AM To: mysql Subject: Please clarify the doubt Hi, i am developing a software on linux platform and Mysql V

SV: MySQL on the Playstation2? (OT? You betcha)

Hi, I'm in this list to get facts about MySql, not to spend time reading philosofical discussions. Please -Ursprungligt meddelande- Från: DL Neil [mailto:[EMAIL PROTECTED]] Skickat: den 1 februari 2002 12:26 Till: Carsten Gehling; mySQL Mailing List Ämne: Re: MySQL on the Playstation

Cache error? or something else?

Anyone have any suggestions to get rid of the following error: SQLState: S1000 Native Error Code: 2013 [TCX][MyODBC]Lost connection to MySQL server during query I've read where it can be caused by caching or other problems but have not read any solutions anyone might have had to get rid of it.

Re: MySQL on the Playstation2? (OT? You betcha)

when you're in the programming gig for the science, you want to do EVERYTHING. when you're in it for the money, you want to do what's practical, not neat. For me computers and computer programming is a part of who I am, not just a job, but a passion. Sometimes it's hard for us to remember that

Quick SQL querie on count and embedded SELECT

Hi all, I want to do this, SELECT COUNT (a.artID) AS LCNT FROM (SELECT DISTINCT a.artID FROM pages p WHERE p.siteID = 1) Any ideas how to make this MySQL friendly? Cheers, Nick _ Chat with friends online, try MSN Messenger: h

man pages for MySQL

Hello all, I'm just wondering, is there a man pages for MySQL? Like the one that we use in linux, executing *man ls*, for example, in the command line provides some detail on how to use the command. Is there a similar method for MySQL where we can execute *man grant*, for example? thanks... l

Plz help w/ query

The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED]) ---

help: mysql database query

Hi, Can someone please tell me how this query can be better?? I need the "clubrecords" from atlethics database for onderdeel,categorie,inoutdoor. select onderdeel,categorie,MIN(prestatie) as prestatie,inoutdoor,naam,datum,wedstrijd,plaats FROM runtijden GROUP BY onderdeel,categorie,inoutdoor ha

Re: 97% CPU MySQL freeze Problem

hi i had the same problem on my freebsd 4.4 i installed mysql from ports and then had such a problem then i took sources from mysql.com and in file "INSTALL-SOURCE" i found: "... If you are using a recent version of *gcc*, recent enough to understand `-fno-exceptions' option, it is *VERY IMPORTA

Re: Schema documentation

The word "Schema" isn't really used in Mysql, it's just table descriptions. You can save them using mysqldump -d and read them in using SOURCE. Try http://www.mysql.com/doc/m/y/mysqldump.html Steve In Thursday 31 January 2002 09:50 am, udayashankarl_n wrote: > Hi! > Can anybody please point

vi mode in mysql client

Hello list, I've been using the default mysql client whenever I need to use the database interactively. Its always been a hope of mine that it would support vi style key presses and command mode. I found that you could change the default pager and then edit commands using vi, but this isn't as g

ANN: EMS MySQL Manager 1.5 released

Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.5) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.5?

Fwd: Table names case sensitivity

Mr, Thursday, January 31, 2002, 12:29:24 PM, you wrote: MKC> Hi, MKC> As what I described in the original text, I have MKC> changed the table names to lower cases. Thus, I think MKC> I have done exactly what the manual says. Is this a MKC> bug or what have I missed? You have grants on database

Re: MySQL on the Playstation2? (OT? You betcha)

> > I think a better question would be why ;-) > > To quote our beloved Basil Fawlty: "Do you think this is what made the > British Empire great?" > > When asked why anyone would want to climb Mount Everest, George Lee Mallory > answered: "Because it was there". > > Need I say more? :-) =Hmm, a

Fwd: Table names case sensitivity

Hi, As what I described in the original text, I have changed the table names to lower cases. Thus, I think I have done exactly what the manual says. Is this a bug or what have I missed? Thanks for your suggestion anyway. Kent. --- Egor Egorov <[EMAIL PROTECTED]> wrote: > Date: Thu, 31 Jan 2002

RE: MySQL on the Playstation2? (OT? You betcha)

Anyway they need an SQL database to hold MY high scores Peter > -Original Message- > From: Carsten Gehling [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2002 10:03 > To: mySQL Mailing List > Subject: Re: MySQL on the Playstation2? (OT? You betcha) > > > From: "Colin Faber" <[EMAIL PRO

Table names case sensitivity

Mr, Thursday, January 31, 2002, 6:01:21 AM, you wrote: MKC> Dear MySQL community, MKC> I am new MySQL user. I want to migrate a M$ SQL Server MKC> database to MySQL in a Linux box. Since table names in MKC> MySQL@Linux is case sensitive, I am having troubles MKC> connecting to the server via ODB

Please clarify the doubt

Narendra, Thursday, January 31, 2002, 8:33:48 AM, you wrote: N> Hi, N> i am developing a software on linux platform and Mysql Ver 11.13 Distrib N> 3.23.36, for redhat-linux-gnu (i386) as the backend and i would like to know N> if MySQL( any version like previous one or the latest version), eith

RE: Table names case sensitivity

Neil, Thank you for your suggestion. Unfortunately, the Grant command grants privileges to lower case table names also. I have also tried to find solution from archive of mysql mail lists but nothing useful have been found. Kent. --- Neil Silvester <[EMAIL PROTECTED]> wrote: > > -Original

Re: MySQL on the Playstation2? (OT? You betcha)

From: "Colin Faber" <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 7:07 AM > I think a better question would be why ;-) To quote our beloved Basil Fawlty: "Do you think this is what made the British Empire great?" When asked why anyone would want to climb Mount Everest, George Lee Mallor

Re: Problem with MySQL DATE_FORMAT or is it a PEBKAC??

Neil, > I appear to be having an error with the following update that I am > submitting to my database. I am using mysql's DATE_FORMAT function to pull > the date out and insert in a user friendly form. Upon submission of the > modified data, I use the below SQL to update the table information. >

Re: Once more: MS Word & MyODBC !?!?!

Hi folks, hi butch, yes, I do have MS query installed, but where to start? Is there a FAQ or HOWTO or just some sample-scripts? I just need the first steps, then I think I can walk alone ... rgds, Felix. - Original Message - From: "Butch Bean" <[EMAIL PROTECTED]> To: "Felix Sche

RE: Re[2]: Help with hanging MySQL server

> >> Yes, take the right-compiled MySQL binary distribution from > >> http://www.mysql.com. > > EC> I rebuild MySQL 3.23.36 with debug on, then ran "mysqld > --debug". Here's the output of the trace, if it will help. Looks > EC> like MySQL gets to the listen(), but hangs up in threads > before i

Re: Batch load of data problems (fwd)

Ed, If the code below is exactly what you are using, please check 6.4.9 LOAD DATA INFILE Syntax for the default separator, terminator, etc rules. Regards, =dn - Original Message - From: "William R. Mussatto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: 31

Re: 97% CPU MySQL freeze Problem

> since some days we have a critical problem: > 1 or 2 times a day the mysql CPU usage grows up to 97% > (normally 20-40%) and mysql-daemon freezes. > mysql : 3.22.22 > os : FreeBSD 3.2 > system : intel dual pentium > ram : 512 MB This is a known problem with the threading library on FreeBSD. A

select woes

George, Wednesday, January 30, 2002, 7:08:53 PM, you wrote: GME> Hello. GME> If anyone has a quick moment, I would appreciate some suggestions with GME> regards to the following select statement: GME> SELECT widget_src FROM widgets WHERE items.foo='abc123' and GME> item_details.item_type='I' an

Schema documentation

Hi! Can anybody please point me to documentation on Schema?. I couldn't found any in mysql manual. tia uday - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

97% CPU MySQL freeze Problem

hello, our mysql-system worked fine for 2 years. (per day 80.000 pageviews and 200.000 SQL requests) no changes in programs or system have been made. since some days we have a critical problem: 1 or 2 times a day the mysql CPU usage grows up to 97% (normally 20-40%) and mysql-daemon freezes.

How can I optimize SELECT .. FROM t1, t2 WHERE t1 join t2 ORDER by timestamp DESC LIMIT 10

I have a table which constantly grows. In selects I need only the (chronologically) last inserted x rows. The solution ORDER by timestamp DESC LIMIT x is a poor solution, since it is an O(n) case for the DBMS. Is there an elegant (probably mysql-proprietary) SQL-solution for this ? My solution is