Query - question

How can I join two tables looking like this? Table 1: ++---+---+ | Id | Name | Score | ++---+---+ Table 2: ++---+---+---+ | Id | Name | Score | Info | ++---+---+---+ To get output table like this: Table 2: ++---+---+--

INNODB memory allocation error during startup

kbytes, -v) unlimited file locks (-x) unlimited -- ulimit -a -- Also, before I start MySQL I see the box has about 5900M of free memory (free -m). Any help would be greatly appritiated. Thanks in advanced, Eddie. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Using "DROP USER" in a stored procedure

to solve it in a little mysql script. Thanks. Hope you have a great 2008! -- Eddie Cornejo -BEGIN GEEK CODE BLOCK- Version: 3.12 GIT d? s: a- C+++ UL+++ P++ L++ E- W+ N- o K- w++ O M-- V PS+ PE Y PGP++ t 5 X+ R tv-- b+ DI D++ G e++ h r+++ y+++ --END GEEK CODE BLOCK-- -- MySQ

Re: Using "DROP USER" in a stored procedure

On Jan 7, 2008 2:34 AM, Shawn Green <[EMAIL PROTECTED]> wrote: > > Eddie Cornejo wrote: > > I'm writing a cleanup script to remove database items created by my > > application. One of the things I would like to remove are all user > > accounts created through m

transfer InnoDb in correct order ??

dering it manually isn't an option at this moment with so periodically transfers and so many tables :( Eddie _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL

Re: commit,buffers

OK, first off, this website is kinda infuriating. Why can't I click on the message thread on the web, and reply that way? I'm not even sure this message will reach it's recipients. . Anyhow, I was just reading on http://www.mysql.com/doc/en/Server_system_variables.html, there's a variable called '

AUTOCOMMIT and MySQL 4.1, returning nothing on a valid query

the MySQLdb API wrapper - but I'm curious as to what it would be oversetting on the MySQL side. Oh, and if I remove he "SET AUTOCOMMIT=0", then it works fine, up to 1000. Can anyone offer any advice? Thanks! ____ _/ __ \

login question

ng if anyone had any ideas. Eddie __ This email transmission and any documents, files or previous email messages attached to it may contain information that is confidential or legally privileged. If you are not the intended recipient

Newbie Authentication question

o maintain b) the users would hate it. If anyone has any ideas please tell me. Eddie __ This email transmission and any documents, files or previous email messages attached to it may contain information that is confidential

Duplicate Inserts

I'm running MySQL on a WIN2k server box. I'm doing inserts using PHP. Here's the code for the insert: $db = mysql_connect($hostname, $uid, $pwd); //$hostname is "localhost" and $uid/$pwd are userid and password mysql_select_db("heroes",$db); $insertQuery = "INSERT INTO UniqueCardList (MCardI

Re: Duplicate Inserts

ONLY that part of the body tag, the duplication problem went away. - Original Message ----- From: "Eddie Heard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 20, 2001 12:05 AM Subject: Duplicate Inserts > I'm running MySQL on a WIN2k

Re: MySQL 3.23.45 is released

MySQL has been updated: Windows: http://fileforum.betanews.com/detail.php3?fid=967965401 Linux: http://fileforum.betanews.com/detail.php3?fid=974952174 FreeBSD: http://fileforum.betanews.com/detail.php3?fid=974952321 Thanks Eddie Elmore [EMAIL PROTECTED] http://www.betanews.com http

Password problems

ve been reading the docs and I don't think they do it as such. Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this