Re: Good Oracle Forum

Daniel Cummings wrote: This forum has been very helpful. There is always somebody that is willing to respond to queries. Does anybody know of a good Oracle forum? TIA Dan Dan, You could try http://www.lazydba.com/ Best regards, Danny Stolle Netherlands. -- MySQL

Re: counting question

Try this out: select user.name, skill.skill_name, count(user_skill1.skill_id) from user , skill, user_skill , user_skill as user_skill1 where user.id=user_skill.user_id and user_skill.skill_id=skill.id and skill.id = user_skill1.skill_id order by user.id. I think this would work. -- Parag

Re: MySQL vs XML

Hi , First of all it should be clear that XML is only a well organised representation of data a mere text file. It is not a software . U will have to append entries all by urself to the file, and marking up suitable tags ( say the attribute of ur relational table) . Data will have to be extracted

Re: InnoDB migration between servers

Hello. If you have a reproducible test case, you should report a bug. Andreas Unterkircher [EMAIL PROTECTED] wrote: I can now isolate the problems with the appearing lock of some queries. I updated MySQL from 4.1 to 5beta (mysql-standard-5.0.10-beta-linux-x86_64-glibc23) to

Choosing a value in a query

Hi all, I am using MySQL 4.1.11nt I have two MyISAM tables: Table 1 holds usage information about users accessing various parts of the database. Relevant fields are Users_Code, Users_action and Affected_Member. Table 2 holds personal information about the Member. Relevant fields are

Re: counting question

I could not help to resist to create the tables and try the hint, which is pretty close to the working solution. I just had to replace order by user.id with group by user.name skill.skill_name regards, esv. --- Parag Agrawal [EMAIL PROTECTED] wrote: Try this out: select user.name,

Re: migrate Access to MySQL

http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027showtopic=1536view=getnewpost Karam --- Bing Du [EMAIL PROTECTED] wrote: Hello, I've been looking around for a while. Seems there are many options and tools that can help do it. Guidance and directions are highly

Re: Blob retrieval from database using shell

to compare binary files cmp does a better work than diff. to answer your question ...echo might be adding a new-line char (\n) at the end of the file, why don't you try printf, most shells include such, also try the echo switches not to print the new-line at the end of the command (for bash: echo

possible mysql/sql error...

hi... i created the following simple test of sql for mysql. i included some comments that use the word 'system' in the comments. the comments are wrapped in the '/* ... */' delimiters.. i get an error stating 'sh: foo command not found.' i traced the error/msg to the fact that the word 'system'

possible mysql/sql error...

update... it appears that the 'system' word has to be at the beginning of a line in the comment for the error to occur! i'm willing to bet this is a bug that hasn't been filed what are the odds that someone would run across it!! hi... i created the following simple test of sql for

myisamchk error

While running a -rq on a large table, I got the following error: myisamchk: warning: Duplicate key for record at 54381140 against record at 54380810 How do I find which record is duplicated (without doing the typical self-join query)? This table has 70 million rows, so that's not really

mysql and c

Hi all, is it possible to send from server to client a handle to MySQL connection. for example then i'm trying: server: Code: ... MYSQL mysql; mysql_init(mysql); mysql_real_connect(mysql,); ... send(socket,mysql, sizeof(MYSQL),0); - client: Code:

Re: myisamchk error

Hank [EMAIL PROTECTED] writes: How do I find which record is duplicated (without doing the typical self-join query)? This table has 70 million rows, so that's not really feasible. select col, count(1) cnt from tab group by col having cnt 1; This will print out all duplicated col rows.

Re: Persistent Corruption

Thanks for all the help - I tried the dump as suggested, and it still corrupted...waiting on the new drive to come and then I will try replacing that .. I hope that I dont have to move to a new kernel!! On 7/29/05, Terence [EMAIL PROTECTED] wrote: Also check your kernel version. We had the

Re: mysql command line execution

At 09:49 PM 7/29/2005, Nuno Pereira wrote: Michael Stassen wrote: Ehrwin Mina wrote: Jeff, You can make a shell script or a php script or a perl script by that way you can hide the commands you need to execute. eg. Make a shell script (myshell.sh) #!/bin/sh myuser=dbuser

Replication stops on ALTER TABLE ; keep on getting duplicate column names

Dear All, Here's our setup : Master : MySQL v4.0.16-max-log Slave : MySQL v4.1.10a-max-log Everytime I do an ALTER TABLE on the master server, I get the following error message on the slave server. 050723 1:51:26 [ERROR] Slave: Error 'Duplicate column name 'TimefileDate'' on query.