Re: ENCODE & DECODE

2005-02-04 Thread Jeff Smelser
On Friday 04 February 2005 03:31 pm, John Trammell wrote: > In my version of MySQL (4.1.9), your sample code generates an error: > > mysql> select decode(encode("foo")); > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for

RE: ENCODE & DECODE

2005-02-04 Thread John Trammell
In my version of MySQL (4.1.9), your sample code generates an error: mysql> select decode(encode("foo")); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 Apparently encode()/de

Re: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Jeremy Cole
Hi Thomas, I'm looking for the syntax diagram for MySQL and can't find it. I have Just to give you a complete answer to your question, this is what is valid (I've stripped out the C code parts to leave just the definition): where_clause: /* empty */ | WHERE expr expr: expr_expr

Re: Premature InnoDB conversion.

2005-02-04 Thread Heikki Tuuri
A, - Original Message - From: "A Z" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, February 01, 2005 2:14 PM Subject: Premature InnoDB conversion. MySql 4.0.14 We tried to convert MyISAM table format to INNODB format, it took forever to finish the process, someon

Re: innodb problem

2005-02-04 Thread Heikki Tuuri
Matteo, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, February 04, 2005 3:51 PM Subject: innodb problem Hello, my name's Matteo, probably my question is basic but I'm new with mysql. I've an application that write some milion of row in m

Re: Multiple Tablespace

2005-02-04 Thread Heikki Tuuri
Sabeer, - Original Message - From: "Sabeer MZ" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, February 04, 2005 7:33 PM Subject: Multiple Tablespace Hi ALL, Im using mySQL Distrib 4.0.18 and using single Tablespace (/data/ibdata/ibdata1). Now Im planning to upgrade

Re: ENCODE & DECODE

2005-02-04 Thread Jeff Smelser
On Friday 04 February 2005 11:00 am, shaun thornburgh wrote: > Apparently not! > > mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM > DATA_TABLE_PID_1_DESC_137; Is it so hard to read directions? select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137; This assumes

MySQL upgrading

2005-02-04 Thread Helena Carlsson
Hi all, I know this is a silly question but, frankly, I didn't find any useful and straightforward document in dev.mysql.com. I want to upgrade mysql server on a fedora core 3 linux system from 3.23 to the latest version 4.1. First I want to know if is possible, because I have read somewhere that

Re: Indexing Questions (Problem?)

2005-02-04 Thread Brad Guillory
Thanks Tom and Michael, I got rid of all of the indexes except the one marked "PRIMARY" and a new one that I made like this: ALTER TABLE logs ADD unique (host,date,time,priority,facility,seq); I see quite an improvement from what I was seeing before. The one thing that I didn't realize is that

Re: Cant connect to mysql error :20031 /10061

2005-02-04 Thread Michael Dykman
First, check your my.cnf file to see if you have a 'bind-address' entry. Such an entry will constrain you system only responding to machines on the same network. Failing that, have you checked you firewall settings? Are you sure that can can even reach port 3306 on that machine from the outside

Re: Help with date query

2005-02-04 Thread SGreen
Jack Lauman <[EMAIL PROTECTED]> wrote on 02/04/2005 11:57:37 AM: > I want to run a nightly cron job where you iterate throught each row of > a single table and reset a field depending on the conditions specified. > In this case I want to take a date field (RenewalDate) and compare it > to the

Re: Log data transfer amount?

2005-02-04 Thread DreamWerx
No ideas internally to mysql, you can always fire up a sniffer (sniffit, tcpdump, etc).. something like that would tell you. On Mon, 31 Jan 2005 20:32:49 -0500, John May <[EMAIL PROTECTED]> wrote: > Anyone have any ideas on this one? : > > >I've scoured the MySQL manuals... does anyone know if

Cant connect to mysql error :20031 /10061

2005-02-04 Thread marcelofabiani
Hi I've a question I have a delphi program that connects to a mysql database via obdc, and works perfect in the lan and in the server, I want to know if I can enter the database if I have the program installed in another city or place, I know that I have to enter the IP of the server but I've t

Multiple Tablespace

2005-02-04 Thread Sabeer MZ
Hi ALL, Im using mySQL Distrib 4.0.18 and using single Tablespace (/data/ibdata/ibdata1). Now Im planning to upgrade to 4.1.8 and move single tablespace to Using Per-Table Tablespaces. Please share your expertise in moving single TB to using per-table TB with my existing data also. Thanks Sabeer

Re: ENCODE & DECODE

2005-02-04 Thread Gleb Paharenko
Hello. I think you should remove the space after DECODE. "shaun thornburgh" <[EMAIL PROTECTED]> wrote: > Apparently not! > > mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM > DATA_TABLE_PID_1_DESC_137; > ERROR 1064: You have an error in your SQL syntax. Check th

Re: Upgrade packaged MySQL

2005-02-04 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/upgrade.html http://dev.mysql.com/doc/mysql/en/windows-upgrading.html If your MySQL distribution came as embedded version, you should look at: http://dev.mysql.com/doc/mysql/en/libmysqld-overview.html The complete answers related to

Help with date query

2005-02-04 Thread Jack Lauman
I want to run a nightly cron job where you iterate throught each row of a single table and reset a field depending on the conditions specified. In this case I want to take a date field (RenewalDate) and compare it to the current date less a 30 day grace period and if true reset the (Subscripti

Re: ENCODE & DECODE

2005-02-04 Thread shaun thornburgh
Apparently not! mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_1_DESC_137; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( CSV_DATA_ENC_FORENAME, "test_passw

Re: !! Help with query: Where Date = MAX(Date)

2005-02-04 Thread Michael Dykman
On Fri, 2005-02-04 at 09:19, Graham Cossey wrote: > Could someone please offer a little help. > > I have a table like: > > Year, Month, Start_date > 20041020041102 > 20041120041203 > 20041220050104 > 20050120050204 > 2005022

Upgrade packaged MySQL

2005-02-04 Thread Elton Clark
Any advice for upgrading MySQL when it came packaged with a commercially available code (iTracker by Newark Electronics)? -Elton WindowsNT

Re: developing an interface

2005-02-04 Thread Michael Dykman
On Fri, 2005-02-04 at 11:08, Duncan Hill wrote: > On Friday 04 February 2005 16:03, Winn Johnston might have typed: > > > My users have expressed a distinct dislike for point > > and click methods. They would rather use the keyboard > > in the same way a ticket agent does when she is > > looking f

RE: !! Help with query: Where Date = MAX(Date)

2005-02-04 Thread Graham Cossey
> > As I'm using 4.0.20 I can't use subqueries so how can I create > a query that > > does this? > > > > SELECT year, month > > FROM `dc_months` > > WHERE start_date = (SELECT MAX(start_date) > > from dc_months

Re: developing an interface

2005-02-04 Thread Winn Johnston
lynx i like it :) thanks duncan, u the man winn johnston -- Duncan Hill <[EMAIL PROTECTED]> wrote: > On Friday 04 February 2005 16:03, Winn Johnston > might have typed: > > > My users have expressed a distinct dislike for > point > > and click methods. They would rather use the > keyboard

Re: ENCODE & DECODE

2005-02-04 Thread Jeff Smelser
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote: > I have a table where users upload various data items via a web site. Some > fields in the table are named DATA_ENC... to denote that the data should be > encrypted uusing the encode function. This all works fine, however when I > come

Re: developing an interface

2005-02-04 Thread Duncan Hill
On Friday 04 February 2005 16:03, Winn Johnston might have typed: > My users have expressed a distinct dislike for point > and click methods. They would rather use the keyboard > in the same way a ticket agent does when she is > looking for a flight :) You can do this one of two ways. Give them

Re: developing an interface

2005-02-04 Thread Winn Johnston
--- [EMAIL PROTECTED] wrote: > Winn Johnston <[EMAIL PROTECTED]> wrote on > 02/04/2005 10:30:54 AM: > > > I have taken on a job replacing an old AS400 RPM > > database with four thin clients. They really like > the > > feel of the thin client interface, no point and > click, > > no graphics, jus

Re: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Peter Brawley
Thomas, As you've discovered, MySQL documentation doesn't (yet) include a syntax diagram, but there's a manual page for WHERE clauses, there's a manual page for logical operators including XOR, and they show that the answer to your question about WHERE clauses using XOR is 'yes', as does writi

ENCODE & DECODE

2005-02-04 Thread shaun thornburgh
Hi, I have a table where users upload various data items via a web site. Some fields in the table are named DATA_ENC... to denote that the data should be encrypted uusing the encode function. This all works fine, however when I come to selecting the data from the table I would like to be able to

Re: developing an interface

2005-02-04 Thread SGreen
Winn Johnston <[EMAIL PROTECTED]> wrote on 02/04/2005 10:30:54 AM: > I have taken on a job replacing an old AS400 RPM > database with four thin clients. They really like the > feel of the thin client interface, no point and click, > no graphics, just green text on a black background. I > could use

interface developing

2005-02-04 Thread Winn Johnston
i have taken on a job replacing an old AS400 RPM database with four thin clients. They really like the feel of the thin client interface, no point and click, no graphics, just green text on a black background. I could use any suggestions on what to read, or where to look to find a way to create a s

Re: Indexes

2005-02-04 Thread SGreen
A Z <[EMAIL PROTECTED]> wrote on 02/04/2005 07:21:35 AM: > > MySql 4.0.14 > > I understand that the most effective way of speeding > up SELECT statements is to have column level indexes. > Are there any other level indexes exist? I have been > told that there are but I have no idea, looked thr

developing an interface

2005-02-04 Thread Winn Johnston
I have taken on a job replacing an old AS400 RPM database with four thin clients. They really like the feel of the thin client interface, no point and click, no graphics, just green text on a black background. I could use any suggestions on what to read, or where to look to find a way to create a s

RE: Character Sets, 4.0 and 4.1

2005-02-04 Thread Kevin Cowley
Bruce We're sort of in the same boat but if you persevere you can eradicate all the problems. Now we don't run the server as utf8 which does cause a number of problems - we don't want all the databases to be utf8 just some of them, and just some tables on some of them. For a database that needs

Re: Error on View

2005-02-04 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/gone-away.html [snip] Hi, I installed the mysql 5.0.2 alpha for linux and i got an error after created a view and try to select * from the view. ERROR 2013: Lost connection to MySQL server during query Does anyone kno

Re: innodb problem

2005-02-04 Thread Gleb Paharenko
Hello. Use the max attribute. See: http://dev.mysql.com/doc/mysql/en/innodb-configuration.html If you want to decrease the size of your tablespace, see: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html [EMAIL PROTECTED] wrote: > Hello, my name's Matteo, probably my questi

Re: How can we use --log-warnings

2005-02-04 Thread Gleb Paharenko
Hello. I didn't find any bug related to this behaviour. What operation system do you use? Connect to the server with mysql command line client program and kill it with the SIGKILL signal. Check the error file to find messages about aborted connections. Can you reproduce a problem on the late

Re: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Gleb Paharenko
Hello. May be it is not exactly what you want, but usually, I look at the sql/sql_yacc.yy in a source distribution. "Thomas Sundberg" <[EMAIL PROTECTED]> wrote: > Hi! > > I'm looking for the syntax diagram for MySQL and can't find it. I have > downloaded the entire MySQL manual as one

Re: Symchronization problem

2005-02-04 Thread Gleb Paharenko
Hello. Hello. A lot of thins may cause this behaviour, even not related to the replication. At: http://dev.mysql.com/doc/mysql/en/todo-mysql-5-1.html said that, the one of the new feautures would be: "Online backup with very low performance penalty." So it can be an answer on your q

Re: ssh connecting with a mysql client I get: ERROR 2013

2005-02-04 Thread Gleb Paharenko
Hello. Can you connect using the mysql command line client program? "leegold" <[EMAIL PROTECTED]> wrote: > ssh connecting with a mysql client gui I get: ERROR 2013 Lost > connection to MySQL server during query > > I'm using mysqlyog and trying connect via the ssh tunnel. I can connec

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-04 Thread Gleb Paharenko
Hello. 4.0.17 is old enough. You may switch to the debug version and attempt to find the clues in debug or trace files. Can you reproduce an error on the latest release (4.1.9 now)? Do you lost connection to the server with other statements, than 'SHOW DATABASES'? Please answer on this questi

Character Sets, 4.0 and 4.1

2005-02-04 Thread Bruce Dembecki
So today for the second time in six weeks we are faced with rolling back to mysql 4.0 because of dramas with character sets. I don't know about anyone else but this supposedly wonderful feature has been nothing but a nightmare for us. So our Application servers use Unicode for our non US English p

Re: Question: InnoDB transaction and table changes

2005-02-04 Thread Philippe Poelvoorde
DDL cannot be rollback http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html It also apply to many DB like Sybase for example... Ville Karjalainen wrote: Greetings, I created a table during transaction and was surprised to find out it still existed after I did a ROLLBACK. The same seems to apply

Re: !! Help with query: Where Date = MAX(Date)

2005-02-04 Thread Philippe Poelvoorde
Graham Cossey wrote: Could someone please offer a little help. I have a table like: Year, Month, Start_date 20041020041102 20041120041203 20041220050104 20050120050204 20050220050303 I need to get the latest Year,Month for a given date, so for example today

Re: passing environment variable to an SQL script

2005-02-04 Thread Tom Cunningham
I found an answer: mysql -e "SET @VAR:=1234; SOURCE xxx.sql" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

!! Help with query: Where Date = MAX(Date)

2005-02-04 Thread Graham Cossey
Could someone please offer a little help. I have a table like: Year, Month, Start_date 20041020041102 20041120041203 20041220050104 20050120050204 20050220050303 I need to get the latest Year,Month for a given date, so for example today (20050204) I

RE: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Alec . Cawley
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005 13:48:03: > It is very simple but absolutely not straight forward. It really doesn't say > anything. Just that you should do things right and then you will not have > any problems. > The concrete problem I tried to solve were if MySQL su

RE: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Tom Crimmins
> -Original Message- > From: Thomas Sundberg > Sent: Friday, February 04, 2005 07:48 > To: mysql@lists.mysql.com > > > > -Original Message- > > From: Michael Stassen > > Sent: den 4 februari 2005 14:19 > > To: Thomas Sundberg > > Cc: mysql@lists.mysql.com > > > > From the manu

RE: Question: InnoDB transaction and table changes

2005-02-04 Thread Mark Leith
Simple, ROLLBACK reverts DML (data) changes, not DDL (structure) changes.. mysql> select version(); +---+ | version() | +---+ | 4.1.7-nt | +---+ 1 row in set (0.01 sec) mysql> SHOW VARIABLES LIKE "have_innodb"; +---+---+ | Variable_name | Value | +---

Question: InnoDB transaction and table changes

2005-02-04 Thread Ville Karjalainen
Greetings, I created a table during transaction and was surprised to find out it still existed after I did a ROLLBACK. The same seems to apply to changes made using ALTER TABLE statements. Is there a simple logical explanation to this behaviour? Any help would be appreciated. Demonstration fol

innodb problem

2005-02-04 Thread matteo . pozzi
Hello, my name's Matteo, probably my question is basic but I'm new with mysql. I've an application that write some milion of row in mysql innodb table. Every day my application creates a new table, write data and drop table oldest than 15 days. After the drop table execution command the disk space

RE: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Thomas Sundberg
> -Original Message- > From: Michael Stassen [mailto:[EMAIL PROTECTED] > Sent: den 4 februari 2005 14:19 > To: Thomas Sundberg > Cc: mysql@lists.mysql.com > Subject: Re: Syntax diagram, where is it located in the doc? > > From the manual, "where_definition consists of the keyword > WHE

RE: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Alec . Cawley
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005 12:46:02: > > > > Does anybody at the list know the answer to my question? I > > sent it a > > > few days ago and haven't received any response. It does > > exist a syntax > > diagram > > > for MySQL, doesn't it? > > > > Since no-one

Re: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Michael Stassen
From the manual, "where_definition consists of the keyword WHERE followed by an expression that indicates the condition or conditions that rows must satisfy to be selected." That seems simple and straightforward to me. Perhaps if you told us why

Fw: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Gabriel PREDA
You're right there is none.. .but as you see there is a short line that says: "In the WHERE clause, you can use any of the functions that MySQL supports, except for aggregate (summary) functions. See section Functions and Operators." Gabriel PREDA > - Original Message - > From: "T

RE: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Thomas Sundberg
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: den 4 februari 2005 12:45 > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Subject: Re: Syntax diagram, where is it located in the doc? > > "Thomas Sundberg" <[EMAIL PROTECTED]> wrote > on 04/02/2005 >

Indexes

2005-02-04 Thread A Z
MySql 4.0.14 I understand that the most effective way of speeding up SELECT statements is to have column level indexes. Are there any other level indexes exist? I have been told that there are but I have no idea, looked through the manual, could not find anything that speeds up column level ind

Re: Syntax diagram, where is it located in the doc?

2005-02-04 Thread Alec . Cawley
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005 11:39:12: > Hi! > > I'm looking for the syntax diagram for MySQL and can't find it. I have > downloaded the entire MySQL manual as one html page and searched it for the > definition of where_definition and I cant find it. Could somebody

Syntax diagram, where is it located in the doc?

2005-02-04 Thread Thomas Sundberg
Hi! I'm looking for the syntax diagram for MySQL and can't find it. I have downloaded the entire MySQL manual as one html page and searched it for the definition of where_definition and I cant find it. Could somebody please point me to a location where the complete syntax diagram can be found? D

Re: ms sql server to mysql migration

2005-02-04 Thread Martijn Tonies
Hello, > The platform we are working is Mysql 4.1.8 version > and Windows XP os. > > In ms sql server the space used and free space > available for each database is obtained through > 'sp_spaceused'procedure( built in ). > > Primary memory used by ms sql server and related > services l