XML support in MySQL

Hi! Is it possible to load,retrieve,query data from MySQL thru XML data structures? I've gone thru the MySQL manual but, no mention of it. Please point me to the right direction. Uday - Before posting, please check:

Re: Mysql Limit

Arvin Bautista wrote: I'm new to mysql/sql thing thus mysql can efficiently handles a database even it has a hundred tables Yes, but you need to make sure to set your table cache large enough to cache all these tables to stay fast. This is for MyISAM tables, the default. BDB supposedly

Re: ORDER BY total of multiple columns?

foo wrote: Hi, I have a mysql table with columns pts_t2, pts_ext and pts_other which hold each player's point total for that category. I have it displaying player's ranks by ordering by each of those points. However, I would like to have an overall ranking (all categories combined), and

Re: Full Search

Yes, you can add a FULLTEXT index to that table including all 15 fields, e.g. CREATE FULLTEXT INDEX findtext ON mytable (field1, field2, field3,...field15); Caveats: The fields must be of type VARCHAR or TEXT to work, (CHAR can be changed to VARCHAR easily, and often is silently changed.)

Re: Question about Fulltext searches/GWS_IDF

Hi! On Jan 02, Shane Allen wrote: I checked the archives for this list and saw that in 2000 Sergei recommended changing GWS_IN_USE to GWS_IDF to disable the 50% weighting mechanism. The MySQL manual, however says to change it from GWS_PROB to GWS_FREQ. I'm inclined to go with the

Re: Automated Failover

Hi Greg! Due to budget restraints (and the fact that I'm sick of every system here being a proprietary, closed source system that I can't even configure without the vendor holding my hand because they refuse to document anything) I've decided to implement the system using Linux and mySQL.

Problème avec le logiciel client mysql windows

Bonjour, J'utilise MySQL avec Apache et php-4.0.6 sous windows 95, 2000 et Linux, Dans ma base de données, j'ai des données avec des caractères accentués. Lorsque je crée ma base de données avec le client MySQL (programme mysql) sous Linux et que j'y accède en mode web ( via Apache et php-4.0.6)

Re: Problème avec le logiciel client mysql windows

Si je crée ma base de données avec le client MySQL (programme mysql) sous Windows et que j'y accède en mode web ( via Apache et php-4.0.6) je perds les caractères accentués. La conclusion est qu'il y a un bug dans le programme client mysql sous windows.Pouvez vous me le confirmer? En

MySql help required

Hi, Does the mysql support internationalisation?. If so, Kindly let me know what settings I need to configure to insert korean strings into the table and retrieve the same and show it in a browser(jsp page)?. Is there any GUI tool for mysql(like Toad for Oracle)?. if so where can I get that?.

Re: FOREIGN KEYs and ALTER TABLE

Hi! With InnoDB tables under 3.23.4x, if you perform an ALTER TABLE on a table, any foreign key declarations that point to that table fail to work (they always return a failure). Is this a known bug? I don't see it on the InnoDB todo or bug list, but I seem to remember hearing about it

Re: 3.23.47 compile problems with sun's forte compiler

Shakeel Sorathia writes: I just downloaded the 3.23.47 source for mysql, and I tried to compile it using Sun's Forte Compiler (6.2) however when trying to build libmysql/hash.c I got the following error. /opt/SUNWspro/bin/cc -DDEFAULT_CHARSET_HOME=\/opt/mysql/3.23.44\

Re: XML support in MySQL

Hello udayashankarl_n, Thursday, January 03, 2002, 4:12:11 PM, you wrote: There is no mechanism to manage it alike to SQL , for it needs many knowledge such as schema discovery for semi-stru data and so on , and it is more complex . -- Best regards, isp01ljl

RE: Full Search

And, alas, by the time MySQL finishes building my 500 MB fulltext index (more than 12 hours) the table is throroughly corrupted, and myisamchk can't even recover it with -o. I'm waiting for 4.01 to go beta, and will then give it a try to see if things are happier there. Tom Haapanen [EMAIL

GRANT/REVOKE

I use debian 2.2.19 my customer wants me MySql support. I want to give the customer only this right: INSERT, DELETE, UPDATE, SELECT, INDEX, CREATE. But create: is a danger command as you know like process the other. I must limit create right on a db_customer. HOW?? I did for a long time..

mysql on AIX RS6000

Hi, I have aproblem with mysql. I tried to install the Binary version 3.23 and 4.01 for AIX. 1.) I did gzip -d the gz-file 2.) tar -xvf the tar file 3.) I executed the command ( safe_mysqld in Verison 3.23 ), mysqld_safe ( in Verison 4.0.1 ) and did get the message below:

Re: FOREIGN KEYs and ALTER TABLE

On Thu, Jan 03, 2002 at 01:48:21PM +0200, Heikki Tuuri wrote: : Hi! : : This is a feature (= documented bug). Look at : http://www.innodb.com/ibman.html: : ... : Updated December 13, 2001: Added a note that you should not do an ALTER : TABLE to a table which has or is referenced in a foreign key

Remove PRIMARY KEY attribute

Hi the list, I use MyISAM tables. How to remove the primary key attribute from a column, without removing the column itself ? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: 3.23.47 compile problems with sun's forte compiler

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Shakeel Sorathia writes: I just downloaded the 3.23.47 source for mysql, and I tried to compile it using Sun's Forte Compiler (6.2) however when trying to build libmysql/hash.c I got the following error. cut -DPIC -o

Removing duplicate entries

Hello, I was wondering how would it be possible to delete those records from database which has just same data? There can be also up to ten copies of the record in database, and all but one should be deleted. Do you have any easy way to do this? Thank you, Ville Mattila

RE: Removing duplicate entries

Hi A long hand way to do this is use count to find out how many times this happens. Then use limit to one less than count? Hope this helps Simon -Original Message- From: Ville Mattila [mailto:[EMAIL PROTECTED]] Sent: 03 January 2002 15:03 To: [EMAIL PROTECTED] Subject: Removing

Re: FOREIGN KEYs and ALTER TABLE

Hi! -Original Message- From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, January 03, 2002 3:21 PM Subject: Re: FOREIGN KEYs and ALTER TABLE On Thu, Jan 03, 2002 at 01:48:21PM +0200, Heikki Tuuri wrote: : Hi!

MySQL on Valueweb Server - Max number of fields

Hello there, I have recently started fiddling with bringing data online so it can be searchable from our web site, but am running into problems. I have a table with about 3900 records. The table consists of 7 fields (columns), and goes like this : Id, name, address, address cont'd, city, state,

RE: Removing duplicate entries

* Ville Mattila I was wondering how would it be possible to delete those records from database which has just same data? There can be also up to ten copies of the record in database, and all but one should be deleted. Do you have any easy way to do this? You could do it by creating a new

left join

Hi everyone, I ran a query which is: select A.a as a,B.b as b from A left join B on A.c=B.c and A.d=B.d order by A.c,A.d; Both table A and Table B have about 3000 records.And there are about 3000 records in the result.But it takes 3 minutes and 50 seconds to run the query. Does anybody know how

Re: FOREIGN KEYs and ALTER TABLE

Hrmm. Is that a feature that's planned to be fixed. Obviously, if you have a table with thousands or millions of rows in it, ALTER TABLE is a lot easier than copying the table to a temp table, dropping the original table, creating a new table, and copying the data back in. Actually,

Re: MySQL on Valueweb Server - Max number of fields

From: Tom Strom [EMAIL PROTECTED] I have a table with about 3900 records. The table consists of 7 fields... ...Id, name, address, address cont'd, city, state, phone#. I don't actually know anything about WinMysqlPro, but maybe I can help set up some of the base information that we'll need.

Replication between MSSQL and mySQL

Hi All I am not very experienced in databases so excuse me if the question is a bit weird. We have a SQL2000 database (about 15GB) and we want to develop some webapplications to present the content. We dont want to use the current DB-server but insted make a replica to run the application on,

Re: FOREIGN KEYs and ALTER TABLE

On Thu, Jan 03, 2002 at 05:21:49PM +0200, Heikki Tuuri wrote: : mysql CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; : Query OK, 0 rows affected (0.11 sec) : : mysql CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), : - FOREIGN KEY

Re: left join

On Thu, 03 Jan 2002 09:21:45 -0600, Dan Liu used a few recycled electrons to form: | Hi everyone, | I ran a query which is: | select A.a as a,B.b as b from A left join B on A.c=B.c and A.d=B.d order by A.c,A.d; | Both table A and Table B have about 3000 records.And there are about 3000 records

SSH tunnel MySQL traffic: BOTH remote local?

If I've got one computer with MySQL client and server on it, running everything localhost, but I want to reach out to another MySQL server, through an SSH tunnel, for some things, does anyone know how to differentiate between the two? Usually, for SSH tunnelling, you access a port # at

RE: SSH tunnel MySQL traffic: BOTH remote local?

Using the -h hostname or IP should do it. mysql -h 10.129.0.2 -u user -p password yadayadayada -Original Message- From: MySQL baby [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: SSH tunnel MySQL traffic: BOTH remote local? If I've

Re: Replication between MSSQL and mySQL

Anything is possible, this will depend on your situation. If you just want to replicate the data once, you can dump it all in text format (say, tab-separated fields, CRLF-separated records) onto a few CDs, and import them into MySQL using mysqlimport. If you have the two machines networked,

Re: SSH tunnel MySQL traffic: BOTH remote local?

You use a different port # for the tunnel. MySQL baby wrote: If I've got one computer with MySQL client and server on it, running everything localhost, but I want to reach out to another MySQL server, through an SSH tunnel, for some things, does anyone know how to differentiate

Updating tables via cron

I tried to search the archives for this but I can't find it. (Not saying it isn't there just I could not find it.) I have a table that tracks events on a monthly and daily basis. Currently I am resetting the appropriate fields to 0 on a daily and monthly basis (not fun). Is there a

RE: Remove PRIMARY KEY attribute

ALTER TABLE mytable DROP PRIMARY KEY; -Original Message- From: TOMASSONI Dominique [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 8:34 AM To: 'MySQL_mailing_list' Subject: Remove PRIMARY KEY attribute Hi the list, I use MyISAM tables. How to remove the primary key

RE: Updating tables via cron

Here is a select statement, as example: mysql -e select * from user \G mysql Add user and password as required. Xi2 ('sE-'tü) -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 8:57 AM To: [EMAIL PROTECTED] Subject: Updating tables

RE: Updating tables via cron

Try this: echo REPLACE INTO table_name (dr) VALUES ('0'); | /usr/local/mysql/bin/mysql -u user -p password activity or mysql -e REPLACE INTO table_name (dr) VALUES ('0'); activity -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 10:57 AM

RE: SSH tunnel MySQL traffic: BOTH remote local?

Try mapping your remote mysql to a different local port, then specify that port number when you connect. For example: 'ssh -L 3307:hostip:3306 hostname' will map port 3306 on the remote machine to port 3307 on your local machine. Then, use 'mysql -P 3307 -u x -p etc.' to connect to port 3307

PASSWORD function

Dear friends, I am quite new to MySql and database development in general. I am doing my first db ever. I came across a problem following the instructios in teh book beginning PHP4 by Wankyu et al., Wrox. The exercise is to create a user table, contaning user id?s and passwords. The

RE: SSH tunnel MySQL traffic: BOTH remote local?

Yeah, you could use SSH to forward local port or some other random port to the remote 3306, with something like: ssh -N -f -L :otherserverhostname:3306 jshmoe@otherserverhostname. Then to connect to the other machine via the ssh tunnel, run the client and connect to that port on

RE: PASSWORD function

It works fine for me. How big is your password field in the table? It should be: char(16) -Original Message- From: Jose Alvarez [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 11:35 AM To: [EMAIL PROTECTED] Subject: PASSWORD function Dear friends, I am quite new to MySql

Re: SSL connection question Again!

Mysql gurus: I have anxiously been watching the list for a response to this question, but still no joy. Does anyone have information on how to make an ssl connection with the mysql client? I have support compiled into the server, but unfortunately I cant find any documentation on the client side.

RE: MySQL on Valueweb Server - Max number of fields

What does your CREATE TABLE statement look like? That's where the error would be. -Original Message- From: Tom Strom [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 9:18 AM To: [EMAIL PROTECTED] Subject: MySQL on Valueweb Server - Max number of fields Hello there, I have

Big Problem...Need Help Quick

I apologize for cross post; however this poster is not on MYSQL list and he needs help. He executed DROP TABLE command on MYISAM files and wants to restore them. I informed him, he cannot do that. Any help, guys?? -Original Message- From: Kelvin Yip [mailto:[EMAIL PROTECTED]] Sent:

RE: Big Problem...Need Help Quick

Unless he's got a recent backup he's USCWAP -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: Big Problem...Need Help Quick I apologize for cross post; however this poster is not on MYSQL list and he

Mysql and DBI question

question, i am using perl DBI and have a query from a table called usernames. here is the query... $sth2 = $dbh-prepare(select * from usernames where state = $quoted_the_state order by $the_sort_criteria limit $point, 25) ; i then execute the query, pulling off various columns... $array_ref

Re: 3.23.47 compile problems with sun's forte compiler

Thanks for the help on this, it seems to be working now. One question though, wouldn't configure be able to take of this? --shak Michael Widenius wrote: Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Shakeel Sorathia writes: I just downloaded the 3.23.47 source for

Re[2]: Mysql reconnect hang

Hello Sinisa, Wednesday, January 02, 2002, 6:21:59 PM, you wrote: No. This happens then mysql is completely restarted. I Understand this should not happen but somehow it does. I've found the following problem often happens to me: Then mysqld restarted unclear (sigsegv or server reset) the

further compile problems on Solaris 2.6

I have no pride - I'll use a binary if I can find a recent one for 2.6 - I just can't seem to find any. I've tried backing up from 3.23.47 to 46, 45, and 44 - my compile is getting stuck at the same place for all of them. : Making all in libmysql : make[2]: Entering directory

RE: MyODBC leaking handles...

Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:44 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, From what I can see, when the driver is unloaded (I guess when my

Re: FOREIGN KEYs and ALTER TABLE

Hi! Use SELECT INTO OUTFILE + READ DATA INFILE Do not rename tables. Regards, Heikki -Original Message- From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, January 03, 2002 5:54 PM Subject: Re: FOREIGN KEYs

Re: left join

Create index for the keys, like A.c, B.c A.d B.d ? Best regrads, Simon - Original Message - From: Dan Liu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 11:21 PM Subject: left join Hi everyone, I ran a query which is: select A.a as a,B.b as b from A left

Importing large text file

This is my first post on this list, so bear with me. I have a text file with 10,000 stories in it (about 130 MB). I would like to break it up into 10,000 separate files and am trying to figure out a way to feed it into a MYSQL database. I have set up the database with the pertinent fields,

RE: Importing large text file

Greg, Your best bet is to feed the data into Perl -- relatively simple Perl script can deal with variances you indicate, and feed the data into MySQL using DBI. Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Greg Peretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, 03 January,

duplicating collumn

Hi I have two tables, one contains a persons name and an ID number. The other table contains the ID number and another field. Is there a way of moving this collumn to the first table to corrlate with the ID's, ie, table 1 must now contains name, ID and another field that is specific to the

RE: duplicating collumn

You'll likely want to use INSERT INTO .. WHERE statement to populate a new third table based on the content of the two you've mentioned, joining on the ID. Look at http://www.mysql.com/doc/I/N/INSERT_SELECT.html for details on the syntax and usage. Eric Mayers -Original Message- From:

Problems using '*' in full text searches

Hi All... Here is my table... mysql select * from SearchTest; +-++ | UID | SomeText | +-++ | 1 | Hello this is a test field | | 2 | And this is another field | | 3 | And because we are

Re: duplicating collumn

On Fri, 04 Jan 2002 00:58:19 +0200, P.Agenbag [EMAIL PROTECTED] wrote: | Hi | I have two tables, one contains a persons name and an ID number. The | other table contains the ID number and another field. Is there a way of | moving this collumn to the first table to corrlate with the ID's, ie,

load data local infile

I want to set a field for all of the records I import while importing using load data local infile. The field is not specified in the file I am importing. Is there a way to do it? Mysql database importing tab delimited file.

RE: load data local infile

Hi, Not quite sure what you mean, but you can use load data infile 'file' into table mytab (col1, col3, col2) to specify in to which columns the data should go. HTH Quentin -Original Message- From: Douglas Potter [mailto:[EMAIL PROTECTED]] Sent: Friday, 4 January 2002 12:27 p.m.

Dump blobs using the mysql command line

Is there any way to hex-dump a BLOB column using a Select statement on the mysql command line? The documentation for the hex() function says that hex(abc) should print 616263 But in fact it prints 0. (on 3.23.36 and 3.23.43, the two versions I have installed - the former on RedHat

Re: Importing large text file

Greg, I agree with Tom H. PHP can also do an excellent job of this, even as a standalone script (ie no web server interaction). And you won't have to figure out how to load the DBI module! I'll adapt an example from something else I did: (Warning, not tested code...) #!/usr/local/bin/php ?php

Can you do something like this in Mysql?

Can you do something like this in Mysql? The following lines are part of a much larger sql query that we use on a MSsql box. ... case ar_open_items.doc_code when 'I' then 'Invoice' when 'C' then 'Credit Memo' when 'D' then 'Debit Memo' when 'F' then 'Finance Chg' when 'O' then case

Re: Can you do something like this in Mysql?

At 17:36 -0700 1/3/02, Mat Murdock wrote: Can you do something like this in Mysql? The following lines are part of a much larger sql query that we use on a MSsql box. MySQL has had CASE since earlier 3.23.x releases. ... case ar_open_items.doc_code when 'I' then 'Invoice' when 'C' then

Re: UPDATE SQL statement

Can someone tell me what I'm doing wrong? The following SQL gets an error Disclosure table not found UPDATE patents set patents.clientNumber=disclosure.clientNumber where patents.disclosureNumber=disclosure.disclosureNumber; Any help would be appreciated. Thanks. Jim Lowe Patent Attorney

[ANN] See MySQL at Macworld Expo Next Week

Greetings MySQL Enthusiasts: If any of you are interested in MySQL running on Mac OS X and you're planning to attend next week's Macworld Expo in San Francisco, please be sure to drop by the Blue World booth (#3426) to say hello. We'll be showcasing Lasso Professional 5 with its embedded

Command Line Editing Mode

Hi, Using the mysql CLI, I have discovered that ESC-Return Return will put the CLI editor in to 'vi' mode, and allow me to use my 'normal' ksh editing keys, available in ksh after set -o vi. Because I am more familiar with the vi editing keys, and they are more powerful than the standard

Re: UPDATE SQL statement

Dear Steve: Thanks for your help. Actually, the table is there. the error reads ERROR: Query failed (Unknown table 'disclosure' in where clause) Is it perhaps because it is an UPDATE? In Paul''s book, he says try the where clause with a select first. The following works fine. select

Re: 3.23.47 compile problems with sun's forte compiler

Hi! Shakeel == Shakeel Sorathia [EMAIL PROTECTED] writes: Shakeel Thanks for the help on this, it seems to be working now. One question Shakeel though, wouldn't configure be able to take of this? The problem is that as I don't have access to a Forte compiler, so I haven't been able patch

RE: 3.23.47 compile problems with sun's forte compiler

Hi, From the cc(1) man page for Forte Developer 6.2 These predefinitions are valid in all modes: __sun __unix __SUNPRO_C=0x530 __`uname -s`_`uname -r` __sparc (SPARC)

INSERT INTO - need some advice

I had 2 tables, the second table had a field (a key field) that is related to the field of the first table first tablesecond table __ : client_id : client_name :: client_id : services :

Re: 3.23.47 compile problems with sun's forte compiler

Hi guys, You can also pick up an evaluation version (I think its good for 30 days) of the forte suite from sun's site. Quentin Bennett wrote: From the cc(1) man page for Forte Developer 6.2 These predefinitions are valid in all modes: __sun

RE: Full Search

I've been looking hard at the FULLTEXT features of MySQL 4.0.1 on Linux and 4.0.0a on Win32 and comparing it to MS SQL 2000 / and MS SQL 7.0 as well as MySQL 3.XX.XX (latest stable release). MySQL 4 on Win2K (dual 550 1gig memory) can crawl 90MB of data in about 5 minutes . MS SQL 7 and 2000 on

Re: Command Line Editing Mode

In the last episode (Jan 04), Quentin Bennett said: Using the mysql CLI, I have discovered that ESC-Return Return will put the CLI editor in to 'vi' mode, and allow me to use my 'normal' ksh editing keys, available in ksh after set -o vi. Because I am more familiar with the vi editing

Re: INSERT INTO - need some advice

use the LAST_INSERT_ID() sql function On Fri, 4 Jan 2002 11:32:19 +0800, Arvin Bautista used a few recycled electrons to form: | I had 2 tables, the second table had a field (a key field) that is related | to the field of the first table | | first table

Re: Multilingual support

On 4 Jan 2002 06:27:44 -, K Jeevan used a few recycled electrons to form: | hi all |We are using mySQL as our database. Our site needs multilingual support |especially Korean. We tested inserting some Korean fonts into the database. It |accepted the values but while retriving the values

C programming to connect mysql

Hi all, Do anyone know that how to write a C programming to connect to mysql?? Many thanks. Kaming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Problems with replication over ssh-tunnel

Hello everybody, I have problems with replication from master to slave over ssh-tunnel. The port-forwarding is realized with command : ssh -N -f -L 23306:master:3306 localhost on the slave. After starting mysql I've got error-messages: 011220 14:57:00 mysqld started /usr/sbin/mysqld:

Re: UPDATE SQL statement

James Lowe writes: ERROR: Query failed (Unknown table 'disclosure' in where clause) Is it perhaps because it is an UPDATE? According to the manual, MySQL 4.1 will have multi-table updates. A while back Monty stated a target release date. I'm not quite sure about it, but I think it'll be Q2