Re(2): newbie help db locked err is The table '#sql_2c52_0' is full [ag]

before all thank you for your answer, next while waiting for an answ3er I backup the db then tried to convert tables in Inno db format everything run fine now, the same query execute ok but i prefer myIsam format i use it as default, then I'd like to understand what is the problem, here are al

Re: newbie help db locked err is The table '#sql_2c52_0' is full [ag]

Adriano - MySQL names temp tables like that (starting with # sign), in paticular while storing a result set to be sorted. I would guess that your query is returning a result set large enough to hit a filesystem limit on your box. How big are you expecting the results to be? Perhaps you are mis

newbie help db locked err is The table '#sql_2c52_0' is full [ag]

Hy thank you all, I'm getting the following err msg -> The table '#sql_2c52_0' is full running a complex query (and only running that query) with three outer join it is a simple db that stores mail msgs my query is about mail msg->recipients->sender the biggest table mail_archive has 90467

Newbie help: extracting pattern based data from fields

Hi: My database is mysql 4.1.14-standard. I have a blob type field in a table1 with mutlple attributes together in the field as shown below table1.field1 value for a record is "abc=2 def=4 ghi=10" I have table2 which has fields abc, def and ghi. I want to be able to parse the table1.field1 and ins

RE: Newbie help with MySQL

lists.mysql.com Subject: Newbie help with MySQL Hello there, I am running MySQL 5 Community Edition on Mac OS X Tiger Here's what I did: 1. Ran the MySQL server from System Preferences 2. Launched Terminal and typed in the following: untz$ mysql -u root -p 3. Was prompted for my

Newbie help with MySQL

Hello there, I am running MySQL 5 Community Edition on Mac OS X Tiger Here's what I did: 1. Ran the MySQL server from System Preferences 2. Launched Terminal and typed in the following: untz$ mysql -u root -p 3. Was prompted for my password, and after entering that in, I received this

Re: Newbie: Help with Match without using a subQuery

Graham Anderson <[EMAIL PROTECTED]> wrote on 04/14/2005 11:51:58 AM: > many thanks > that was exactly what I needed. > > Building upon the initial question: > Is there a way to get Match statements to do partial word > searches...like %LIKE% ? > > For example, if the below Match Against que

Re: Newbie: Help with Match without using a subQuery

many thanks that was exactly what I needed. Building upon the initial question: Is there a way to get Match statements to do partial word searches...like %LIKE% ? For example, if the below Match Against query with 'chris' does not bring up anything... AND MATCH ( media.name, media.product )

Re: Newbie: Help with Match without using a subQuery

Graham Anderson <[EMAIL PROTECTED]> wrote on 04/13/2005 01:46:35 PM: > Hi > I am trying to set up my Match statements to filter the result of the > main query [which works] > > If 'chris' does not exist in the first MATCH statement [AND MATCH > (media.name, media.product)], then the results get

Newbie: Help with Match without using a subQuery

Hi I am trying to set up my Match statements to filter the result of the main query [which works] If 'chris' does not exist in the first MATCH statement [AND MATCH (media.name, media.product)], then the results get a bit screwed up :( If the first match statement finds something, then the quer

Newbie HELP. Using SELECT in Query Browser to retrieve records

Am new to mysql and have some difficulty in retrieveing data from 3 tables using the Query Browser(version 1.0.8). I have 3 tables (axkde, axuser,axdev). All 3 tables have 'id','sender','reply'fields. Id is unique in all 3 tables. Now I want a query to extract data from the 3 tables. Somethi

Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number

Sanjay Arora wrote: On Thu, 2004-07-08 at 00:19, Paul DuBois wrote: At 22:34 +0530 7/7/04, Sanjay Arora wrote: I am using Mysql on RH Linux 9. I am getting the following error. Command and result are given below alongwith \s output for diagnostic purposes. I have created a dns database and am tryin

Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number

On Thu, 2004-07-08 at 00:19, Paul DuBois wrote: > At 22:34 +0530 7/7/04, Sanjay Arora wrote: > >I am using Mysql on RH Linux 9. I am getting the following error. > >Command and result are given below alongwith \s output for diagnostic > >purposes. > > > >I have created a dns database and am trying

Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number

At 22:34 +0530 7/7/04, Sanjay Arora wrote: I am using Mysql on RH Linux 9. I am getting the following error. Command and result are given below alongwith \s output for diagnostic purposes. I have created a dns database and am trying to create a user mysql user dns with all privileges on it. mysql>

RE: Mysql Newbie: Help requested...password hash should be a 16 digithexadecimal number

Sanjay Arora on Wednesday, July 07, 2004 10:04 AM said: > I am using Mysql on RH Linux 9. I am getting the following error. [snip] > Database changed > mysql> GRANT ALL PRIVILEGES ON dns.* TO [EMAIL PROTECTED] IDENTIFIED BY > PASSWORD "dns"; > ERROR 1133: Password

Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number

I am using Mysql on RH Linux 9. I am getting the following error. Command and result are given below alongwith \s output for diagnostic purposes. I have created a dns database and am trying to create a user mysql user dns with all privileges on it. mysql> use mysql Reading table information for c

Newbie help - change datatype of a table

how can i change the data type of a table? I'm not sure if that is my problem. If anyone is interested here is a link what I've been trying to do: http://www.phpbuilder.com/board/showthread.php?threadid=10248279&goto=newpost Thanks for any help given! H

Re: NEWBIE help - using two sources for data

Sean Berry <[EMAIL PROTECTED]> wrote: > I need to know how to be able to read in data from to mysql from two different > places. For example from /usr/local/mysql and /usr/local/data You can use symlinks: http://www.mysql.com/doc/en/Symbolic_links.html -- For technical support contra

NEWBIE help - using two sources for data

I need to know how to be able to read in data from to mysql from two different places. For example from /usr/local/mysql and /usr/local/data Please help me if you have any answer. Thanks for your response. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

RE: Newbie- Help with query

ecember 11, 2002 10:26 AM To: [EMAIL PROTECTED] Subject: Newbie- Help with query Help! I am a new mysql user, I understand the basic syntax of the commands for different sql queries. I am trying to write a query and I can't seem to figure it out. I would like to select all domain,tran

Newbie- Help with query

Help! I am a new mysql user, I understand the basic syntax of the commands for different sql queries. I am trying to write a query and I can't seem to figure it out. I would like to select all domain,transport fields from the transport table where the transport id = a query agains the acl tabl

Newbie Help! Can't connect to MySQL server on 'localhost' (10061)

Sorry should have made clear that is what phpMyAdmin gives me in the browser. WinMySQLadmin seems to be fine. -Original Message- From: Martin Wright [mailto:[EMAIL PROTECTED]] Sent: 26 November 2002 11:19 To: '[EMAIL PROTECTED]' Subject: Newbie Help! Can't connect to

Newbie Help! Can't connect to MySQL server on 'localhost' (10061)

Well, not so much a newbie as "scratcher" of the surface :) I've used MySQL on my desktop under windows for a while. Never had any issues with it from the straight install. Am using 3.23.38 and MyOBDC 2.50-36. Recently (I don't know if this is relevant) upgraded to win XP Pro SP1. Now I've rein

re: Newbie help needed with mysql : part II

john, Saturday, November 09, 2002, 9:45:15 PM, you wrote: j> Ok.. I got the /etc/my.cnf under control, but now when I do this: j> root@rock:/etc# mysqladmin -u root -h rock password * j> mysqladmin: connect to server at 'rock' failed j> error: 'Host 'rock.biohazard.org' is not allowed to conn

Re: Newbie help needed with mysql : part II

On Sat, 2002-11-09 at 14:45, john wrote: > > > Ok.. I got the /etc/my.cnf under control, but now when I do this: > > root@rock:/etc# mysqladmin -u root -h rock password * > mysqladmin: connect to server at 'rock' failed > error: 'Host 'rock.biohazard.org' is not allowed to connect to this >

Newbie help needed with mysql : part II

Ok.. I got the /etc/my.cnf under control, but now when I do this: root@rock:/etc# mysqladmin -u root -h rock password * mysqladmin: connect to server at 'rock' failed error: 'Host 'rock.biohazard.org' is not allowed to connect to this MySQL server' Then I tried this: root@rock:/etc# mysql

Re: Newbie help needed with mysql

I dont have a my.cnf file, so I "touched" /etc/my.conf still doesnt work. Where do I find a .cnf file to copy over? and root@rock:/var/run/mysql# ls mysql.sock= << it exists. What could my problem be..? I even upgraded. I am using Slackware 8.1 with 2.4.19 kernel. Maybe that will help. Thanks s

Re: Newbie help needed with mysql

On Mon, 2002-11-04 at 18:52, john wrote: > > > When I start safe_mysqld &, I get a command prompt back again and ps aux > shows this: > > mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00 > /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/lib/my

RE: Newbie help needed with mysql

PM To: [EMAIL PROTECTED] Subject: Newbie help needed with mysql When I start safe_mysqld &, I get a command prompt back again and ps aux shows this: mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-

Newbie help needed with mysql

When I start safe_mysqld &, I get a command prompt back again and ps aux shows this: mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid mysql30271 0.0 0.1 10580 1024 pts/1

Re: newbie help

On Friday 06 September 2002 05:50 pm, Marcelo Simon wrote: Well, I'm not 100% certain since I don't know what environment you're working in, but a typical example from perl might be something like my $query = "INSERT INTO foo VALUES(".$cgi->param('myintfield').",'".$cgi->param('mydatefield

newbie help

Hi, First time here, hope someone can understand me and help me. I have a field wich type that is int(4), and I'm updating it from a form. it is working ok, unless the formfield is empty. When it's empty I'm receiving an SQL error number 51(). In the db the field is setup to receive empty value

Re: newbie help

if it's an imposterer, its a fairly decent looking mirror :) -bobby - Original Message - From: "Ryan Hatch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 10:31 PM Subject: Re: newbie help > "bd&quo

Re: newbie help

Sorry for the confusion. I have not checked www.MySQL.org in such a long time. I was referring to the period of time when NuSphere (Progress) had owned MySQL.org and appeared to be falsely representing themselves as the MySQL developers. I'm sure you now know what I intended. Regards, -Rya

RE: newbie help

nto a table, look at: http://www.mysql.com/doc/L/O/LOAD_DATA.html If you wanna load data into a text file, look at: http://www.mysql.com/doc/S/E/SELECT.html Gurhan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 3:34 PM To: [EMAIL PROTEC

Re: newbie help

Maybe the poster of the message is an imposter developer too? MS -Original Message- From: Steve Buehler <[EMAIL PROTECTED]> To: mysql <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, May 09, 2002 3:01 PM Subject: RE: newbie help >What

RE: newbie help

Hatch [mailto:[EMAIL PROTECTED]] >Sent: Thursday, May 09, 2002 1:31 PM >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: Re: newbie help > > >"bd"... > >Two things here: > >1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. >and >2

RE: newbie help

"Mysql.org is an IMPOSTER's site." What? They are one in the same. -Original Message- From: Ryan Hatch [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: newbie help "bd"... Two things

Re: newbie help

"bd"... Two things here: 1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site. and 2.) You haven't given us the warning / error message you received. -Ryan Hatch [EMAIL PROTECTED] wrote: >I just created a database and tried to LOAD 1 line of data from a text file. > >I h

newbie help

I just created a database and tried to LOAD 1 line of data from a text file. I have only 9 coloums , most varchar, one char, one smallint (autoincrement) when i load the data (tab de-limeted) it goes fine but i get one Warning. I found on mysql.org that i need to INTO OUTFILE and look for erro

Re: Newbie: Help with count

you can use: select messagestate, count(*) from table where uid=1 group by messagestate; for uid=1, if you want to do the same for all users with one query you can use: select uid, messagestate, count(*) from table group by uid, messagestate; Regards, Ben Holness wrote: > Hi all, > > I hav

Newbie: Help with count

Hi all, I have a table that has data that looks something like this (fixed font on): UserID MessageID MessageState 1 1 PENDING 1 2 PENDING 2 3 FAILED 3 4 DELIVERED 2

Re: newbie : Help with C api for mysql

jim and lois flaherty wrote: > gcc analysis.c > > analysis.c:6:19: warning: extra tokens at end of #include directive > analysis.c:7:19: warning: extra tokens at end of #include directive > /tmp/ccsKk2GG.o: In function `main': > /tmp/ccsKk2GG.o(.text+0x14): undefined reference to `mysql_init' >

newbie : Help with C api for mysql

I have a Redhat 7.1 box, I want it to connect to its own mysql db . Here is my code #include ; #include ; int main(char **args){ MYSQL_RES *result; MYSQL_ROW row; MYSQL *connection, mysql; int state; /* connect to the mysql db */ mysql_init(&mysql); connection = mysq

Newbie Help Question: mySQL: table does not exist or has no columns

Hi just ported a web site from one server to my own. MySQL is running just fine. When I run my page that talks to my database however, I get this; mySQL: table does not exist or has no columns ...then the rest of the page comes in just fine. Any idea what I have missed here? THX Mike [EMAI

Re: general newbie help

At 10:37 AM -0400 5/10/01, Bernie Cosell wrote: >On 10 May 2001, at 10:26, Scott Abbotts wrote: > >> I see most of you are experienced developers. Can someone point me in a >> direction (tutorial..) to learn MySQL? ... > >I'm not sure there's a better place to go than Paul Dubois's book on >MyS

Re: general newbie help

At 5/10/01 10:37 AM, Bernie Cosell wrote: >On 10 May 2001, at 10:26, Scott Abbotts wrote: > > > I see most of you are experienced developers. Can someone point me in a > > direction (tutorial..) to learn MySQL? ... > >I'm not sure there's a better place to go than Paul Dubois's book on >MySQL. I

Re: general newbie help

, May 10, 2001 8:37 AM Subject: Re: general newbie help > On 10 May 2001, at 10:26, Scott Abbotts wrote: > > > I see most of you are experienced developers. Can someone point me in a > > direction (tutorial..) to learn MySQL? ... > > I'm not sure there's a bett

RE: general newbie help

bject: general newbie help I see most of you are experienced developers. Can someone point me in a direction (tutorial..) to learn MySQL? I've successfully set up phpMyAdmin on my site, but I'm afraid I'm still lost..

Re: general newbie help

On 10 May 2001, at 10:26, Scott Abbotts wrote: > I see most of you are experienced developers. Can someone point me in a > direction (tutorial..) to learn MySQL? ... I'm not sure there's a better place to go than Paul Dubois's book on MySQL. It's about $35 and more than worth every penny...

general newbie help

I see most of you are experienced developers. Can someone point me in a direction (tutorial..) to learn MySQL? I've successfully set up phpMyAdmin on my site, but I'm afraid I'm still lost.. - Before posting, please check:

RE: newbie help

Mat Jones - booksellersolutions.com [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 11:19 AM To: [EMAIL PROTECTED] Subject: newbie help I have several seperate databases which i would like to search using one sql query. All stores have varying field names: store1.products - author,title,description ..

newbie help

I have several seperate databases which i would like to search using one sql query. All stores have varying field names: store1.products - author,title,description ...and other fields which i do not need to use store2.products - artist,title,comments store3.products - author,title, comments