Re: ENCODE & DECODE

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

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?

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.

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

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

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

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

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?)

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

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

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?

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

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

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

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

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

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

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)

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

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

Re: developing an interface

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)

> > 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

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

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

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

--- [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?

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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)

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

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)

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?

"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?

> -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

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

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

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?

> -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?

"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?

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?

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?

> -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

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?

"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?

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

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