Re: Accessing DBMS remotely: MySQL? FireBird?

Fred, > >> This list is not a great place to ask about Firebird. > > But then, since I'm wondering whether to use MySQL or FireBird, they'll > probably tell me the same thing over at the FB mailing list :-) Feel free to send me a personal email with questions about Firebird. With regards, Mart

Re: Documentation on character sets for version 4.0.17

Hi David, (B (BThank you for the detailed description. That certainly makes things easier to (Bargue now ;-). (B (BO.K Where to start ? (B (BFirst, as you know in version 4.0 you can basically set the character sets (Bonly for server and client side (not for DB, table, columns, connection

Re: priviledges newbie

Fajar Priyanto <[EMAIL PROTECTED]> wrote: > Hi all, > Can I create a user that can create and drop his database while at the same= > time can not drop databases that are not belong to him? > How do I set this priviledge? If you grant CREATE and DROP privileges on the dbname, it means that user can

RE: GRANT to DB access

You can accomplish it without granting everyone root privileges. Just create user accounts and grant them the right to create a database and to have full access to their own (NOT ALL databases on the server!) databases. Babs ||> -Original Message- ||> From: Ron Gilbert [mailto:[EMAIL PR

Problems compiling NDB-Cluster mysql-4.1.2

Hello all, i want to compile the development tree source from bk://mysql.bkbits.net/mysql-4.1 on SuSE 8.2 Linux. The compiling of the mysql-4.1 without the ndb-cluster works fine. When set the configuration-option --with-ndbcluster, the compilation fails with the error: ha_ndbcluster.o(.text+0x3

Access denied for user: 'root@localhost'

Hi All, I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time seemed to actually got somewhere! however, my existing PHP scripts failed to connect to localhost as the password has not been set after the install. I ran the following command (obviously seriously misunderstood t

comparison of timestamps

There must be a simple reason for this, but I am really stumped. Look at this: mysql> select last from users where last > 200400 limit 10; ++ | last | ++ | 20040426191837 | | 20040504191410 | | 20040430170916 | | 20040424005350 | | 20040504192210

Re: how to uninstall mysql

"adam" <[EMAIL PROTECTED]> wrote: > I have installed MySql on RH Linux, however since I have installed in the > wrong location I would like to uninstall. > > Basically I have installed the binary version from the > "mysql-standard-4.0.18-pc-linux-i686.tar.gz" and > > I have followed the instructio

Re: priviledges newbie

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks Egor, It works. But it seems that it's not 100% automatically just like unix file permission. The administrator must set it up on each database. So, I give the users CREATE privilege globally, but not DROP. It will prevent them from messing ar

Re: Access denied for user: 'root@localhost'

"Phil Ewington - 43 Plc" <[EMAIL PROTECTED]> wrote: > Hi All, > > I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time > seemed to actually got somewhere! however, my existing PHP scripts failed to > connect to localhost as the password has not been set after the install. I

INSERT into HEAP table

Hi All! We use MySQL 3.23.54 on ReadHat 8.0. What error code is returned for inserting into heat table over memory(row) limit? Many thanks! Vladimir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: INSERT into HEAP table

"Vladimir Romanovski" <[EMAIL PROTECTED]> wrote: > Hi All! > > We use MySQL 3.23.54 on ReadHat 8.0. > What error code is returned for inserting into heat table over > memory(row) limit? > > You will get something like: ERROR 1114 : The table 'tbl_name' is full -- For technical sup

'drop database' failing silently?

Hi all, this morning, I had a problem dropping a database from within mysql. mysql> drop database mis; Query OK, 0 rows affected (0.00 sec) mysql> show databases; +--+ | Database | +--+ | mis | | mysql| +--+ 2 rows in

Re: InnoDB - Foreign Key - Error 150.

"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote: > Victoria=20 > > That seemed to work well, thank you. > > However, I received another error that I am not sure how to troubleshoot = > during the restore: >ERROR 1114 at line 83 in file: = > '/bb/bin/mysql/backups/archive_4320.sql': The table

Re: 'drop database' failing silently?

Kevin O' Riordan <[EMAIL PROTECTED]> wrote: > this morning, I had a problem dropping a database from within mysql. > >mysql> drop database mis; >Query OK, 0 rows affected (0.00 sec) > >mysql> show databases; >+--+ >| Database | >+--+ >| mis | >

RE: Export query to text file

mysql -uuser -N -e"select date_format('2004-02-29','%X')" > sample2.txt -Original Message- From: Yingyos To: Victor Pendleton Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 5/4/04 11:04 PM Subject: Re: Export query to text file Victor Pendleton wrote: >The `INTO OUTFILE` clause is expec

Re: 'drop database' failing silently?

> > this morning, I had a problem dropping a database from within mysql. > Are there any non-mysql files in the directory of the database 'mis'? Should've added this. There was only one file in the 'mis' directory: -rw-rw-rw-1 mysqlmysql 44 Apr 30 09:51 file.out Which con

Re: Backup strategy

On Tue, 04 May 2004 14:44:26 -0700 Ron Gilbert <[EMAIL PROTECTED]> wrote: > Is there a better way to be doing this given the huge amount of > binary data I have? You may wish to also look into replication, which is a cinch to setup with MySQL. Josh -- MySQL General Mailing List For list archiv

Re: 'drop database' failing silently? - solved.

> > this morning, I had a problem dropping a database from within mysql. [snip] > > The solution I used was to stop mysqld and then rm the database from the > > filesystem. > Are there any non-mysql files in the directory of the database 'mis'? After a while, I realised you weren't asking a ques

Re: DBD::MySQL on RH8

On Mon, 3 May 2004, Leon Sonntag wrote: > I am having problems with installing the DBD::MySQL Perl module. My system > is: RedHat 8 (patched current) Perl 5.8.4 (installed from RPM but upgraded > manually) Apache 2.0.40 Modperl 1.99 > > I am heading toward being able to install Best Practicals "

optimization needed

Hi All! We use MySQL 3.23.54 on dual-processor DELL running ReadHat 8.0 . Performance of operations with one of the tables is very low . For example : mysql> select count(*) from protocol; +--+ | count(*) | +--+ | 2266 | +--+ 1 row in set (28.93 sec) The table is creat

MySQL 100% CPU Spikes

Hi, I recently installed MySQL on a Windows 2003 Server last night to pull some stats from a online game I run, however everytime a query is sent to the database it uses 100% cpu causing a 100% cpu spike for a breif second - I'm using .asp pages if that helps. Is there anyway to avoid this at all

RE: comparison of timestamps

My guess is because 200400 is an illegal time. If you try a legal time, January 1, midnight (2004010100) it should work. You can also convert the time to integer and then compare values. select last from users where last > 2004010100 select last from users where cast(last as SIGNE

MySQL Control Center - One quick question...

One quick question here. I just installed the MySQL Control Center and get the "host not allowed" connection error. So, do the database have to exist on MySQL Server and set-up permission for that database in order for MySQL Control Center's connection to work?? I'm new here as I switched fro

Range query on datetime with index - any optimization?

Hello folks, I'm usinng MySQL 4.0.17. I have a table something like: RuleID int, GMTBase datetime, Credited bigint, ... I have an index built on GMTBase. I have rougly 8 million rows. GMTBase stores a datetime for the top of the hour on a given date. I want to build a summary of the last 2 days

if exists

Hello I'm looking for something like if not exists( select 1 from PERSON where NAME = 'Test' ) then insert into PERSON ( NAME ) values ( 'Test'); end if; I did it with Sybase Database. I need to get Data from Excel and have to be shure that there is no data more than once in the table. So I

RE: if exists

Silently ignore duplicate index inserts... insert IGNORE into PERSON ( NAME ) values ( 'Test') Ed -Original Message- From: Gerhard Gaupp [mailto:[EMAIL PROTECTED] Hello I'm looking for something like if not exists( select 1 from PERSON where NAME = 'Test' ) then insert into PERSON (

Re: DBD::MySQL on RH8

At 08:04 AM 5/5/04, Rudy Lippan wrote: On Mon, 3 May 2004, Leon Sonntag wrote: > I am having problems with installing the DBD::MySQL Perl module. My system > is: RedHat 8 (patched current) Perl 5.8.4 (installed from RPM but upgraded > manually) Apache 2.0.40 Modperl 1.99 > > I am heading toward b

Re: if exists

At 12:12 +0200 5/5/04, Gerhard Gaupp wrote: Hello I'm looking for something like if not exists( select 1 from PERSON where NAME = 'Test' ) then insert into PERSON ( NAME ) values ( 'Test'); end if; I did it with Sybase Database. I need to get Data from Excel and have to be shure that there is

Re: if exists

I think this is half the answer (though you've implied the other half). First, you prevent mysql from accepting duplicate rows by defining a PRIMARY KEY or UNIQUE INDEX on whatever column or columns determine uniqueness. See for the details.

Html and mysql..

Hi all, I have got one serious doubt. Can we access mysql database from the front end html. If it all it is possible, we have to right in javascript. ofcourse we can write it using JDBC(provided we have a servlet engine integrated with a webserver). My question is can we access mysql database f

DISTINCT DATETIME question

I am trying to get a distinct dates (not time) from a column. I am currently doing this: SELECT DISTINCT DATE_FORMAT(DateAdded, '%Y-%m-%d') FROM Bla Is this the best way to be doing this? Seems very inefficient do to the call to DATE_FORMAT for every row. Is there a way to have a query only

Re: Html and mysql..

Javascript is a client side language. I seriously doubt it alone would do anything for you. My Sql <[EMAIL PROTECTED]> 05/05/2004 12:18 PM To: [EMAIL PROTECTED] cc: Subject:Html and mysql.. Hi all, I have got one serious doubt. Can we access mysql dat

Re: Html and mysql..

On Wed, 5 May 2004 09:18:01 -0700 (PDT) My Sql <[EMAIL PROTECTED]> wrote: > Hi all, > I have got one serious doubt. > Can we access mysql database from the front end html. If it all it > is possible, we have to right in javascript. ofcourse we can write > it using JDBC(provided we have a servlet

Replication Issue

Hello, Why such a SQL request running well on the master is not correctly replicated on the slave, set @providerId='012345'; insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1); Here is an extract of the Slave Logfile: MYBCK.log.1:ERROR: 1048 Column 'PROVIDER_ID' cannot be null MYBCK.

Is there a way to make mysql sgml aware?

Hi folks, Is there a way to make mysql sgml aware or any plan to do it in the near time? Leonardo J. Belen mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql quer

Re: Replication Issue

On Wed, May 05, 2004 at 06:44:09PM +0200, Mechain Marc wrote: > Hello, > > Why such a SQL request running well on the master is not correctly replicated on the > slave, > > set @providerId='012345'; > insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1); > > Here is an extract of the Sla

Re: optimization needed

Basically, you can't, it's a limitation of the InnoDB format. If you change the table type to MyISAM, that query would be almost instantaneous. But you are probably using InnoDB for a reason, so you may be stuck if you want a record count. On May 5, 2004, at 10:01 AM, Vladimir Romanovski wrote:

Re: MySQL 100% CPU Spikes

On Wed, May 05, 2004 at 03:25:14PM +0100, Nick A. Sugiero wrote: > Hi, > > I recently installed MySQL on a Windows 2003 Server last night to pull some > stats from a online game I run, however everytime a query is sent to the > database it uses 100% cpu causing a 100% cpu spike for a breif second

Re: MySQL 100% CPU Spikes

Jeremy, Any information on how I can go about doing this, or maybe some documentation on improving the speed. The problem is two of the databases I think, both are around 1.1MB each and: Database1: 13736 data records Database2: 77312 data records. Is this excessive ? When my .asp pages request

Use of AVG in where clause

Hello, I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE AVG(DB_GRADE) > 2 GROUP BY ES.DB_

RE: Html and mysql..

Depending on who your intended audience is and what you are attempting to achieve two possibilities are using LiveWire, http://developer.netscape.com/viewsource/kuslich_javascript.html, or you could use Applets that talk to servlets, http://www.onjava.com/pub/a/onjava/2002/02/20/applets.html.

Re: MySQL 100% CPU Spikes

You may be able to limit resource usage for mysql. I am not sure how to do it in windows though. 100% for a second while it executes the query is not abnormal in my opinion. "Nick A. Sugiero" <[EMAIL PROTECTED]> 05/05/2004 01:12 PM To: <[EMAIL PROTECTED]> cc:

Re: Backup strategy

>You may wish to also look into replication, which is a cinch to setup >with MySQL. Unfortunately replication does not handle point in time recovery. This is usually required to happen when someone accidentally drops a table or deletes too many rows from the database inadvertently. Under replica

Re: Range query on datetime with index - any optimization?

I wonder if mysql isn't trying to process where GMTBase > DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY) What about doing this date subtracting in PHP and adding the result to the SQL statement. > Hello folks, > > I'm usinng MySQL 4.0.17. > > I have a table something like: > > RuleID int, > GMTBase da

Re: Use of AVG in where clause

At 19:12 +0200 5/5/04, Julien Martin wrote: Hello, I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE AVG(DB_G

Re: Use of AVG in where clause

On Wed, 5 May 2004 19:12:00 +0200 Julien Martin <[EMAIL PROTECTED]> wrote: > Hello, > > I have a sql query as follows: > > ** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON > ES.DB_

Two way replication lock protocol

Hello, I am wondering if anyone is currently working on a two way replication lock protocol. If so, what's the status. I understand there's little gain in having two way replication but -- I am just curious. If no one is working on it, I may poke at it. Luis -- GnuPG Key fingerprint

RE: Use of AVG in where clause

Your where clause is confusion. Are you wanting to retrieve rows where the DB_Grade is greater than 2? AVG(DB_GRADE) is not a valid restriction. Are you wanting HAVING AVG(DB_GRADE) > 2 ? -Original Message- From: Julien Martin To: '[EMAIL PROTECTED]' Sent: 5/5/04 12:12 PM Subject: Use of A

AVG function in order by clause

Hello, Thanks a lot for the replies. I have changed the query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID GROUP BY ES.D

Re: Use of AVG in where clause

I believe you have to add your AVG() to your GROUP BY clause. > I have a sql query as follows: > > ** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON > ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_I

Re: Use of AVG in where clause

Julien Martin <[EMAIL PROTECTED]> wrote: >I have a sql query as follows: > >** >SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > >FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON >ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID > >WHERE > AV

RE: AVG function in order by clause

What kind of problem are you having? You can use the ordinal postion. ORDER BY 2 [ASC|DESC]. 2 represents the second column. -Original Message- From: Julien Martin To: '[EMAIL PROTECTED]' Sent: 5/5/04 12:41 PM Subject: AVG function in order by clause Hello, Thanks a lot for the replies.

RE: MySQL Control Center - One quick question...

The simple answer is "yes". You need to read chapters 4 & 5 in the Mysql manual, You can download it as a PDF from the documentation page of developer resources. I'm assuming you're installing from a binary rpm? You then need to run the install_mysql_db script, start the server using mysqld_safe,

AVG function in order by clause

Thank you all for your replies. Everything works now!! Julien. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AVG function in order by clause

On Wed, 5 May 2004 19:41:32 +0200 Julien Martin <[EMAIL PROTECTED]> wrote: > Hello, > > Thanks a lot for the replies. I have changed the query as follows: > > ** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES L

Re: AVG function in order by clause

In Oracle you can reference the second field AVG() by the field #. ORDER BY 2 > Thanks a lot for the replies. I have changed the query as follows: > > ** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES

Re: AVG function in order by clause

Pretty simple, declare an alias in your query and use it in the ORDER BY, i.e.:   SELECT  DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) AS AVGGRADEFROM  ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ONES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_IDGROUP BY  ES.DB_ESTABLISHMENT_IDHAVING  AVG(DB_GRADE) > 2ORDER B

Title Case

Hi All, I have a table with upper case text. I want to use a function in my select statement the puts this text in title case so "MORE FOO YOU WIBBLE" becomes "More Foo You Wibble". Thanks for any help Cheers, Andrew Sql, query -- MySQL General Mailing List For list archives: http://lis

Re: Backup strategy

On Tue, May 04, 2004 at 02:44:26PM -0700, Ron Gilbert wrote: > > I am wondering what the best backup strategy is for my database. > > The database is used to store a very large number of binary files, > ranging from a few K to 20MB's. The database stores thousands of these > files. I can not

Title Case Problem

Hi All, I have a table with upper case text. I want to use a function in my select statement the puts this text in title case so "MORE FOO YOU WIBBLE" becomes "More Foo You Wibble". Thanks for any help Cheers, Andrew Sql, query -- MySQL General Mailing List For list archives: http://lis

Re: Range query on datetime with index - any optimization?

At 01:30 PM 5/5/2004, Daniel Clark wrote: I wonder if mysql isn't trying to process where GMTBase > DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY) What about doing this date subtracting in PHP and adding the result to the SQL statement. Nice try - but it's not the problem. Replacing the equation with a c

Re: MySQL 100% CPU Spikes

Nick A. Sugiero wrote: Jeremy, Any information on how I can go about doing this, or maybe some documentation on improving the speed. The problem is two of the databases I think, both are around 1.1MB each and: Database1: 13736 data records Database2: 77312 data records. Is this excessive ? Nick:

Re: optimization needed

Brent Baisley wrote: Basically, you can't, it's a limitation of the InnoDB format. If you change the table type to MyISAM, that query would be almost instantaneous. But you are probably using InnoDB for a reason, so you may be stuck if you want a record count. As Brent said, there is no way to o

Re: MySQL hotcopy problem (poor man's replication)

Andrew Loughe wrote: Hello, MySQL version: 3.23.58 Each week I make a hotcopy of numerous database files. I tar them and gzip them, and move them to an archive machine. I then use a second machine to read from the archive, untar and ungzip the files, and presto! I have exact copies of my database

RE: mysqld too busy to check its grant tables?

What versions are you seeing this on? We've seen it exclusively on 3.23.58, with or without LinuxThreads enabled. See: http://lists.mysql.com/mysql/164717 Atle - Flying Crocodile Inc, Junior Unix Systems Administrator On Mon, 26 Apr 2004, Donny Simonton wrote: > Jeremy, > We have also seen the

Re: Is there a way to make mysql sgml aware?

On Wed, May 05, 2004 at 02:00:31PM -0300, Leonardo Javier Belén wrote: > Hi folks, > Is there a way to make mysql sgml aware or any plan to do it in the near > time? I think the answer is "no" but I don't really know what that question means. Can you elaborate? Jeremy -- Jeremy D. Zawodny

Re: Title Case

In the last episode (May 05), Andrew Braithwaite said: > I have a table with upper case text. I want to use a function in my > select statement the puts this text in title case so "MORE FOO YOU > WIBBLE" becomes "More Foo You Wibble". MySQL doesn't provides a function to do that. If you know C,

Re: MySQL 100% CPU Spikes

>Any information on how I can go about doing this, or maybe some >documentation on improving the speed. >The problem is two of the databases I think, both are around 1.1MB each and: Try putting an explain before your select statement: http://dev.mysql.com/doc/mysql/en/EXPLAIN.html this will sho

Re: mysqld too busy to check its grant tables?

On Wednesday, May 5, 2004, at 11:48 US/Pacific, Atle wrote: What versions are you seeing this on? We've seen it exclusively on 3.23.58, with or without LinuxThreads enabled. Various versions of 4.0.xx. We don't run 3.23.xx much of anywhere anymore. Jeremy -- MySQL General Mailing List For list

Re: Range query on datetime with index - any optimization?

On Wed, May 05, 2004 at 10:53:13AM -0400, Pete McNeil wrote: > Hello folks, > > I'm usinng MySQL 4.0.17. > > I have a table something like: > > RuleID int, > GMTBase datetime, > Credited bigint, > ... > > I have an index built on GMTBase. > I have rougly 8 million rows. > > GMTBase stores a da

Re: Two way replication lock protocol

On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote: > > Hello, > > I am wondering if anyone is currently working on a two way replication > lock protocol. If so, what's the status. I understand there's little > gain in having two way replication but -- I am just curious. What exa

GRANT to DB access

Is there a way to create a GRANT for a DB so that only one user can access to the database? The only way I can see to do it involves taking every user and GRANT them access to every other database, but not this one. The problem I face is that I share a server with three friends, and we all cr

mysql_install_db.sh mini patch

Hi, I tried to install 4.1 (Bitkeeper tree) on SPARC Solaris 9 today. There is a line in mysql_install_db that is bash-specific and does not run with /bin/sh (at least not on my system): # scripts/mysql_install_db Installing all prepared tables scripts/mysql_install_db: syntax error at line 215

Re: MySQL 100% CPU Spikes

Did I miss something, or is this not concerning a 1 second spike to 100%? I do not see why this is problematic, and I'm a bit curious as to how it is... I mean, the DB does use 100% CPU if it's available. And for a 1 second period, it could very well just be the sample time for the tool monitor

Complicated query problem

I've got the following query that produces a large table for me. SELECT router.name AS Router, SUM(IF(speed<='64000',1,0)) AS 64K, SUM(IF(speed='128000',1,0)) AS 128K, SUM(IF(speed='192000',1,0)) AS 192K, SUM(IF(speed='256000',1,0)) AS 256K, SUM(IF(speed='384000',1,0)) AS 3

RE: Title Case Problem

I may be wrong, but there isn't an easy method for completing this in SQL alone. If you're using PHP, process the field with ucwords( ) http://www.php.net/ucwords on the other hand, capwords() in Python does something similar, but replaces multiple spaces with individual spaces. --bmansell -

Re: Two way replication lock protocol

On Wed, May 05, 2004 at 12:01:27PM -0700, Jeremy Zawodny wrote: > On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote: > > > > Hello, > > > > I am wondering if anyone is currently working on a two way replication > > lock protocol. If so, what's the status. I understand there's litt

Re: AVG function in order by clause

At 19:41 +0200 5/5/04, Julien Martin wrote: Hello, Thanks a lot for the replies. I have changed the query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_EST

RE: Title Case Problem

Use INITCAP. SELECT name, INITCAP(name) new_name FROM customer WHERE firstname IS NULL *** REPLY SEPARATOR *** On 5/5/2004 at 12:43 PM Brian Mansell wrote: >I may be wrong, but there isn't an easy method for completing this in >SQL alone. -- MySQL General Mailing List

RE: Title Case Problem

As far as I know INITCAP() isn't a valid function in MySQL. I believe it is supported in Oracle (sqlplus). --bmansell -Original Message- From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 1:00 PM To: [EMAIL PROTECTED] Subject: RE: Title Case Problem Us

Re: Html and mysql..

Josh Trutwin writes: >Javascript is a client-side language, the code is executed by the user's >browser. It has no way to connect to the database server and run queries >so you need to use a server-side programming language like Java (JDBC), >PhP, Perl, etc. Tomcat is a decent servlet engine with

Data dump using perl with mysql won't update

before I begin sorry for the cross post but i'm desperate The routine in question is below. It's pretty straight forward its a series of loops which basically matches the row then dumps data stored in hash ref into the DB. for some reason the script runs with no errors (ran with strict) I can ve

Re: Complicated query problem

>The query as written works just fine although I'm certain there's got to be >a more efficient way of doing the same thing. I'm relatively new to MySQL >so I took the brute force approach. > >My problem is that I want to produce totals of each of the columns and can't >figure out how to do it. An

into outfile

hi, when i use the into outfile query in mysql to put the records in a text file, and when i open the file that the records are stored in, i dont see each record on one line. each record is seperated by the square symbol. Is there a way in mysql that i can specify that i need one record per l

Re: Is there a way to make mysql sgml aware?

At 11:48 -0700 5/5/04, Jeremy Zawodny wrote: On Wed, May 05, 2004 at 02:00:31PM -0300, Leonardo Javier Belén wrote: Hi folks, Is there a way to make mysql sgml aware or any plan to do it in the near time? I think the answer is "no" but I don't really know what that question means. Can you

Re: Two way replication lock protocol

On Wed, May 05, 2004 at 03:44:00PM -0400, Luis R. Rodriguez wrote: > On Wed, May 05, 2004 at 12:01:27PM -0700, Jeremy Zawodny wrote: > > On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote: > > > > > > Hello, > > > > > > I am wondering if anyone is currently working on a two way rep

Re: Data dump using perl with mysql won't update

At 15:02 -0700 5/5/04, [EMAIL PROTECTED] wrote: before I begin sorry for the cross post but i'm desperate The routine in question is below. It's pretty straight forward its a series of loops which basically matches the row then dumps data stored in hash ref into the DB. for some reason the script

Re: into outfile

At 18:25 -0400 5/5/04, [EMAIL PROTECTED] wrote: hi, when i use the into outfile query in mysql to put the records in a text file, and when i open the file that the records are stored in, i dont see each record on one line. each record is seperated by the square symbol. Is there a way in mysql th

Re: Data dump using perl with mysql won't update

> If you want them set to NULL using DBI, you have to bind undef to the > proper parameter. Is that what you're doing, or are you binding > something else, such as 0 or the empty string? > No the initial values in the DB are set to null, with the exception of one field. I'm trying to assign th

Should I trust my data after an InnoDB recovery?

Hi all. My boss just pulled the power on our MySQL server. Yes, I've already thanked him. It's a 4.0.18 server, with MyISAM tables and InnoDB tables, running on a 2.6.5 kernel and XFS filesystem. The XFS recovery proceeded without any complaints. The InnoDB recovery also seemed to go smoothl

Re: Should I trust my data after an InnoDB recovery?

On Thu, May 06, 2004 at 09:55:30AM +1000, Daniel Kasak wrote: > Hi all. > > My boss just pulled the power on our MySQL server. > Yes, I've already thanked him. > > It's a 4.0.18 server, with MyISAM tables and InnoDB tables, running on a > 2.6.5 kernel and XFS filesystem. > > The XFS recovery pr

can't load library

Greets I have installed mysql 4.0.18 on an OpenBSD 3.4 box using the D/L from the mysql.com site. All compiled / installed well and in fact nearly everything works. The problem I have is when attempting to use mysql I get the following error. mysql: can't load library ../libmysql/.libs/libmysq

Please Help ! this might be simple but not for me :(

Hi All Perl Gurus ! I'm in the middle of this and i'm not able to figure out what is wrong ! I have a html file and i want to do a grep for the accourance of " -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

Importing Fixed Length Text Files

Hello All, Maybe I am not searching the documentation correctly or am I correct in finding there is not method of directing importing a fixed length text file into a MySQL table? I hope I just missed the reference. Could someone point me to it. Any assistance is greatly appreciated. Allen

Last inserted ID

Hi there, I seem to be having a problem retrieving the last inserted ID for a table. The query I am using is as follows: mysql> select distinct LAST_INSERT_ID() as LastID from listings; ++ | LastID | ++ | 3575 | ++ 1 row in set (0.00 sec) However, when I run this from

Re: Importing Fixed Length Text Files

Allen Weeks wrote: Hello All, Maybe I am not searching the documentation correctly or am I correct in finding there is not method of directing importing a fixed length text file into a MySQL table? I hope I just missed the reference. Could someone point me to it. Any assistance is greatl

Re: Last inserted ID

Well, you don't need the distinct. Are you inserting with your PHP script? LAST_INSERT_ID(), as per the manual, only returns the id from the last insert on that connect. You cannot get the LAST_INSERT_ID() for another connection. j- k- On Wednesday 05 May 2004 05:11 pm, Erich Beyrent

Re: Last inserted ID

Erich Beyrent wrote: Hi there, I seem to be having a problem retrieving the last inserted ID for a table. The query I am using is as follows: mysql> select distinct LAST_INSERT_ID() as LastID from listings; ++ | LastID | ++ | 3575 | ++ 1 row in set (0.00 sec) Ho

Re: Last inserted ID

At 21:11 -0400 5/5/04, Erich Beyrent wrote: Hi there, I seem to be having a problem retrieving the last inserted ID for a table. The query I am using is as follows: mysql> select distinct LAST_INSERT_ID() as LastID from listings; This can be simplified as SELECT LAST_INSERT_ID as LastID; no need

  1   2   >