Re: Needing help about PHP+mysql on RedHat 9.

[John Nichel]

Mario Miyojim wrote:
I am trying to revive an existing LAMP system.
I recently installed RedHat9. I had several LAMP
applications
working under RedHat 7.1, but now they don't function 
properly. For instance, I have many scripts that use
the

construct, but they are not working as they should.
I tried to get help from the PHP home site, but
www.php.net
has been unreacheable to me for several days.
I am considering a desperate attempt to go back to
RedHat 7.1
because that configuration supported my PHP scripts,
but now I can't
even read the updated PHP manual.
Please, if anyone knows how to circumvent this
problem, help me!
Thanks
Chances are, register_globals was on with your old installation, and now 
it is off by default in php.  Either turn it on in the php.ini 
(not-recommended), and restart your webserver, or rewrite your code to 
work with globals off (recommended).  Things like $PHP_SELF would now 
be, $_SERVER['PHP_SELF'].

Look here

http://us3.php.net/register_globals

Also, you'll get more help with an item such as this from a php mailing 
list.

--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Needing help about PHP+mysql on RedHat 9.

[Mario Miyojim]

I am trying to revive an existing LAMP system.
I recently installed RedHat9. I had several LAMP
applications
working under RedHat 7.1, but now they don't function 
properly. For instance, I have many scripts that use
the

construct, but they are not working as they should.
I tried to get help from the PHP home site, but
www.php.net
has been unreacheable to me for several days.
I am considering a desperate attempt to go back to
RedHat 7.1
because that configuration supported my PHP scripts,
but now I can't
even read the updated PHP manual.
Please, if anyone knows how to circumvent this
problem, help me!
Thanks

__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

java.net.SocketException: errno: 48, error: Address already in use

[Prasad Budim Ram]

Hi,

 I'm getting the following error while connecting to a MySQL databases
using JDBC. Any clues??

Thanks,
Ram

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Preventing data collisions

[Brian Reichert]

On Mon, Nov 17, 2003 at 11:06:39PM -0600, David Dice wrote:
> I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find 
> an answer.
> 
> How do I prevent data collision in the following scenario:
> User A and User B are examining the same data (say a customer's name and address).  
> User A modifies something (say the customer's phone number) and saves the 
> transaction.  User B modifies something different at the same time.  How can I 
> prevent User B's modification from being saved?

Under MySQL, you can lock the a table during sensitive transactions.
If you're using InnoDB tables, you can use row locking.

  

> This is a database I'm converting from Foxpro, and there I would have just told User 
> B that User A had the data open, and prevented them from editing it.  I'm sure 
> there's a better way.  Thanks for your advice.
> 
> David Dice

-- 
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Preventing data collisions

[David Dice]

I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find an 
answer.

How do I prevent data collision in the following scenario:
User A and User B are examining the same data (say a customer's name and address).  
User A modifies something (say the customer's phone number) and saves the transaction. 
 User B modifies something different at the same time.  How can I prevent User B's 
modification from being saved?

This is a database I'm converting from Foxpro, and there I would have just told User B 
that User A had the data open, and prevented them from editing it.  I'm sure there's a 
better way.  Thanks for your advice.

David Dice

Column type

[Ron McKeever]

Hi

I have a .txt file that is loaded into my table. This is done
using LOAD DATA INFILE
One of the columns data is a unix timestamp from the .txt file.
The column is called begin.

I have created the column as a varchar before
and then converted the date using FROM_UNIXTIME(), so it can be readable.

My question is:
Should I create this column "begin" as "DATETIME, DATE, or TIMESTAMP" or
since I'm converting the unix time leave it as a varchar???

Thanks,
Ron



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql: not found

[Stephen Fromm]

- Original Message - 
From: "Kelley Prebil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 9:33 PM
Subject: mysql: not found


> When I try to start the database with :
>
> mysql -h host -u user -p
>
> I get the response :
>
> mysql: not found
>
> What does this mean?  Installation went smoothly as far as I could tell.

Sounds like you don't have your path set up.

> Also, when I try to start the database with :
>
> bin/mysqld_safe --user=mysql &
>
> It starts the mysqld daemon from the right directory, and then promplty
says :
>
> 031117 18:07:39  mysqld ended
>
> Any help would be appreciated as I couldn't find anything in the manuals
about troubleshooting.
>
> Kelley
>
> --
> Kelley Rianna Prebil
> http://www.pearlsgirl.com
> --
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Saving a table to a text file

[Bernard Clement]

mysqldump is a program like mysql not a command within mysql.

Bernard
On Monday 17 November 2003 21:46, Lay Hoon Tan wrote:
> I keep on getting errors for saving table to an external file. I think
> there is something wrong with the syntax. Could someone help me to correct
> it ?
>
> mysql> mysqldump -r database table1;
>
> Regards


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

performance problems, maintence on one table slows down others

[Dan Edwards]

Hi, I have a performance issue I've tried resolving and I can't get rid 
of it. Basically I have a database called lobby that any queries to it 
must be as fast as possible inserts, and selects. It must do about 60 
queries a second with no queries taking more then 50ms. I also have 
another database called Track that I need to do some maintance on some 
of its tables. Right now I need to archive off records to seperate 
tables by month. I wrote a C program to do it. The problem is when I run 
it, it slows down the queries to the lobby database so severly that 
queries that normaly take less then 10 ms, take a second or more, which 
is absolutely unacceptable. (The tables are the backend of online card 
games, and database stalls cause lag for players)

To solve this problem I bought a fast server with a fast scsi mirror 
raid dedicated to the lobby database. The server is a Redhat 9, kernel 
2.4.20-20.9smp, mysql 4.0.16, dual p4 2.4 xeon (Dell 1600SC), with 1 gig 
ram, 4 36 gig 15k rpm scsi HDs. 2 mirrored for the os and most databases 
and 2 mirrored dedicated to the lobby database.

The program that archives tables basically does this:
insert into Events_Sep select * from Events where EventID>=1000 and 
EventID<1100;
delete from Events where EventID>=1000 and EventID<1100;
And then pauses 1 second.

The Events table has over 2 million records in it, and is 2.3GB in 
Events.MYD and 170M in MYI.

I thought the original problem was the lobby and track databases where 
on the same hard drive. But this new hardware hasn't solved the problem. 
It is better, but still far from good enough.

Here is a bit of top while the archiveing is running:
 18:39:40  up 11 days,  8:20,  2 users,  load average: 0.11, 0.12, 0.14
77 processes: 76 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 5.2% user 2.1% system  0.0% nice   0.0% iowait  92.2% idle
CPU1 states: 4.1% user 4.4% system  0.0% nice   0.0% iowait  91.0% idle
CPU2 states: 0.0% user 0.1% system  0.0% nice   0.0% iowait  99.4% idle
CPU3 states: 0.2% user 0.1% system  0.0% nice   0.0% iowait  99.2% idle
Mem:  1159456k av, 1149228k used, 10228k free,  0k shrd,   60804k buff
795764k actv,6452k in_d,   47432k in_c
Swap: 1052152k av,  308140k used,  744012k free   694920k cached
  PID USER PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME CPU COMMAND
 7098 mysql 15   0  399M 304M  1348 S16.6 26.9 647:22   2 mysqld
Some dumps from iostat -k 2 with archive running, prety much alternates 
between these two:
Device:tpskB_read/skB_wrtn/skB_readkB_wrtn
dev8-0  414.50   120.00  2408.00240   4816
dev8-1  427.5060.00  2408.00120   4816
dev8-2  139.5024.00   604.00 48   1208
dev8-3  135.50 0.00   604.00  0   1208

Device:tpskB_read/skB_wrtn/skB_readkB_wrtn
dev8-05.0018.0034.00 36 68
dev8-1   13.5056.0034.00112 68
dev8-22.00 6.0012.00 12 24
dev8-31.50 2.0012.00  4 24
Some typical iostat dumps without the archive running:

Device:tpskB_read/skB_wrtn/skB_readkB_wrtn
dev8-05.00 0.0040.00  0 80
dev8-15.50 2.0040.00  4 80
dev8-2  118.50 2.00   522.00  4   1044
dev8-3  119.00 4.00   522.00  8   1044
Device:tpskB_read/skB_wrtn/skB_readkB_wrtn
dev8-04.00 2.0018.00  4 36
dev8-13.50 0.0018.00  0 36
dev8-21.00 4.00 0.00  8  0
dev8-30.50 4.00 0.00  8  0
The OS/Track tables are  dev8-0 and dev8-1, The lobby tables are on 
dev8-2 and dev8-3.

Here is important bits of my.cnf:
[mysqld]
server-id=4
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin
skip-locking
log-slow-queries
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
set-variable= myisam_sort_buffer_size=64M
set-variable= thread_cache=8
set-variable= thread_concurrency=8
set-variable= tmp_table_size=256M


One theory I have is that since the os/track harddrive is slowed down so 
much that writes to the bin log are delayed enough to cause delays in 
queries to lobby tables.

Anyone else have any other theories or suggestions of what I should try 
next. I would really like to avoid putting the databases on totally 
seperate servers.

Thanks for any insight, I know mysql has the power to pull this off, we 
just need to

Saving a table to a text file

[Lay Hoon Tan]

I keep on getting errors for saving table to an external file. I think
there is something wrong with the syntax. Could someone help me to correct
it ?

mysql> mysqldump -r database table1;

Regards



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql: not found

[Kelley Prebil]

When I try to start the database with :

mysql -h host -u user -p

I get the response :

mysql: not found

What does this mean?  Installation went smoothly as far as I could tell.

Also, when I try to start the database with :

bin/mysqld_safe --user=mysql &

It starts the mysqld daemon from the right directory, and then promplty says :

031117 18:07:39  mysqld ended

Any help would be appreciated as I couldn't find anything in the manuals about 
troubleshooting.

Kelley

--
Kelley Rianna Prebil
http://www.pearlsgirl.com
--

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Please help DB Error: unknown error

[Thai Thanh Ha]

 I see the only message "DB Error: unknown error". Even when I run
mysqld.exe with --log and --error-log options, I still cannot get a more
descriptive error message. 

 I guess the problem is because of the number of joins is too large or the
number of *temporary* rows is too large. But I don't know how to resolve
this problem.

 Regards,
 Thai

-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:02 PM
To: 'Thai Thanh Ha'; '[EMAIL PROTECTED]'
Subject: RE: Please help DB Error: unknown error


Can you please post the error?

-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error


Hi all,
I have a problem with my query on mySQL 4.0. 
DB Error: unknown error 
I don't know what is the problem. Please help me!!! Thanks in advance.
Regards,
Thai
SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile t4,tblUserProfile
t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile t8,tblUserProfile
t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile t12,tblUserProfile
t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile t16,tblUserProfile
t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile t20,tblUserProfile
t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile t24,tblUserProfile
t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile t28,tblUserProfile
t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile t32,tblUserProfile
t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile t36,tblUserProfile
t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile t40,tblUserProfile
t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile t44,tblUserProfile
t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile t48,tblUserProfile
t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile t52,tblUserProfile
t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile t56,tblUserProfile
t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile t60,tblUserProfile
t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile t64,tblUserProfile
t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile t68,tblUserProfile
t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile t72,tblUserProfile
t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile t76,tblUserProfile
t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile t80,tblUserProfile
t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile t84,tblUserProfile
t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile t88,tblUserProfile
t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile t92,tblUserProfile
t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile t96,tblUserProfile
t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile t100,tblUserProfile
t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle <>
'administrator' AND t.AccountType <> 2 AND t.AccountType <> 3 AND t.Gender =
1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID =
t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND t1.UserID=t2.UserID
AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND t4.FieldID
= 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78 AND
t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.Fi

Re: [Mysql] mysqld ended

[Joakim Ryden]

On Nov 17, 2003, at 4:13 PM, Matthew Hagen wrote:

I executed the command:

fuser -n tcp 3306

and it returned:

3306/tcp:  187

I then ran ps -ef to find what program was using this port and I found
it was:
root   187 1  0 Nov13 ?00:00:00 /usr/sbin/inetd

Is it ok to kill this process ? If not, is there a way to specify 
mysqld
to use another port ?
Look through /etc/inetd.conf for anything that could potentially be 
configured to use 3306 and remove it and restart inetd.

--Jo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: [Mysql] mysqld ended

[Matthew Hagen]

I executed the command:

fuser -n tcp 3306

and it returned: 

3306/tcp:  187

I then ran ps -ef to find what program was using this port and I found
it was:

root   187 1  0 Nov13 ?00:00:00 /usr/sbin/inetd

Is it ok to kill this process ? If not, is there a way to specify mysqld
to use another port ?

Thanks for the help,
Matthew


-Original Message-
From: Joakim Ryden [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 17, 2003 4:17 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Mysql] mysqld ended


On Nov 17, 2003, at 12:40 PM, <[EMAIL PROTECTED]> wrote:

> Hi, I am installing a binary version of mysql 4.0.7, but I cannot get 
> the mysql daemon running. Mysqld ends right after I start it up.
> I attached the command I use and the output. I also cut and pasted the

> output from the log file.

[...]

> 031117 15:09:55  Can't start server: Bind on TCP/IP port: Address 
> already in use
> 031117 15:09:55  Do you already have another mysqld server running on 
> port: 3306
>  ?

'fuser -n tcp 3306' should give you the process id of the process 
holding up the port.

--Jo



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: row-level locking question...

[Jeremy Zawodny]

On Mon, Nov 17, 2003 at 10:10:52AM -0500, Andre Charbonneau wrote:
> Hi,
> 
> Let say that I have the following transaction:
> 
> 1. Read value v1 from table t1.
> 2. Do some computation using v1.
> 3. Update value v2 from table t2.
> 
> If in the above I don't want any other concurrent transaction to read v2 
> until I'm done updating it, how should I put an exclusive lock on it?
> 
> Using InnoDB, would the following be the way to do it (in transaction 
> mode, seriliazable isolation level)?

Have you tried it yourself?  That would probably answer your question
faster.
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 64 days, processed 2,503,781,143 queries (445/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Some help with a complex query

[Roger Baklund]

* Elisenda
[...]
> So, the good way to write joins will be as follows, doesn't it?
>
> FASE.SQL_ID_CE=CA.CA_ID_CE AND
> FASE.PR_PP_ID_COORD=PP.PP_ID_PP AND
> CA.CA_ID_CE=CE.CE_ID_CE AND
> FASE.AU_PR_AULA=AU.AU_AULA

Those are the exact same criteria as you had, only in a different order,
isn't it? The order of these criteria within the WHERE clause does not
matter, the server will select the optimal way to join, which is what is
expressed in the EXPLAIN SELECT output. You also changed
CE.CA_ID_CE=CA.CE_ID_CE to CA.CA_ID_CE=CE.CE_ID_CE, this is the same thing,
it makes no difference.

[...]
> So, when explain select  says this
> "CE ref   Centro  7CA.CA_ID_CE10" ,
> it isn't a good result for me, isn't it?

That depends...

> Because CA it is supposed to have one record for each CE or the other way
> round.

...then it is not good. You would have expected a 1 in the last column.

> I have to review CA and CE.

yes. :)

[...]
> > I don't understand... How many FASE records with PR_flag=1 and
> > SQL_ID_PY='P081'? You say when you join FASE and CA on those
> > criteria you get 253 rows, but you should get 753?
>
> I mean that in my database I have 753 records that match this critera
> (SQL_ID_PY=P081 and PR_flag=1 and CA_ID_Idioma=6) but the result of mysql
> gives me only 253.

I still don't get it. When you say "in my database", which database are you
talking about? How do you know you have 753 when mysql (=database?) says you
have 253? And what do you mean by "records that match", the CA_ID_Idioma
column is from a different table, isn't it?

[...]
> Thank you very much for your help and patients.

You're welcome. :)

--
Roger


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Load Data Infile confusion

[Robert Bateman]

This one has had me scratching my head all afternoon.

I have a comma delimited text file that I am using to "import" data from a 
legacy system into a MyISAM table.  My server is 4.0.16 as is my client.  
Both run on Redhat 8.0.

An example line of imput looks like

"041502f","1","25.00","$","25.00","","2003-1-15T17:47:50","O"

with my table format being

CREATE TABLE
IF NOT EXISTS FeeSplit(
  FileNumberVARCHAR( 50 ) BINARY NOT NULL,
  AppraiserCode VARCHAR( 08 ) BINARY NOT NULL,
  SplitNumber   FLOAT DEFAULT 0.00,
  SplitDesignator   CHAR( 01 ) DEFAULT '$',
  CalculatedSplitAmtFLOAT DEFAULT 0.00,
  DateFeePaid   DATE,
  DateTimeRecordAdded   DATETIME,
  PersonDesignator  CHAR( 01 ),
  SplitComments TEXT,
  LastModified  TIMESTAMP,
  LastModifiedByVARCHAR( 08 ),
  PRIMARY KEY ( FileNumber, AppraiserCode, SplitNumber, SplitDesignator, 
CalculatedSplitAmt, DateFeePaid, DateTimeRecordAdded ),
  INDEX FileNumberDesignatorIndex ( FileNumber, PersonDesignator ),
  INDEX AppraiserDesignatorIndex ( FileNumber, AppraiserCode, PersonDesignator 
),
  INDEX AppraiserCodeIndex ( AppraiserCode ),
  INDEX FileNumberIndex ( FileNumber );

To load my data, I execute the following commands

mysql --user=xxx --password=xxx -e "USE Live_Tables; DELETE QUICK FROM 
FeeSplit; FLUSH TABLES;"
mysql --user=xxx --password=xxx -e "USE Live_Tables; LOAD DATA INFILE 
'Converted_FeeSplit.txt' INTO TABLE FeeSplit FIELDS TERMINATED BY ',' 
ENCLOSED BY '\"' ESCAPED BY '~'; "

When these commands have completed, the value of field 5 is *always* 0.00.  
This in and of itself has had me confused - especially since I can execute 
the same SQL commands in MySQLCC and the contents of field 5 will be whatever 
is in my input file.

I had this problem with 4.0.13 as well as now with 4.0.16.

Has anyone seen this before?  And possibly has a "cure" or fix?

Thanks!

Bob


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Andrew]

Worked like a dream Dan

Thanks Paul for being patient :)

Thank you
Andrew

>-Original Message-
>From: Dan Greene [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 21:27
>To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
>Subject: RE: replace query + RTFM?
>
>
>you need to tell mysql what field to equate to the value in your where clause:
>
>update items set ItemDescription = ''
>where ItemDescription = ''
>
>replacing the < > items with the text you have below 
>
>> -Original Message-
>> From: Andrew [mailto:[EMAIL PROTECTED]
>> Sent: Monday, November 17, 2003 4:19 PM
>> To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
>> Subject: RE: replace query + RTFM?
>> 
>> 
>> 
>> 
>> Can someone kindly tell me what I doing wrong and help with 
>> this query?
>> 
>> I want to replace / update the text for every record within 
>> table items field
>> ItemDescription. This is what I have so far and its isn't corroect :(
>> 
>> UPDATE items SET ItemDescription='A-Z Business Directory > /> Please
>> call 0870 199 4080 for further details  Replace 
>> these details simply
>> by calling 0870 199 4080  Unlike YELL we only 
>> list a maximum of 5
>> businesses per Business Category  The chances of 
>> your business being
>> called has been increased already. Be Seen by calling 0870 
>> 199 4080' WHERE 'A-Z
>> Business Directory  Please call 0116 27 960 41 
>> for further details
>>  Replace these details simply by calling 0116 27 
>> 960 41 
>> Unlike YELL we only list a maximum of 5 businesses per 
>> Business Category > /> The chances of your business being called has been 
>> increased already.
>> Be Seen by calling 0116 27 960 41'
>> 
>> Andrew
>> 
>> 
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/[EMAIL PROTECTED]
>> 
>> 
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Win32 vs Linux ?

[yönsis yazilim proje]

Hi,

As I remember : MySQL's programmers use windows tools for developing.

You can use Win32-MySQL  without any problem.
But I suggest APACHE for PHP!

best regards
özgür
YÖNSIS ltd,
Istanbul

- Original Message -
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 3:45 PM
Subject: MySQL on Win32 vs Linux ?


Greetings. Can anyone comment on the stability of MySQL on Win32?

Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.



Thanks for any advice!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replace query + RTFM?

[Gabriel Guzman]

On Monday 17 November 2003 01:18 pm, Andrew wrote:
> Can someone kindly tell me what I doing wrong and help with this query?
>
> I want to replace / update the text for every record within table items
> field ItemDescription. This is what I have so far and its isn't corroect :(
>
> UPDATE items SET ItemDescription='A-Z Business Directory 
> Please call 0870 199 4080 for further details  Replace these
> details simply by calling 0870 199 4080  Unlike YELL we only
> list a maximum of 5 businesses per Business Category  The
> chances of your business being called has been increased already. Be Seen
> by calling 0870 199 4080'

WHERE ItemDescription=

>'A-Z Business Directory  Please
> call 0116 27 960 41 for further details  Replace these details
> simply by calling 0116 27 960 41  Unlike YELL we only list a
> maximum of 5 businesses per Business Category  The chances of
> your business being called has been increased already. Be Seen by calling
> 0116 27 960 41'

should do it. 

gabe. 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Dan Greene]

you need to tell mysql what field to equate to the value in your where clause:

update items set ItemDescription = ''
where ItemDescription = ''

replacing the < > items with the text you have below 

> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 4:19 PM
> To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
> Subject: RE: replace query + RTFM?
> 
> 
> 
> 
> Can someone kindly tell me what I doing wrong and help with 
> this query?
> 
> I want to replace / update the text for every record within 
> table items field
> ItemDescription. This is what I have so far and its isn't corroect :(
> 
> UPDATE items SET ItemDescription='A-Z Business Directory  /> Please
> call 0870 199 4080 for further details  Replace 
> these details simply
> by calling 0870 199 4080  Unlike YELL we only 
> list a maximum of 5
> businesses per Business Category  The chances of 
> your business being
> called has been increased already. Be Seen by calling 0870 
> 199 4080' WHERE 'A-Z
> Business Directory  Please call 0116 27 960 41 
> for further details
>  Replace these details simply by calling 0116 27 
> 960 41 
> Unlike YELL we only list a maximum of 5 businesses per 
> Business Category  /> The chances of your business being called has been 
> increased already.
> Be Seen by calling 0116 27 960 41'
> 
> Andrew
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Andrew]

Can someone kindly tell me what I doing wrong and help with this query?

I want to replace / update the text for every record within table items field
ItemDescription. This is what I have so far and its isn't corroect :(

UPDATE items SET ItemDescription='A-Z Business Directory  Please
call 0870 199 4080 for further details  Replace these details simply
by calling 0870 199 4080  Unlike YELL we only list a maximum of 5
businesses per Business Category  The chances of your business being
called has been increased already. Be Seen by calling 0870 199 4080' WHERE 'A-Z
Business Directory  Please call 0116 27 960 41 for further details
 Replace these details simply by calling 0116 27 960 41 
Unlike YELL we only list a maximum of 5 businesses per Business Category  The chances of your business being called has been increased already.
Be Seen by calling 0116 27 960 41'

Andrew


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Mysql] mysqld ended

[Joakim Ryden]

On Nov 17, 2003, at 12:40 PM, <[EMAIL PROTECTED]> wrote:

Hi, I am installing a binary version of mysql 4.0.7, but I cannot get 
the mysql daemon running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the 
output from the log file.
[...]

031117 15:09:55  Can't start server: Bind on TCP/IP port: Address 
already in use
031117 15:09:55  Do you already have another mysqld server running on 
port: 3306
 ?
'fuser -n tcp 3306' should give you the process id of the process 
holding up the port.

--Jo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: [MySQL] mysqld ended

[Victor Pendleton]

do a ps -ef | grep mysql (or the equivalent for your system) and see if you
have any other mysql daemons running?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 2:40 PM
To: [EMAIL PROTECTED]
Subject: [Mysql] mysqld ended


Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the
mysql daemon running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the
output from the log file.

I am on a Sun Sparc running Debian.

Any help would greatly be appreciated.
Thanks,
Matthew

Command Prompt
--
taco:/usr/local/mysql-standard-4.0.7-gamma-unknown-linux-sparc# Starting
mysqld
daemon with databases from
/usr/local/mysql-standard-4.0.7-gamma-unknown-linux-s
parc/data
031117 15:29:07  mysqld ended

Log File

031117 15:09:55  mysqld started
031117 15:09:55  Can't start server: Bind on TCP/IP port: Address already in
use
031117 15:09:55  Do you already have another mysqld server running on port:
3306
 ?
031117 15:09:55  Aborting

031117 15:09:55  /usr/local/mysql/bin/mysqld: Shutdown Complete

031117 15:09:55  mysqld ended


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[Mysql] mysqld ended

[m_hagen]

Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the mysql daemon 
running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the output from the 
log file.

I am on a Sun Sparc running Debian.

Any help would greatly be appreciated.
Thanks,
Matthew

Command Prompt
--
taco:/usr/local/mysql-standard-4.0.7-gamma-unknown-linux-sparc# Starting mysqld
daemon with databases from /usr/local/mysql-standard-4.0.7-gamma-unknown-linux-s
parc/data
031117 15:29:07  mysqld ended

Log File

031117 15:09:55  mysqld started
031117 15:09:55  Can't start server: Bind on TCP/IP port: Address already in use
031117 15:09:55  Do you already have another mysqld server running on port: 3306
 ?
031117 15:09:55  Aborting

031117 15:09:55  /usr/local/mysql/bin/mysqld: Shutdown Complete

031117 15:09:55  mysqld ended


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Simple comparison operator failure

[philip villars]

Hello All,

 Upon further review, my question involving the 
unexpected comparison operator behavior IS discussed in 
the documentation, specifically section A.5.7 "Problems 
with
Floating-Point Comparison".  My bad -- thought I'd
checked everywhere.

 Doesnt' look like there's a great solution, they 
recommend
deciding what an acceptable "tolerance" is, and basing the
comparison on that.  Anyone know a better solution?

-PV

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Merging duplicate rows

[Peter Sap]

Hi Nathan,

you can use a group by, like this:

select  from table group by 

Put this result in a separate table, delete the data from the old table and
put the the merged rows from the separate table into it.

I tried using a DELETE with a subquery and a group-by, but MySql is not
capable of handling this.

--
Peter Sap

- Original Message -
From: "Nathan Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 4:16 AM
Subject: Merging duplicate rows


> How do you merge duplicate rows?  All rows involved contain identical data
> in each column.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Paul DuBois]

At 2:42 PM -0500 11/17/03, Ola Ogunneye wrote:
Thanks Paul,

Just to be crystal clear, at the mysql prompt, I will typesource
stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Looking something like this:

mysql>source stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Or am I not supposed to include the source stations.sql at all?
You use either source or \. when you enter the command -- not both.
They are synonyms.  That is, at the mysql> prompt, you should type
either this:
\. E:\Apache\apache2\htdocs\public_html\weather\stations.sql

or this:

source E:\Apache\apache2\htdocs\public_html\weather\stations.sql

The semicolon at the end can be given, but need not.


Is there a ; at the end or I do not need one.

Thanks a lot for your response

Ola
 Paul DuBois <[EMAIL PROTECTED]> 11/17/03 02:08PM >>>
At 10:28 AM -0500 11/17/03, Ola Ogunneye wrote:
Can you elaborate please? Like I said, the sql file I am executing is
in
E:\Apache\apache2\htdocs\public_html\weather

I see that you typed \ c>\loadfile.sql - Please explain. I really am
new
to this.
No, he typed \., not \, and c:, not c>.  If you change characters like
that,
you will have little success.
What he meant (I think) was that the general form of the command is:

\. path-to-the-file-you-want-to-load

In your case, at the mysql> prompt, type:

\. E:\Apache\apache2\htdocs\public_html\weather\stations.sql



Thank you

  Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:56AM >>>
\. c:\loadFile.sql
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Reading and Executing a source...
The problem is that I was getting an error message. I am not at home
right now, and should have posted the message last night. However, my
main question is trying to know based on what the instruction says:
Using mysql - connect as your root or other privileged user
   connect to your geeklog database
   Using "source" read in and execute the SQL file
o mysql# source stations.sql;

How do I type the above at the mysql prompt? Do I need to reference the
directory where the stations.sql is residing? the file stations.sql
resides in E:\Apache\apache2\htdocs\public_html\weather\
Do I need to point to this directory in order to execute the query or
how does mysql know where to find the file. If I have to point to it,
do
I then just type at the mysql prompt

mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;

Please advice once again

Thanks
  Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
What seems to be the problem? Are you getting an error message? If so
can
you post the message?
The syntax is \. fileName
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...
I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,
source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.
What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?
I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help
Using mysql - connect as your root or other privileged user
   connect to your geeklog database
   Using "source" read in and execute the SQL file
o mysql# source stations.sql;
 >
Best regards

 >Ola


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Birthday calendar

[Peter Sap]

Hi Olaf,

try something like this:

AND gebdatum between now() and date_add(now(),interval 7 day)

However, I have no idea if this can be done with 3.23.49a.

--
Peter Sap.

- Original Message -
From: "Olaf van Zandwijk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 5:39 PM
Subject: Birthday calendar


> Hello,
>
> I want to have a query that returns the names from people that are
> having their birthday one of the coming 7 days. I currently have a buggy
> query that deals with this, but that query fails when the birthday is
> the next month, and we're now in the last week of the month before.
>
> Can anyone give me a hint in the right direction to do this? I'm using
> MySQL 3.23.49a, and it's not (yet) possible to use MySQL 4
>
> Grtz,
> \Olaf
>
> SELECT month(gebdatum) AS maand,
> dayofmonth(gebdatum) AS dag,
> achternaam,
> CONCAT(roepnaam, ' ', COALESCE(tussenvoegsel, ' '), ' ', achternaam) AS
naam
> FROM persoon,
> WHERE YEAR(gebdatum) IS NOT NULL
> AND 
> AND CONCAT(roepnaam, ' ', COALESCE(tussenvoegsel, ' '), ' ', achternaam)
> IS NOT NULL
> ORDER BY maand,
> dag,
> achternaam
>
> --
>   __XXX__
>(0-0)
> +--ooO--(_)--Ooo---+
> |  |
> | Olaf van Zandwijk|
> |  |
> | ICQ# 30231605|
> | PGP Public Key: http://www.vanzandwijk.net/pgp.txt   |
> +--+



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Ola Ogunneye]

Thanks Paul, 

Just to be crystal clear, at the mysql prompt, I will typesource
stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql

Looking something like this:

mysql>source stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql

Or am I not supposed to include the source stations.sql at all?

Is there a ; at the end or I do not need one.

Thanks a lot for your response

Ola
>>> Paul DuBois <[EMAIL PROTECTED]> 11/17/03 02:08PM >>>
At 10:28 AM -0500 11/17/03, Ola Ogunneye wrote:
>Can you elaborate please? Like I said, the sql file I am executing is
in
>E:\Apache\apache2\htdocs\public_html\weather
>
>I see that you typed \ c>\loadfile.sql - Please explain. I really am
new
>to this.

No, he typed \., not \, and c:, not c>.  If you change characters like
that,
you will have little success.


What he meant (I think) was that the general form of the command is:

\. path-to-the-file-you-want-to-load

In your case, at the mysql> prompt, type:

\. E:\Apache\apache2\htdocs\public_html\weather\stations.sql



>
>Thank you
>
  Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:56AM >>>
>
>\. c:\loadFile.sql
>-Original Message-
>From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
>Sent: Monday, November 17, 2003 7:41 AM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: RE: Reading and Executing a source...
>
>
>The problem is that I was getting an error message. I am not at home
>right now, and should have posted the message last night. However, my
>main question is trying to know based on what the instruction says:
>
>Using mysql - connect as your root or other privileged user
>   connect to your geeklog database
>   Using "source" read in and execute the SQL file
>
>o mysql# source stations.sql;
>
>How do I type the above at the mysql prompt? Do I need to reference the
>directory where the stations.sql is residing? the file stations.sql
>resides in E:\Apache\apache2\htdocs\public_html\weather\
>
>Do I need to point to this directory in order to execute the query or
>how does mysql know where to find the file. If I have to point to it,
do
>I then just type at the mysql prompt
>
>mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;
>
>Please advice once again
>
>Thanks
  Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
>What seems to be the problem? Are you getting an error message? If so
>can
>you post the message?
>The syntax is \. fileName
>
>-Original Message-
>From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
>Sent: Monday, November 17, 2003 7:10 AM
>To: [EMAIL PROTECTED]
>Subject: Reading and Executing a source...
>
>
>I am using a program that says I should use source to read in and
>execute a file. I tried using the direction in Mysql second edition I
>think on page 795 or something thereabout,
>
>source file_name, /. file_name
>
>I do not have the complete syntax, but what I did reesembled something
>like the above. Only thing I chaged was the file_name.
>
>What I needed to do is described below, and I am using mysql 4.0.13 Can
>someone please let me know how to accomplish this?
>
>I have root privilege and I get to the mysql prompt. I also invoked the
>use database command and that was successful, but I just cannot
>accomplish the following...Please Help
>
>
>Using mysql - connect as your root or other privileged user
>   connect to your geeklog database
>   Using "source" read in and execute the SQL file
>
>o mysql# source stations.sql;
>
>Best regards
>
>Ola


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]

Re: Subselect Problem

[Paul DuBois]

At 2:28 PM -0500 11/17/03, Peter J. Krawetzky wrote:
Could someone please tell me what is wrong with this query:

select * from personnel where dept_id not in (select dept_id from
attendance_respond)
I keep getting a 1024 error message.  It looks pretty straightforward to me.

I am running 4.0.16 on Redhat Linux 8.


Subqueries are not implemented until MySQL 4.1.



--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Subselect Problem

[Peter J. Krawetzky]

Could someone please tell me what is wrong with this query:

select * from personnel where dept_id not in (select dept_id from
attendance_respond)

I keep getting a 1024 error message.  It looks pretty straightforward to me.

I am running 4.0.16 on Redhat Linux 8.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Backslash and full text searches

[Jason Ramsey]

Matt,

Yes, database could be cleaned with a query, but I don't even want to think
about the code problem.  I was being hyperbolic with the "500,000"; it's
actually more like 50,000 lines of code - but still, who wants to change
50,000 lines of code.  And yes, it's PHP.

However, as an update, I did some tests on another installation of the
software we have on a different server, and it was actually matching the
"\".  The "problem" server will match with something like "... WHERE Field
REGEXP 'somebody.?'s'" so mysql knows there's a character there, it just
won't allow you to escape the "\" to be able to use it.  I'm going to do a
configuration comparison for both php and mysql between the two boxes and
try to hunt down the problem.

-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 15, 2003 3:20 PM
To: Jason Ramsey; [EMAIL PROTECTED]
Subject: Re: Backslash and full text searches


Hi Jason,

Sorry for the late reply.

If all of the 100,000 entries have extra backslashes, that can be fixed
with a query. But then you have all your code. :-(

Speaking of code, what language are you using? I always assume PHP, but
with 500k lines I'm thinking you're using C?

Is somebody\'s the only word you're trying to match? I just tried it and
I can't get somebody\'s to match even as a phrase in BOOLEAN mode
because the "somebody" part is a stopword. However, Matt\'s works. If
you can't match a non-stopword, are you sure the correct amount of
backslashes are making it to MySQL, or are they being lost as escape
characters in your programming language first?

My results:

mysql> CREATE TABLE test (test TEXT NOT NULL, FULLTEXT (test));
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO test VALUES ('This is Matt\\\'s text.'), ('Text by
Matt.');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM test;
+---+
| test  |
+---+
| This is Matt\'s text. |
| Text by Matt. |
+---+
2 rows in set (0.00 sec)

mysql> -- This just matches the Matt part
mysql> SELECT * FROM test WHERE MATCH (test) AGAINST('Matt\\\'s' IN
BOOLEAN MODE);
+---+
| test  |
+---+
| This is Matt\'s text. |
| Text by Matt. |
+---+
2 rows in set (0.00 sec)

mysql> -- Exact phrase
mysql> SELECT * FROM test WHERE MATCH (test) AGAINST(' "Matt\\\'s" ' IN
BOOLEAN MODE);
+---+
| test  |
+---+
| This is Matt\'s text. |
+---+
1 row in set (0.00 sec)


Matt


- Original Message -
From: "Jason Ramsey"
Sent: Thursday, November 13, 2003 6:41 PM
Subject: RE: Backslash and full text searches


> Thanks for your answer, you can see my comments below.
>
> -Original Message-
> From: Matt W
> Sent: Thursday, November 13, 2003 3:36 PM
> To: Jason Ramsey; [EMAIL PROTECTED]
> Subject: Re: Backslash and full text searches
>
>
> Hi Jason,
>
> Of course somebody's isn't going to match somebody\'s. :-) somebody\'s
> should match somebody\'s -- because it's really matching the
"somebody"
> part.
>
> ^ That makes sense to me, and the behavior I would have expected;
except, it
> doesn't seem to work that way.  Anything I try I can't get
"somebody\'s" to
> match a field in the database.
>
> If you're using 4+, you can use IN BOOLEAN MODE to match
> somebody\'s exactly:
>
> MATCH (col) AGAINST (' "somebody\\\'s" ' IN BOOLEAN MODE)
>
> ^ Unfortunatley, this doesn't work.  I've tried several variations,
but
> can't seem to match useing MATCH, LIKE or even "=".
>
> However, I get the feeling that you're not really wanting to match a
> word that has a backslash in it. e.g. You're getting extra
backslashes.
> mysql_escape_string()/addslashes() *DOES NOT* store the backslashes in
> the table -- it's not even *possible* since they're only escape
> characters in the query. If you're getting any extra backslashes when
> retrieving data, too many were added during insertion -- you ran
> mysql_escape_string/addslashes too many times. This happens if PHP's
> stupid magic_quotes_gpc is on and you don't check for that.
>
> ^hmm.  Well, that certainly is different than what I understood, and
helpful
> information.  It looks like magic_quotes_gpc is on.  However, now I
have a
> problem that we have a 100,000 entries in the database like this, and
> 500,000 lines of code expecting the backslash.  I really need to find
a
> solution so that I can search and somehow account for the "\" in my
> searches.  Any help would be appreciated.
>
>
> Your text should come out exactly the way it was intended. Never, ever
> any need for stripslashes(), etc. if it was inserted correctly. :-)
>
>
> Hope that helps.
>
>
> Matt
>
>
>
> - Original Message -
> From: "Jason Ramsey"
> Sent: Thursday, November 13, 2003 4:10 PM
> Subject: Backslash and full text searches
>
>
> > We 

RE: replace query + RTFM?

[Andrew]

>Looks to me like you want to use UPDATE instead.  Specify a WHERE clause
>that identifies the rows you want to update, and in the SET clause specify
>the new value for the description column.
>
>To pre-flight your UPDATE, you can write a SELECT that has the same WHERE
>clause. This will show you whether or not you are indeed identifying the
>proper rows.
>

thank you paul

Indeed I think you are right and if memory serves me correct you supplied my
solution the first time ;)

I thought I had saved the query for the next time I needed it! As it happens I
can't find it.  I'll have a read on the UPDATE and see if I can work it out.

Thank you
Andrew


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: User Variables

[Paul DuBois]

At 6:45 PM + 11/17/03, Bruno Mustone wrote:
Hmmm they seem to work in version 3.23.57.
Given that they were introduced in 3.23.6 (as stated below), that
is not surprising.

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 18:38
To: Bruno Mustone; [EMAIL PROTECTED]
Subject: Re: User Variables
At 12:05 PM + 11/17/03, Bruno Mustone wrote:
Hi Guys,

Do you know what version user variables were introduced? I can't seem
to get them working in 3.22 and yet they work in 3.23.
They were introduced in 3.23.6.


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Paul DuBois]

At 10:28 AM -0500 11/17/03, Ola Ogunneye wrote:
Can you elaborate please? Like I said, the sql file I am executing is in
E:\Apache\apache2\htdocs\public_html\weather
I see that you typed \ c>\loadfile.sql - Please explain. I really am new
to this.
No, he typed \., not \, and c:, not c>.  If you change characters like that,
you will have little success.
What he meant (I think) was that the general form of the command is:

\. path-to-the-file-you-want-to-load

In your case, at the mysql> prompt, type:

\. E:\Apache\apache2\htdocs\public_html\weather\stations.sql



Thank you

 Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:56AM >>>
\. c:\loadFile.sql
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Reading and Executing a source...
The problem is that I was getting an error message. I am not at home
right now, and should have posted the message last night. However, my
main question is trying to know based on what the instruction says:
Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file
o mysql# source stations.sql;

How do I type the above at the mysql prompt? Do I need to reference the
directory where the stations.sql is residing? the file stations.sql
resides in E:\Apache\apache2\htdocs\public_html\weather\
Do I need to point to this directory in order to execute the query or
how does mysql know where to find the file. If I have to point to it, do
I then just type at the mysql prompt
mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;

Please advice once again

Thanks
 Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
What seems to be the problem? Are you getting an error message? If so
can
you post the message?
The syntax is \. fileName
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...
I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,
source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.
What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?
I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help
Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file
o mysql# source stations.sql;

Best regards

Ola


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Paul DuBois]

At 6:39 PM + 11/17/03, Andrew wrote:
I understand what the manual is saying and I was asking for confirmation that
what I was doing was indeed the right way forward, instead of going a head and
potentially fucking up 2500 records!
But alas it seems that people are repared to 
spend more time writing shite about
reading manuals and reading manuals and how to read manual and acronymn and
reading manual and areading manuals and reading 
manual and areading manuals and
reading manual and areading manuals and reading 
manual and areading manuals and
reading manual and areading manuals and reading 
manual and areading manuals and
reading manual and areading manuals and reading manual and areading manualsand
reading manual and areading manuals

must remind myself I am human one day!
Hmm...

As far as I can tell, this thread began with you saying that you had a
query to do what you want, but that you lost it and can someone help?
I think you'll have to admit that we are not mind-readers, so we cannot
tell you what your original query was.
In any case, I do not think that REPLACE is what you want, if what you want
to do is replace only the description column 
value.  REPLACE requires values for
all the columns; if you omit certain columns, MySQL will set them to their
default values, which doesn't seem like what you want.

Looks to me like you want to use UPDATE instead.  Specify a WHERE clause
that identifies the rows you want to update, and in the SET clause specify
the new value for the description column.
To pre-flight your UPDATE, you can write a SELECT that has the same WHERE
clause. This will show you whether or not you are indeed identifying the
proper rows.



-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 18:31
To: [EMAIL PROTECTED]; MySQL-Lista; Rodolphe Toots
Subject: RE: replace query + RTFM?
Andrew,

Please allow a small amount of grief to come from these lists...
People are usually glad to help, and Mike sent the info that he knew
to you.  There is a certain amount of frustration that develops when
people repeatedly ask questions of the mailing list that are clearly
documented in the mysql documentation.  Suggesting to read the manual
is not a bad thing, and RTFM is a long stading acronym that nobody on
this list invented, and I guarentee everyone on this list is guilty of
asking a question that is in the documentation for some product /
project they were working on.
The MySQL documentation is, IMHO (in my humble opinion - another oldie
acronym), incredibly good for a free product.  Searching it for
answers, particularly about syntax, should be everyone's, including
my, first step in solving an issue that we're having.
[getting down off of soap box]

Dan Greene

 -Original Message-
 From: Andrew [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 17, 2003 1:16 PM
 To: MySQL-Lista; Rodolphe Toots
 Subject: RE: replace query + RTFM?
 amazing, and you guys are errr intelligent!!! can't actually
 help but you can
 make an abbreviation for RTFM how f#$#$ng sad is that, what a
 bunch of pathetic
 losers.
 >-Original Message-
 >From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
 >Sent: 17 November 2003 18:11
 >To: [EMAIL PROTECTED]
 >Subject: SV: replace query + RTFM?
 >
 >
 >RTFM = "read the fing manual"..
 >
 >-Ursprungligt meddelande-
 >Från: Andrew [mailto:[EMAIL PROTECTED]
 >Skickat: den 17 november 2003 18:55
 >Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista
 >Ämne: RE: replace query + RTFM?
 >
 >
 >Hi Mike
 >
 >I really appreciate you getting back to me so quickly :)
 >
 >Can I just clarify this becuse I have over 4000 records and
 >> not all of the
 >records have anything in items - description but there are about 2500
 >records
 >with this exact text->
 >
 >A-Z Business Directory  Please call 0116
 27 960 41 for
 >further
 >details  Replace these details with yours simply
 by calling 0116
 >27
 >960 41  Unlike YELL we only list a maximum of 5
 businesses per
 >Business Category  The chances of your business
 being called has
 >been increased already. Be Seen by calling 0116 27 960 41 or
 HREF="http://www.punterspower.co.uk/register_online.php";>registering
 >onlineNo Web Site neededNo Internet
 >knowledge
 >requiredAll administration carried out by
 usAll contacts
 >forwarded to youComprehensive Company
 detailsLink to your
 >own
 >web siteYou can add html within your description making your
 >profile
 >suitLogin access to administer and change you
 details whenever you
 >need
 >to
 >
 >and it just the telephone I want to change :)
 >
 >so is the correct query>
 >
 >REPLACE items SET description="new telphone number" WHERE
 (old telephone
 >number)
 >
 >Thank you so much
 >
 >Andrew
 >
 >PS what does RTFM mean?
 >
 >
 >>-Original Message-
 >>From: Mikael Fridh [mailto:[EMAIL PROTECTED]
 >>Sent: 17 November 2003 17:12
 >>To: [EMAIL PROTECTED]; MySQL-Lista
 >>Subject: Re: replace query
 >>
 >>
 >>On Monday 17 November 

RE: User Variables

[Bruno Mustone]

Hmmm they seem to work in version 3.23.57.

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: 17 November 2003 18:38
To: Bruno Mustone; [EMAIL PROTECTED]
Subject: Re: User Variables


At 12:05 PM + 11/17/03, Bruno Mustone wrote:
>Hi Guys,
>
>Do you know what version user variables were introduced? I can't seem 
>to get them working in 3.22 and yet they work in 3.23.
>

They were introduced in 3.23.6.


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Deleting tables?

[Ola Ogunneye]

I have created tables in mysql using a weblog. I now realize that I need
to reinstall the plugin that I originally installed. Can someone tell me
how to delete specific table from a database?

I use phpmyadmin to manage mysql and I figured checking the check boxes
next to the tables that I want to delete, and clicking on the DROP,
would do the trick, is this correct?

Thank you in advance

RE: replace query + RTFM?

[Andrew]

I understand what the manual is saying and I was asking for confirmation that
what I was doing was indeed the right way forward, instead of going a head and
potentially fucking up 2500 records!

But alas it seems that people are repared to spend more time writing shite about
reading manuals and reading manuals and how to read manual and acronymn and
reading manual and areading manuals and reading manual and areading manuals and
reading manual and areading manuals and reading manual and areading manuals and
reading manual and areading manuals and reading manual and areading manuals and
reading manual and areading manuals and reading manual and areading manualsand
reading manual and areading manuals

must remind myself I am human one day!

>-Original Message-
>From: Dan Greene [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 18:31
>To: [EMAIL PROTECTED]; MySQL-Lista; Rodolphe Toots
>Subject: RE: replace query + RTFM?
>
>
>Andrew,
>
>Please allow a small amount of grief to come from these lists...
>People are usually glad to help, and Mike sent the info that he knew
>to you.  There is a certain amount of frustration that develops when
>people repeatedly ask questions of the mailing list that are clearly
>documented in the mysql documentation.  Suggesting to read the manual
>is not a bad thing, and RTFM is a long stading acronym that nobody on
>this list invented, and I guarentee everyone on this list is guilty of
>asking a question that is in the documentation for some product /
>project they were working on.
>
>The MySQL documentation is, IMHO (in my humble opinion - another oldie
>acronym), incredibly good for a free product.  Searching it for
>answers, particularly about syntax, should be everyone's, including
>my, first step in solving an issue that we're having.
>
>[getting down off of soap box]
>
>Dan Greene
>
>> -Original Message-
>> From: Andrew [mailto:[EMAIL PROTECTED]
>> Sent: Monday, November 17, 2003 1:16 PM
>> To: MySQL-Lista; Rodolphe Toots
>> Subject: RE: replace query + RTFM?
>>
>>
>> amazing, and you guys are errr intelligent!!! can't actually
>> help but you can
>> make an abbreviation for RTFM how f#$#$ng sad is that, what a
>> bunch of pathetic
>> losers.
>>
>> >-Original Message-
>> >From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
>> >Sent: 17 November 2003 18:11
>> >To: [EMAIL PROTECTED]
>> >Subject: SV: replace query + RTFM?
>> >
>> >
>> >RTFM = "read the fing manual"..
>> >
>> >-Ursprungligt meddelande-
>> >Från: Andrew [mailto:[EMAIL PROTECTED]
>> >Skickat: den 17 november 2003 18:55
>> >Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista
>> >Ämne: RE: replace query + RTFM?
>> >
>> >
>> >Hi Mike
>> >
>> >I really appreciate you getting back to me so quickly :)
>> >
>> >Can I just clarify this becuse I have over 4000 records and
>> not all of the
>> >records have anything in items - description but there are about 2500
>> >records
>> >with this exact text->
>> >
>> >A-Z Business Directory  Please call 0116
>> 27 960 41 for
>> >further
>> >details  Replace these details with yours simply
>> by calling 0116
>> >27
>> >960 41  Unlike YELL we only list a maximum of 5
>> businesses per
>> >Business Category  The chances of your business
>> being called has
>> >been increased already. Be Seen by calling 0116 27 960 41 or
>> > >HREF="http://www.punterspower.co.uk/register_online.php";>registering
>> >onlineNo Web Site neededNo Internet
>> >knowledge
>> >requiredAll administration carried out by
>> usAll contacts
>> >forwarded to youComprehensive Company
>> detailsLink to your
>> >own
>> >web siteYou can add html within your description making your
>> >profile
>> >suitLogin access to administer and change you
>> details whenever you
>> >need
>> >to
>> >
>> >and it just the telephone I want to change :)
>> >
>> >so is the correct query>
>> >
>> >REPLACE items SET description="new telphone number" WHERE
>> (old telephone
>> >number)
>> >
>> >Thank you so much
>> >
>> >Andrew
>> >
>> >PS what does RTFM mean?
>> >
>> >
>> >>-Original Message-
>> >>From: Mikael Fridh [mailto:[EMAIL PROTECTED]
>> >>Sent: 17 November 2003 17:12
>> >>To: [EMAIL PROTECTED]; MySQL-Lista
>> >>Subject: Re: replace query
>> >>
>> >>
>> >>On Monday 17 November 2003 18.04, Andrew wrote:
>> >>> I have a MySQL database with records in a table that i
>> would like to
>> >>> replace. The table is
>> >>>
>> >>> items and the field is description.  I would like to
>> replace the existing
>> >>> text within this filed with some new text.
>> >>>
>> >>> I did this before and it was successful but I have lost
>> the query to do
>> >it
>> >>> :(
>> >>>
>> >>> Could someone shed some light in this please :)
>> >>>
>> >>> Andrew
>> >>
>> >>http://www.mysql.com/doc/en/Data_Manipulation.html
>> >>
>> >>REPLACE items SET description="RTFM" WHERE ...(insert your
>> where clause
>> >here)
>> >>
>> >>Mike
>> >>
>> >>--
>> >>MySQL General Mailing List
>> >>For list archives: http://lists.mysql.com/mys

Re: User Variables

[Paul DuBois]

At 12:05 PM + 11/17/03, Bruno Mustone wrote:
Hi Guys,

Do you know what version user variables were introduced? I can't seem to
get them working in 3.22 and yet they work in 3.23.
They were introduced in 3.23.6.

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The correct way to deal with name_1, name_2, name_3

[Stephen Fromm]

- Original Message - 
From: "Paul Fine" <[EMAIL PROTECTED]>
To: "'Stephen Fromm'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 11:49 AM
Subject: RE: The correct way to deal with name_1, name_2, name_3


Thanks.

I do mean " Do you mean one column for each name, in which case these would
comprise 10 columns, most of which would have NULL most of the time?"

SF:  OK

Is this your suggestion in this case:

Table 1
| blahblah | blah | blah | CustID (PK) |


Table 2
| CustID (FK) | Name |

Table 2 Sample Data
| 11 | Bart |
| 11 | Jamie|
| 11 | Bob |

SF:  Mostly.
Perhaps I'm not getting your design right, but to me CustID should be a PK
in Table 2 and an FK in Table 1.  It might also be a PK in Table 1, but that
depends on the semantics of the table.  But maybe that's not what you want
because the CustID in the example you gave (in Table 2) is not unique for 3
different rows.

Therefore I can select NAME from Table 2 where CustID matches Table 1 and
thus have all the names required?

SF:  That's the basic idea.  But given my confusion above, you should
provide more details on the meaning of the tables.

Thanks!




-Original Message-
From: Stephen Fromm [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:01 AM
To: Paul Fine; [EMAIL PROTECTED]
Subject: Re: The correct way to deal with name_1, name_2, name_3


- Original Message - 
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 10:37 AM
Subject: The correct way to deal with name_1, name_2, name_3


> Greetings, I would be greatful for any advice on the correct way to do
this.
>
> If I have something dynamic, for example customer names where usually
there
> are 1 or 2 unique customer names but possibly say up to 10, what is the
> "correct" design?
>
> For example I could simply create a table with name_1, name_2, name_3
> 10. I am sure there is a more efficient way to do this.

Could you be more specific?

Do you mean one column for each name, in which case these would comprise 10
columns, most of which would have NULL most of the time?

Or do you mean a separate row, one of whose columns is customer_name, with
one of 10 values?

I can't say much because of lack of detail (i.e., what's in the rest of the
table), but I'd have TWO tables.  In the table you're discussing, I'd have a
column called cust_id.  In another table, the "customer" table, I'd have two
entries, cust_id and cust_name.  cust_id in the original table would be a
foreign key pointing at the customer table...




> Thanks!
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Dan Greene]

Andrew, 

Please allow a small amount of grief to come from these lists...  People are usually 
glad to help, and Mike sent the info that he knew to you.  There is a certain amount 
of frustration that develops when people repeatedly ask questions of the mailing list 
that are clearly documented in the mysql documentation.  Suggesting to read the manual 
is not a bad thing, and RTFM is a long stading acronym that nobody on this list 
invented, and I guarentee everyone on this list is guilty of asking a question that is 
in the documentation for some product / project they were working on.

The MySQL documentation is, IMHO (in my humble opinion - another oldie acronym), 
incredibly good for a free product.  Searching it for answers, particularly about 
syntax, should be everyone's, including my, first step in solving an issue that we're 
having.

[getting down off of soap box]

Dan Greene

> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 1:16 PM
> To: MySQL-Lista; Rodolphe Toots
> Subject: RE: replace query + RTFM?
> 
> 
> amazing, and you guys are errr intelligent!!! can't actually 
> help but you can
> make an abbreviation for RTFM how f#$#$ng sad is that, what a 
> bunch of pathetic
> losers.
> 
> >-Original Message-
> >From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
> >Sent: 17 November 2003 18:11
> >To: [EMAIL PROTECTED]
> >Subject: SV: replace query + RTFM?
> >
> >
> >RTFM = "read the fing manual"..
> >
> >-Ursprungligt meddelande-
> >Från: Andrew [mailto:[EMAIL PROTECTED]
> >Skickat: den 17 november 2003 18:55
> >Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista
> >Ämne: RE: replace query + RTFM?
> >
> >
> >Hi Mike
> >
> >I really appreciate you getting back to me so quickly :)
> >
> >Can I just clarify this becuse I have over 4000 records and 
> not all of the
> >records have anything in items - description but there are about 2500
> >records
> >with this exact text->
> >
> >A-Z Business Directory  Please call 0116 
> 27 960 41 for
> >further
> >details  Replace these details with yours simply 
> by calling 0116
> >27
> >960 41  Unlike YELL we only list a maximum of 5 
> businesses per
> >Business Category  The chances of your business 
> being called has
> >been increased already. Be Seen by calling 0116 27 960 41 or 
>  >HREF="http://www.punterspower.co.uk/register_online.php";>registering
> >onlineNo Web Site neededNo Internet
> >knowledge
> >requiredAll administration carried out by 
> usAll contacts
> >forwarded to youComprehensive Company 
> detailsLink to your
> >own
> >web siteYou can add html within your description making your
> >profile
> >suitLogin access to administer and change you 
> details whenever you
> >need
> >to
> >
> >and it just the telephone I want to change :)
> >
> >so is the correct query>
> >
> >REPLACE items SET description="new telphone number" WHERE 
> (old telephone
> >number)
> >
> >Thank you so much
> >
> >Andrew
> >
> >PS what does RTFM mean?
> >
> >
> >>-Original Message-
> >>From: Mikael Fridh [mailto:[EMAIL PROTECTED]
> >>Sent: 17 November 2003 17:12
> >>To: [EMAIL PROTECTED]; MySQL-Lista
> >>Subject: Re: replace query
> >>
> >>
> >>On Monday 17 November 2003 18.04, Andrew wrote:
> >>> I have a MySQL database with records in a table that i 
> would like to
> >>> replace. The table is
> >>>
> >>> items and the field is description.  I would like to 
> replace the existing
> >>> text within this filed with some new text.
> >>>
> >>> I did this before and it was successful but I have lost 
> the query to do
> >it
> >>> :(
> >>>
> >>> Could someone shed some light in this please :)
> >>>
> >>> Andrew
> >>
> >>http://www.mysql.com/doc/en/Data_Manipulation.html
> >>
> >>REPLACE items SET description="RTFM" WHERE ...(insert your 
> where clause
> >here)
> >>
> >>Mike
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:
> >http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >>---
> >>Incoming mail is certified Virus Free.
> >>Checked by AVG anti-virus system (http://www.grisoft.com).
> >>Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003
> >>
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003
> >
> 
> 

> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Simple comparison operator failure

[philip villars]

I encountered a problem where a simple comparison
operation seemed to fail.
Has anyone else seen this?  Take a simple table:

  a FLOAT(10, 2)
  b DOUBLE
With data:

 +--+--+
 | a| b|
 +--+--+
 | 1.50 |1 |
 | 6.00 |4 |
 | 5.60 |4 |
 +--+--+
Then do a simple query involving the >= comparison
operator:
 SELECT a, b, 1.40 * b, a >= 1.40 * b FROM t1;

which returns:

 +--+--+--+---+
 | a| b| 1.40 * b | a >= 1.40 * b |
 +--+--+--+---+
 | 1.50 |1 |  1.4 | 1 |
 | 6.00 |4 |  5.6 | 1 |
 | 5.60 |4 |  5.6 | 0 |
 +--+--+--+---+
What's up with row 3 !?  The comparision should most
definitely return true.  The really wierd thing
is that the error does NOT occur if you use these
values and a factor of 1.5.  I came across this
purely by accident -- I can't get the same error
for different values and/or factors.
Note that a and b are different types, if I alter
the table so that both column are REAL, then the
error does not occur.  So, it's pretty cleare what's
going on -- would it be safe to say this is a bug?
-PV

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Andrew]

amazing, and you guys are errr intelligent!!! can't actually help but you can
make an abbreviation for RTFM how fucking sad is that, what a bunch of pathetic
losers.

>-Original Message-
>From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 18:11
>To: [EMAIL PROTECTED]
>Subject: SV: replace query + RTFM?
>
>
>RTFM = "read the fucking manual"..
>
>-Ursprungligt meddelande-
>Från: Andrew [mailto:[EMAIL PROTECTED]
>Skickat: den 17 november 2003 18:55
>Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista
>Ämne: RE: replace query + RTFM?
>
>
>Hi Mike
>
>I really appreciate you getting back to me so quickly :)
>
>Can I just clarify this becuse I have over 4000 records and not all of the
>records have anything in items - description but there are about 2500
>records
>with this exact text->
>
>A-Z Business Directory  Please call 0116 27 960 41 for
>further
>details  Replace these details with yours simply by calling 0116
>27
>960 41  Unlike YELL we only list a maximum of 5 businesses per
>Business Category  The chances of your business being called has
>been increased already. Be Seen by calling 0116 27 960 41 or HREF="http://www.punterspower.co.uk/register_online.php";>registering
>onlineNo Web Site neededNo Internet
>knowledge
>requiredAll administration carried out by usAll contacts
>forwarded to youComprehensive Company detailsLink to your
>own
>web siteYou can add html within your description making your
>profile
>suitLogin access to administer and change you details whenever you
>need
>to
>
>and it just the telephone I want to change :)
>
>so is the correct query>
>
>REPLACE items SET description="new telphone number" WHERE (old telephone
>number)
>
>Thank you so much
>
>Andrew
>
>PS what does RTFM mean?
>
>
>>-Original Message-
>>From: Mikael Fridh [mailto:[EMAIL PROTECTED]
>>Sent: 17 November 2003 17:12
>>To: [EMAIL PROTECTED]; MySQL-Lista
>>Subject: Re: replace query
>>
>>
>>On Monday 17 November 2003 18.04, Andrew wrote:
>>> I have a MySQL database with records in a table that i would like to
>>> replace. The table is
>>>
>>> items and the field is description.  I would like to replace the existing
>>> text within this filed with some new text.
>>>
>>> I did this before and it was successful but I have lost the query to do
>it
>>> :(
>>>
>>> Could someone shed some light in this please :)
>>>
>>> Andrew
>>
>>http://www.mysql.com/doc/en/Data_Manipulation.html
>>
>>REPLACE items SET description="RTFM" WHERE ...(insert your where clause
>here)
>>
>>Mike
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
>http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>>---
>>Incoming mail is certified Virus Free.
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003
>>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

[Andrew]

Hi Mike

I really appreciate you getting back to me so quickly :)

Can I just clarify this becuse I have over 4000 records and not all of the
records have anything in items - description but there are about 2500 records
with this exact text->

A-Z Business Directory  Please call 0116 27 960 41 for further
details  Replace these details with yours simply by calling 0116 27
960 41  Unlike YELL we only list a maximum of 5 businesses per
Business Category  The chances of your business being called has
been increased already. Be Seen by calling 0116 27 960 41 or http://www.punterspower.co.uk/register_online.php";>registering
onlineNo Web Site neededNo Internet knowledge
requiredAll administration carried out by usAll contacts
forwarded to youComprehensive Company detailsLink to your own
web siteYou can add html within your description making your profile
suitLogin access to administer and change you details whenever you need
to

and it just the telephone I want to change :)

so is the correct query>

REPLACE items SET description="new telphone number" WHERE (old telephone number)

Thank you so much

Andrew

PS what does RTFM mean?


>-Original Message-
>From: Mikael Fridh [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 17:12
>To: [EMAIL PROTECTED]; MySQL-Lista
>Subject: Re: replace query
>
>
>On Monday 17 November 2003 18.04, Andrew wrote:
>> I have a MySQL database with records in a table that i would like to
>> replace. The table is
>>
>> items and the field is description.  I would like to replace the existing
>> text within this filed with some new text.
>>
>> I did this before and it was successful but I have lost the query to do it
>> :(
>>
>> Could someone shed some light in this please :)
>>
>> Andrew
>
>http://www.mysql.com/doc/en/Data_Manipulation.html
>
>REPLACE items SET description="RTFM" WHERE ...(insert your where clause here)
>
>Mike
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: secure automated access (was "Re: Backing up all databases")

[Ed Leafe]

On Monday, November 17, 2003, at 11:51  AM, Michael Stassen wrote:

I'm glad this worked for you, but now I'm confused.  The manual 
clearly indicates the use of quotes around the password.  See 
.  The "typical user 
option file" starts with

  [client]
  # The following password will be sent to all standard MySQL clients
  password="my_password"
On the same page it also says:

  option=value
  This is equivalent to --option=value on the command-line. Please
  note that you must quote an argument using double quotes, if the
  argument for an option contains a comment character.
(Comment characters are # and ;)  My reading of this is that quotes, 
though not always required, should always work.  Furthermore, quotes 
are required in certain circumstances (special characters in 
password). This is how it works for me.  I have quotes around my 
password in .my.cnf, and it works. (No, my password doesn't contain 
quotes, though I've tried a password that does contain a quote.  It 
didn't make any difference.)  I can remove the quotes and it still 
works, so long as my password doesn't contain a comment character.

On the other hand, Randall's problem was fixed by removing the quotes. 
Perhaps a certain character (or characters) in a password make quotes 
not work?  If so, the manual should be fixed to reflect this.

Ed, you seem certain that quotes are incorrect, contrary to the 
manual.Perhaps you could elaborate?
	I remember first trying this with quotes as indicated in the manual, 
and it didn't work. On a hunch I removed the quotes, thinking that it 
would then resemble the command-line format better. This worked. I left 
it that way, figuring that the manual was worded incorrectly; i.e., 
that double-quotes were only to be used when the password contained 
comment characters.

	I'm using 4.1.0-alpha running on RH *, if that makes any difference.

 ___/
/
   __/
  /
 /
 Ed Leafe
Linux Love:
unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replace query

[Mikael Fridh]

On Monday 17 November 2003 18.04, Andrew wrote:
> I have a MySQL database with records in a table that i would like to
> replace. The table is
>
> items and the field is description.  I would like to replace the existing
> text within this filed with some new text.
>
> I did this before and it was successful but I have lost the query to do it
> :(
>
> Could someone shed some light in this please :)
>
> Andrew

http://www.mysql.com/doc/en/Data_Manipulation.html

REPLACE items SET description="RTFM" WHERE ...(insert your where clause here)

Mike

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replace query

[Andrew]

I have a MySQL database with records in a table that i would like to replace.
The table is

items and the field is description.  I would like to replace the existing text
within this filed with some new text.

I did this before and it was successful but I have lost the query to do it :(

Could someone shed some light in this please :)

Andrew


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replace field records

[Andrew]

mysql test

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: secure automated access (was "Re: Backing up all databases")

[Michael Stassen]

Ed Leafe wrote:

On Monday, November 17, 2003, at 02:58  AM, Michael Stassen wrote:

cat $HOME/.my.cnf
[client]
password="rootpassword"
/usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: 
YES)
Oh.  That changes things.  The error says "Using password: YES".  (You 
told me it said "Using password: NO" before).  That would indicate 
that mysql did read your .my.cnf file, but doesn't believe it contains 
the correct password.  Double-check you don't have a typo in there.  
Another possibility might be a special character such as a " or # in 
the password.
 
There's the problem. Your original advice was to include:

In the case of root cron jobs then, you need a .my.cnf readable only by
root in root's home.  It should include
[client]
password="mysql_root_password"


This is incorrect, unless the double quotes are part of the 
password. Removing them so that the entry reads:

[client]
password=mysql_root_password
will correct the problem.

Randall Perry wrote:

That was it. Thanks everyone for the help.
I'm glad this worked for you, but now I'm confused.  The manual clearly 
indicates the use of quotes around the password.  See 
.  The "typical user 
option file" starts with

  [client]
  # The following password will be sent to all standard MySQL clients
  password="my_password"
On the same page it also says:

  option=value
  This is equivalent to --option=value on the command-line. Please
  note that you must quote an argument using double quotes, if the
  argument for an option contains a comment character.
(Comment characters are # and ;)  My reading of this is that quotes, 
though not always required, should always work.  Furthermore, quotes are 
required in certain circumstances (special characters in password). 
This is how it works for me.  I have quotes around my password in 
.my.cnf, and it works. (No, my password doesn't contain quotes, though 
I've tried a password that does contain a quote.  It didn't make any 
difference.)  I can remove the quotes and it still works, so long as my 
password doesn't contain a comment character.

On the other hand, Randall's problem was fixed by removing the quotes. 
Perhaps a certain character (or characters) in a password make quotes 
not work?  If so, the manual should be fixed to reflect this.

Ed, you seem certain that quotes are incorrect, contrary to the manual. 
   Perhaps you could elaborate?

Michael







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: The correct way to deal with name_1, name_2, name_3

[Paul Fine]

Thanks. 

I do mean " Do you mean one column for each name, in which case these would
comprise 10 columns, most of which would have NULL most of the time?"

Is this your suggestion in this case:

Table 1
| blahblah | blah | blah | CustID (PK) |


Table 2
| CustID (FK) | Name |

Table 2 Sample Data
| 11 | Bart |
| 11 | Jamie|
| 11 | Bob |


Therefore I can select NAME from Table 2 where CustID matches Table 1 and
thus have all the names required?

Thanks!




-Original Message-
From: Stephen Fromm [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 17, 2003 10:01 AM
To: Paul Fine; [EMAIL PROTECTED]
Subject: Re: The correct way to deal with name_1, name_2, name_3


- Original Message - 
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 10:37 AM
Subject: The correct way to deal with name_1, name_2, name_3


> Greetings, I would be greatful for any advice on the correct way to do
this.
>
> If I have something dynamic, for example customer names where usually
there
> are 1 or 2 unique customer names but possibly say up to 10, what is the
> "correct" design?
>
> For example I could simply create a table with name_1, name_2, name_3
> 10. I am sure there is a more efficient way to do this.

Could you be more specific?

Do you mean one column for each name, in which case these would comprise 10
columns, most of which would have NULL most of the time?

Or do you mean a separate row, one of whose columns is customer_name, with
one of 10 values?

I can't say much because of lack of detail (i.e., what's in the rest of the
table), but I'd have TWO tables.  In the table you're discussing, I'd have a
column called cust_id.  In another table, the "customer" table, I'd have two
entries, cust_id and cust_name.  cust_id in the original table would be a
foreign key pointing at the customer table...




> Thanks!
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Errors compiling Mysql 4.0.16 on fedora core 1

[Daniele Paoni]

Hello,  I tried to compile the latest mysql rpm on fedora. 
The compilation is ok , but when I try to install the compiled
MySQL-client rpm the system exits with:

 perl(the) is needed by MySQL-client-4.0.16-0

Does someone have an idea? 
Thanks

Daniele



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Birthday calendar

[Olaf van Zandwijk]

Hello,

I want to have a query that returns the names from people that are 
having their birthday one of the coming 7 days. I currently have a buggy 
query that deals with this, but that query fails when the birthday is 
the next month, and we're now in the last week of the month before.

Can anyone give me a hint in the right direction to do this? I'm using 
MySQL 3.23.49a, and it's not (yet) possible to use MySQL 4

Grtz,
\Olaf
SELECT month(gebdatum) AS maand,
dayofmonth(gebdatum) AS dag,
achternaam,
CONCAT(roepnaam, ' ', COALESCE(tussenvoegsel, ' '), ' ', achternaam) AS naam
FROM persoon,
WHERE YEAR(gebdatum) IS NOT NULL
AND 
AND CONCAT(roepnaam, ' ', COALESCE(tussenvoegsel, ' '), ' ', achternaam) 
IS NOT NULL
ORDER BY maand,
dag,
achternaam

--
 __XXX__
  (0-0)
+--ooO--(_)--Ooo---+
|  |
| Olaf van Zandwijk|
|  |
| ICQ# 30231605|
| PGP Public Key: http://www.vanzandwijk.net/pgp.txt   |
+--+


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: copy the result content from one db to another

[jeffrey_n_Dyke]

This works just like doing it from table to table, just specify hte db

insert into dbname.tablename select * from db1.tablename where id < 3;



HTH
Jeff


   
 
  Dr M Karthikeyan 
 
  <[EMAIL PROTECTED]To:   [EMAIL PROTECTED]
  
  c.edu>   cc: 
 
   Subject:  copy the result content from 
one db to another 
  11/17/2003 10:51 
 
  AM   
 
   
 
   
 




I would like to copy the contents of result set by
single command


e.g.,

select * from db1 where id < 3;

result 1
result 2

now how to write this results into another db
without writing to a text file (outtext)...
when both source and destination has the same
structure



thanks
m.karthikeyan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The correct way to deal with name_1, name_2, name_3

[Stephen Fromm]

- Original Message - 
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 10:37 AM
Subject: The correct way to deal with name_1, name_2, name_3


> Greetings, I would be greatful for any advice on the correct way to do
this.
>
> If I have something dynamic, for example customer names where usually
there
> are 1 or 2 unique customer names but possibly say up to 10, what is the
> "correct" design?
>
> For example I could simply create a table with name_1, name_2, name_3
> 10. I am sure there is a more efficient way to do this.

Could you be more specific?

Do you mean one column for each name, in which case these would comprise 10
columns, most of which would have NULL most of the time?

Or do you mean a separate row, one of whose columns is customer_name, with
one of 10 values?

I can't say much because of lack of detail (i.e., what's in the rest of the
table), but I'd have TWO tables.  In the table you're discussing, I'd have a
column called cust_id.  In another table, the "customer" table, I'd have two
entries, cust_id and cust_name.  cust_id in the original table would be a
foreign key pointing at the customer table...




> Thanks!
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: copy the result content from one db to another

[Victor Pendleton]

insert into
...
select
...

-Original Message-
From: Dr M Karthikeyan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: copy the result content from one db to another


I would like to copy the contents of result set by
single command


e.g.,

select * from db1 where id < 3;

result 1
result 2

now how to write this results into another db
without writing to a text file (outtext)...
when both source and destination has the same
structure



thanks
m.karthikeyan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

copy the result content from one db to another

[Dr M Karthikeyan]

I would like to copy the contents of result set by
single command


e.g.,

select * from db1 where id < 3;

result 1
result 2

now how to write this results into another db
without writing to a text file (outtext)...
when both source and destination has the same
structure



thanks
m.karthikeyan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Win32 vs Linux ?

[Reverend Deuce]

Running Win2K and the latest MySQL 4 release. I have a little more than half
a billion rows in three databases and about 50 tables. For about six hours a
day, MySQL is hammered like there's no tomorrow adding/deleting/updating
millions of rows. No problems at all.

I've been using MySQL for almost five years now. It's hard to imagine
sometimes. It's never, ever given me a problem on any platform. It's only
been recently that my use of it has gone beyond a few hundred thousand rows.
So far, it handles a hundred million just as well as it did a hundred
thousand. I'm very pleased with the scalability and stability of the
software on the Windows environment.

-- R. Deuce



- Original Message - 
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 7:45 AM
Subject: MySQL on Win32 vs Linux ?


Greetings. Can anyone comment on the stability of MySQL on Win32?

Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.



Thanks for any advice!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysqldump query

[Victor Pendleton]

Are you running on a Linux platform?

File => .my.cnf
Location => ~
Contents => 
line one: [client]
line two: user=userName
line three: password=userPassword
Security => chmod 600 .my.cnf


-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysqldump query


Hi Victor,

Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)


>From: Victor Pendleton <[EMAIL PROTECTED]>
>To: 'patrick kuah' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: mysqldump query
>Date: Mon, 17 Nov 2003 07:06:18 -0600
>
>you could put the password in your .my.cnf file and change permissions so
>that only the MySQL user can read the file.
>
>-Original Message-
>From: patrick kuah [mailto:[EMAIL PROTECTED]
>Sent: Monday, November 17, 2003 5:15 AM
>To: [EMAIL PROTECTED]
>Subject: mysqldump query
>
>
>Hi guys,
>
>I have configure a daily backup for mysql database. the problem is that i
>need to specifiy the password when using mysql
>
>mysqldump --all-databases --opt --password=1234567 >testing.sql
>
>how can i encypt this --password=1234567 
>Thanks
>
>patrick
>
>_
>Keep track of Singapore & Malaysia stock prices.
>http://www.msn.com.sg/money/
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/[EMAIL PROTECTED]

_
Download games, logos, wallpapers and lots more at MSN Mobile! 
http://www.msn.com.sg/mobile/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The correct way to deal with name_1, name_2, name_3

[Paul Fine]

Greetings, I would be greatful for any advice on the correct way to do this.

If I have something dynamic, for example customer names where usually there
are 1 or 2 unique customer names but possibly say up to 10, what is the
"correct" design?

For example I could simply create a table with name_1, name_2, name_3
10. I am sure there is a more efficient way to do this.

Thanks!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysqldump query

[patrick kuah]

Hi Victor,

Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)

From: Victor Pendleton <[EMAIL PROTECTED]>
To: 'patrick kuah' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: mysqldump query
Date: Mon, 17 Nov 2003 07:06:18 -0600
you could put the password in your .my.cnf file and change permissions so
that only the MySQL user can read the file.
-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:15 AM
To: [EMAIL PROTECTED]
Subject: mysqldump query
Hi guys,

I have configure a daily backup for mysql database. the problem is that i
need to specifiy the password when using mysql
mysqldump --all-databases --opt --password=1234567 >testing.sql

how can i encypt this --password=1234567 
Thanks
patrick

_
Keep track of Singapore & Malaysia stock prices.
http://www.msn.com.sg/money/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
_
Download games, logos, wallpapers and lots more at MSN Mobile! 
http://www.msn.com.sg/mobile/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL on Win32 vs Linux ?

[John Griffin]

I have been developing with Windows2000, Apache, MySQL and PHP (WAMP ?) platform for 
about two years now and have had no problems. However, I have been deploying onto a 
Linux server so my observations may not be valid for your purposes.

John Griffin

-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:46 AM
To: [EMAIL PROTECTED]
Subject: MySQL on Win32 vs Linux ?


Greetings. Can anyone comment on the stability of MySQL on Win32?

Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.



Thanks for any advice!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Ola Ogunneye]

Can you elaborate please? Like I said, the sql file I am executing is in
E:\Apache\apache2\htdocs\public_html\weather

I see that you typed \ c>\loadfile.sql - Please explain. I really am new
to this.

Thank you

>>> Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:56AM >>>

\. c:\loadFile.sql
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Reading and Executing a source...


The problem is that I was getting an error message. I am not at home
right now, and should have posted the message last night. However, my
main question is trying to know based on what the instruction says:

Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

How do I type the above at the mysql prompt? Do I need to reference the
directory where the stations.sql is residing? the file stations.sql
resides in E:\Apache\apache2\htdocs\public_html\weather\

Do I need to point to this directory in order to execute the query or
how does mysql know where to find the file. If I have to point to it, do
I then just type at the mysql prompt 

mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;

Please advice once again

Thanks
>>> Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
What seems to be the problem? Are you getting an error message? If so
can
you post the message?
The syntax is \. fileName

-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...


I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,

source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.

What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?

I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help


Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

Best regards

Ola

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Win32 vs Linux ?

[mos]

At 07:45 AM 11/17/2003, you wrote:
Greetings. Can anyone comment on the stability of MySQL on Win32?

Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.
Paul,
Someone did a benchmark of MySQL running on Linux vs Window and 
Windows was about 20%-25% slower. That's probably not enough of a 
difference to make a diehard Windows user learn Linux. :)  The only other 
concern is Win2k/NT servers should be rebooted at least once a month 
otherwise they tend to get unreliable whereas Linux can stay up for a year 
or more. You can of course run Apache on Win2k machines and requires less 
patching (less rebooting).

Want to see what OS a website is running? Try:
http://uptime.netcraft.com/up/graph/?host=www.mysql.com
http://uptime.netcraft.com/up/graph?site=www.msn.com
Mike 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Win32 vs Linux ?

[Alec . Cawley]

> Greetings. Can anyone comment on the stability of MySQL on Win32?

> Unfortunately I may have to use IIS for a project and am just wandering
if I
> can expect the same sort of stability and performance using MySQL (and
PHP)
> on a Windows Server.

In two years of light but increasing use of MySQL/Win2K I have not seen a
failure on MySQL that was not related to a power failure without benefit of
UPS.

  Alec




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Database Dump

[Christensen, Dave]

Swati,

You can also use mysqldump to be part of the mechanism to move the
database(s) from one computer to another.  Something like:

Prompt> mysqldump --add-drop-table databasename -uuserid -ppassword | mysql
--host=your.new.host.IP  databasename -uuserid -ppassword



-Original Message-
From: Swati K [mailto:[EMAIL PROTECTED] 
Sent: Saturday, November 15, 2003 5:41 AM
To: [EMAIL PROTECTED]
Subject: Database Dump


Hi All

I have just started working on MYSQL. 
Can ne one help on How to take a database Backup?

and how does one transfer the MYSQL database from one Comp to another one?

Regards
Swati kalia
http://www.mecklai.com
where risk meets its match 
***
This message is intended for the individual or entity named above. If you 
are not the intended recipient, please do not read, copy, use or disclose 
this communication to others; also please notify the sender by replying to 
this message, and then delete it from your system. 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

myisamchk Error 22 WinServer 2003 Large table

[Jim Gallagher]

Hello,

I am following the advice of the manual when bulk loading a large table by turning off 
index builds before LOAD DATA INFILE.  The load ends normally (73 GB).  The mysamchk 
build of the indices fails:

myisamchk: warning: Can't change size of indexfile, error: 22
myisamchk: error: 22 for record at pos 121201294124
myISAM-table 'mytable' is not fixed because of errors

This process works successfully on "small" tables (37 GB) on another 2003 machine.

What am I doing wrong?  I'm new to MySQL, and am just finding my way.  The command I'm 
issuing is:

myisamchk -O sort_buffer_size=512M -O key_buffer_size=768M -O read_buffer_size=512M -O 
write_buffer_size=512M -rq d:\mysql\data\mydb\mytable

I have 4GB of memory on the machine.

I searched for this problem with Google and found several others with the same 
problem, but didn't find a solution.

Thanks,

Jim Gallagher



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

row-level locking question...

[Andre Charbonneau]

Hi,

Let say that I have the following transaction:

1. Read value v1 from table t1.
2. Do some computation using v1.
3. Update value v2 from table t2.
If in the above I don't want any other concurrent transaction to read v2 
until I'm done updating it, how should I put an exclusive lock on it?

Using InnoDB, would the following be the way to do it (in transaction 
mode, seriliazable isolation level)?

SELECT v2 from t2 FOR UPDATE; // (Do this to prevent others from reading v2)

SELECT v1 from t1;

(do the computation)

UPDATE t2 set v2=;

COMMIT;

In the above statements, I first read the value v2 to put an exclusive 
lock on that row.  But I don't really need the value of v2, I just need 
to lock it down.  Is the above approach the way to go or is there a more 
elegant/correct way of doing this?

Thanks.
--
Andre Charbonneau


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error message problem

[Jeff McKeon]

Yes there was a syntax error.  I used an "and" instead of && in the
where clause.

However, my concern is that the error message was truncated.

Jeff
> -Original Message-
> From: Victor Pendleton [mailto:[EMAIL PROTECTED] 
> Sent: Monday, November 17, 2003 9:53 AM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: RE: Error message problem
> 
> 
> Was there actually a syntax error? Can you please post the 
> query? The display for the error message appears to be truncated.
> 
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 8:44 AM
> To: [EMAIL PROTECTED]
> Subject: Error message problem
> 
> 
> I just upgraded to Server version 4.0.15-standard, I just 
> tried to do a query and got a syntax error but the error 
> message is incomplete.
> 
> 
> ERROR 1064: You have an error in your SQL syntax.  Check the 
> manual that corresponds to your MySQL server version for the 
> right syntax to use near 'where RemoteStation.Name not like 
> 'zz%' and CopyOf = '0'' at li
> 
> Is this a known bug or a setting I have wrong somehwere?
> 
> Thanks,
> 
> Jeff
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?> [EMAIL PROTECTED]
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error message problem

[Victor Pendleton]

Was there actually a syntax error? Can you please post the query? The
display for the error message appears to be truncated.

-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:44 AM
To: [EMAIL PROTECTED]
Subject: Error message problem


I just upgraded to Server version 4.0.15-standard, I just tried to do a
query and got a syntax error but the error message is incomplete.


ERROR 1064: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'where RemoteStation.Name not like 'zz%' and CopyOf = '0'' at li

Is this a known bug or a setting I have wrong somehwere?

Thanks,

Jeff

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Error message problem

[Jeff McKeon]

I just upgraded to Server version 4.0.15-standard, I just tried to do a
query and got a syntax error but the error message is incomplete.


ERROR 1064: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'where RemoteStation.Name not like 'zz%' and CopyOf = '0'' at li

Is this a known bug or a setting I have wrong somehwere?

Thanks,

Jeff

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Win32 vs Linux ?

[Gerald Jensen]

Paul:

In my experience, MySQL on Win32 platforms is very stable. Of the 80+
customer systems we have running our applications in conjunction with MySQL,
the vast majority are on Win32.

The DB server needs to be properly tuned for the application and
environment, but that is the case with RDBMS you might sleect.

IMHO, any instability is not related to MySQL, but rather to the O/S
platform itself.

Gerald Jensen


- Original Message - 
From: "Paul Fine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 7:45 AM
Subject: MySQL on Win32 vs Linux ?


> Greetings. Can anyone comment on the stability of MySQL on Win32?
>
> Unfortunately I may have to use IIS for a project and am just wandering if
I
> can expect the same sort of stability and performance using MySQL (and
PHP)
> on a Windows Server.
>
>
>
> Thanks for any advice!
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

php and passing implicit connection identifiers

[Stephen Fromm]

The connection identifier returned by mysql_connect() need not be passed to
calls to MySQL-related functions.

What is the "scope" of this claim?

In particular, if I open a connection and then call a function I wrote
myself, which then calls a MySQL related function, can I still omit the
connection identifier?

TIA,

sjfromm


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Victor Pendleton]

\. c:\loadFile.sql

-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Reading and Executing a source...


The problem is that I was getting an error message. I am not at home right
now, and should have posted the message last night. However, my main
question is trying to know based on what the instruction says:
 
Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

How do I type the above at the mysql prompt? Do I need to reference the
directory where the stations.sql is residing? the file stations.sql resides
in E:\Apache\apache2\htdocs\public_html\weather\
 
Do I need to point to this directory in order to execute the query or how
does mysql know where to find the file. If I have to point to it, do I then
just type at the mysql prompt 
 
mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;

Please advice once again
 
Thanks
>>> Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
What seems to be the problem? Are you getting an error message? If so can
you post the message?
The syntax is \. fileName

-Original Message-
From: Ola Ogunneye [ mailto:[EMAIL PROTECTED]
 
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...


I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,

source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.

What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?

I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help


Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

Best regards

Ola

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
 
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
 

MySQL on Win32 vs Linux ?

[Paul Fine]

Greetings. Can anyone comment on the stability of MySQL on Win32?

Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.



Thanks for any advice!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Ola Ogunneye]

The problem is that I was getting an error message. I am not at home
right now, and should have posted the message last night. However, my
main question is trying to know based on what the instruction says:

Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

How do I type the above at the mysql prompt? Do I need to reference the
directory where the stations.sql is residing? the file stations.sql
resides in E:\Apache\apache2\htdocs\public_html\weather\

Do I need to point to this directory in order to execute the query or
how does mysql know where to find the file. If I have to point to it, do
I then just type at the mysql prompt 

mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;

Please advice once again

Thanks
>>> Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
What seems to be the problem? Are you getting an error message? If so
can
you post the message?
The syntax is \. fileName

-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...


I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,

source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.

What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?

I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help


Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

Best regards

Ola

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]

RE: [PHP-DB] TABLE_PRIV

[Victor Pendleton]

table_privs is going to assign privileges at the individual table level
grant select on database.tablename to user@'192.168.0.10' IDENTIFIED  BY
'password'

-Original Message-
From: Nikos Gatsis [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] TABLE_PRIV


Hello List.

Does anybody knows how to configure table_priv table of Mysql?
I didn't find something in manual
I have v. 3.23.41 in Linux

Thanx
Nikos


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access denied error

[Victoria Reznichenko]

"Shane Korosec" <[EMAIL PROTECTED]> wrote:
> I have recently installed MySQL my mac running OS X 10.3 and can connect to 
> MySQL using the command:
> /Library/MySQL/bin/mysql
> However, once connected, I have tried to create a database and  received the 
> error message:
> ERROR 1044: Access denied for user: '@localhost' to database  'new_database'

You connected as anonymous user ('') that doesn't have appropriate privileges.
> 
> I have exited and tried connecting using the command:
> sudo /Library/MySQL/bin/mysql
> and received the error message:
> ERROR 1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password:  NO)

Use -p option of mysql client to specify root password:
http://www.mysql.com/doc/en/Connecting-disconnecting.html

> 
> I am a relatively inexperienced MySQL user, so what can I do so I can manage 
> my database? Any suggestions will be greatly appreciated.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[PHP-DB] TABLE_PRIV

[Nikos Gatsis]

Hello List.

Does anybody knows how to configure table_priv table of Mysql?
I didn't find something in manual
I have v. 3.23.41 in Linux

Thanx
Nikos


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problems retrieveing int unsigned fields

[Victor Pendleton]

It seems that 4294967295, the max value for an unsigned int, is not large
enough. Is there  an issue with using bigint or storing the value in char
format?

-Original Message-
From: John A. Sullivan III [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:18 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Problems retrieveing int unsigned fields


We are building a large GPL'd application to manage network security
(firewalls, VPN, etc - http://iscs.sourceforge.net) using Trolltech's Qt
and their database drivers to our MySQL backend.  We originally thought
this was a Qt problem but it now appears to be a MySQL problem.
We store the binary equivalent of dotted decimal IP addresses as int
unsigned.  We write and retrieve the variables to the database with
unsigned long int variables from our Qt application.
The variables appear to be written correctly to the database - at
least
when we query them with the mysql client.  However, when we retrieve
them, the Qt Variant class is not able to convert them to UInt values if
they are larger than the maximum value of a signed int.  Values that can
fit into an unsigned int are returned properly.  Large values always
return 0, i.e., unable to convert the returned value to an unsigned
int.  We have the same results if we try to return the value as a
string.
If we change the database field to bigint, all works fine.  Any
ideas
what the problem may be?
We are using MySQL 3.23.56 and Qt 3.1.1.  My test station is fully
patched RedHat 9.0.  Please pardon the cross post but I'm sure this is
of interest to Qt database developers.
-- 
John A. Sullivan III
Chief Technology Officer
Nexus Management
+1 207-985-7880
[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Reading and Executing a source...

[Victor Pendleton]

What seems to be the problem? Are you getting an error message? If so can
you post the message?
The syntax is \. fileName

-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...


I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,

source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.

What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?

I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help


Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

Best regards

Ola

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: secure automated access (was "Re: Backing up all databases")

[Randall Perry]

> 
>> In the case of root cron jobs then, you need a .my.cnf readable only by
>> root in root's home.  It should include
>> 
>> [client]
>> password="mysql_root_password"
> 
> This is incorrect, unless the double quotes are part of the password.
> Removing them so that the entry reads:
> 
> [client]
> password=mysql_root_password
> 
> will correct the problem.

That was it. Thanks everyone for the help.


-- 
Randall Perry
sysTame

Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales

http://www.systame.com/



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: secure automated access (was "Re: Backing up all databases")

[Randall Perry]

>> 
>> Mac OS 10.2.3. Maybe Panther has an issue with the build?
> 
> 10.2.3 is Jaguar, not Panther.  Did you mean 10.3.x?  As I said, I'm
> running mysql 4.0.16 on Mac OS 10.2.8, and this works for me.  I suppose
> an issue with Panther is possible, though I'd be surprised if something
> simple like reading .my.cnf were where it showed up.
> 
Sorry, it's 10.3. See my next post for the solution.


-- 
Randall Perry
sysTame

Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales

http://www.systame.com/



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems retrieveing int unsigned fields

[John A. Sullivan III]

We are building a large GPL'd application to manage network security
(firewalls, VPN, etc - http://iscs.sourceforge.net) using Trolltech's Qt
and their database drivers to our MySQL backend.  We originally thought
this was a Qt problem but it now appears to be a MySQL problem.
We store the binary equivalent of dotted decimal IP addresses as int
unsigned.  We write and retrieve the variables to the database with
unsigned long int variables from our Qt application.
The variables appear to be written correctly to the database - at least
when we query them with the mysql client.  However, when we retrieve
them, the Qt Variant class is not able to convert them to UInt values if
they are larger than the maximum value of a signed int.  Values that can
fit into an unsigned int are returned properly.  Large values always
return 0, i.e., unable to convert the returned value to an unsigned
int.  We have the same results if we try to return the value as a
string.
If we change the database field to bigint, all works fine.  Any ideas
what the problem may be?
We are using MySQL 3.23.56 and Qt 3.1.1.  My test station is fully
patched RedHat 9.0.  Please pardon the cross post but I'm sure this is
of interest to Qt database developers.
-- 
John A. Sullivan III
Chief Technology Officer
Nexus Management
+1 207-985-7880
[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Reading and Executing a source...

[Ola Ogunneye]

I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,

source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.

What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?

I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help


Using mysql - connect as your root or other privileged user
  connect to your geeklog database
  Using "source" read in and execute the SQL file

o mysql# source stations.sql;

Best regards

Ola

RE: mysqldump query

[Victor Pendleton]

you could put the password in your .my.cnf file and change permissions so
that only the MySQL user can read the file.

-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:15 AM
To: [EMAIL PROTECTED]
Subject: mysqldump query


Hi guys,

I have configure a daily backup for mysql database. the problem is that i 
need to specifiy the password when using mysql

mysqldump --all-databases --opt --password=1234567 >testing.sql

how can i encypt this --password=1234567 
Thanks

patrick

_
Keep track of Singapore & Malaysia stock prices. 
http://www.msn.com.sg/money/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Access denied error

[Victor Pendleton]

You need to connect as a privileged user. You should delete the anonymous
account for security reasons.

-Original Message-
From: Shane Korosec [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 1:56 AM
To: [EMAIL PROTECTED]
Subject: Access denied error


I have recently installed MySQL my mac running OS X 10.3 and can connect to 
MySQL using the command:
/Library/MySQL/bin/mysql
However, once connected, I have tried to create a database and  received the

error message:
ERROR 1044: Access denied for user: '@localhost' to database  'new_database'

I have exited and tried connecting using the command:
sudo /Library/MySQL/bin/mysql
and received the error message:
ERROR 1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password:  NO)

I am a relatively inexperienced MySQL user, so what can I do so I can manage

my database? Any suggestions will be greatly appreciated.

_
Hot chart ringtones and polyphonics. Go to  
http://ninemsn.com.au/mobilemania/default.asp


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Please help DB Error: unknown error

[Victor Pendleton]

Can you please post the error?

-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error


Hi all,
I have a problem with my query on mySQL 4.0. 
DB Error: unknown error 
I don't know what is the problem. Please help me!!! Thanks in advance.
Regards,
Thai
SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile t4,tblUserProfile
t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile t8,tblUserProfile
t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile t12,tblUserProfile
t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile t16,tblUserProfile
t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile t20,tblUserProfile
t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile t24,tblUserProfile
t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile t28,tblUserProfile
t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile t32,tblUserProfile
t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile t36,tblUserProfile
t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile t40,tblUserProfile
t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile t44,tblUserProfile
t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile t48,tblUserProfile
t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile t52,tblUserProfile
t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile t56,tblUserProfile
t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile t60,tblUserProfile
t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile t64,tblUserProfile
t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile t68,tblUserProfile
t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile t72,tblUserProfile
t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile t76,tblUserProfile
t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile t80,tblUserProfile
t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile t84,tblUserProfile
t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile t88,tblUserProfile
t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile t92,tblUserProfile
t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile t96,tblUserProfile
t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile t100,tblUserProfile
t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle <>
'administrator' AND t.AccountType <> 2 AND t.AccountType <> 3 AND t.Gender =
1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID =
t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND t1.UserID=t2.UserID
AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND t4.FieldID
= 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78 AND
t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.FieldID = 79 AND
t11.FieldValue = 1 AND t1.UserID=t12.UserID AND t12.FieldID = 79 AND
t12.FieldValue = 2 AND t1.UserID=t13.UserID AND t13.FieldID = 79 AND
t13.FieldValue = 5 AND t1.UserID=t14.UserID AND t14.FieldID = 79 AND
t14.FieldValue = 6 AND t1.UserID=t15.UserID AND t15.FieldID = 79 AND
t15.FieldValue = 4 AND t1.UserID=t16.UserID AND t16.FieldID = 131 AND
t16.FieldValue = 4 AND t1.UserID=t17.UserID AND t17.FieldID = 131 AND
t17.FieldValue = 2 AND t1.UserID=t18.UserID AND t18.FieldID = 131 AND
t18.FieldValue = 1 AND t1.UserID=t19.UserID AND t19.Field

RE: MySQL 4.0.16 stop working

[Victor Pendleton]

Can you check to see what messages are logged in the error log? Did you
install MySQL as a service? Is the service set to start up automatically?


-Original Message-
From: William IT [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 6:41 PM
To: [EMAIL PROTECTED]
Subject: Mysql 4.0.16 stop working


Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run
mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen.

I download Mysql for Windows but not purchase the Commercial Licence yet. Is
there a time based restriction here?



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Grant privilege removed from root

[Egor Egorov]

"W. Bauer" <[EMAIL PROTECTED]> wrote:
> 
> Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed 
> that I cannot grant privileges any more. Any hint how I can undo 
> that?

If you still have privileges on the database 'mysql' you can set Grant_rpiv to 'Y' 
with UPDATE statement. 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

datetime vs timestamp for speed

[jeffrey_n_Dyke]

If most of my queries against a DB are goign to be related to when things
happened/within a date range...  would it be more efficient to use
timestamps or datetime fields?  I plan to index either column, as it will
be in many where clauses.

I'm currently still running 3.23.38 with plans to upgrade to 4.0.16, very
soon.

TIA
Jeff



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB Set-up

[Egor Egorov]

"Mulugeta Maru" <[EMAIL PROTECTED]> wrote:
> My background is Micorosoft Access and SQL server. The InnoDB table type 
> gives me a much close option to move my databases. I found the database a 
> little complex and would like to know if there is a better step-by-step 
> explanation of setting up InnoDB in MySQL 4.1 on a Windows 2000 machine.
> 

By default in v4.1 MySQL creates auto-extending file in the data dir (ibdata1). You 
can also set InnoDB startup options manually. Check the following link:
http://www.mysql.com/doc/en/InnoDB_start.html

You can find examples of my.cnf file and list of InnoDB parametrs with descriptions 
there.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

User Variables

[Bruno Mustone]

Hi Guys,
 
Do you know what version user variables were introduced? I can't seem to
get them working in 3.22 and yet they work in 3.23.
 
Best regards,
 
Bruno Mustone

Re: secure automated access (was "Re: Backing up all databases")

[Ed Leafe]

On Monday, November 17, 2003, at 02:58  AM, Michael Stassen wrote:

cat $HOME/.my.cnf
[client]
password="rootpassword"
/usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: 
YES)
Oh.  That changes things.  The error says "Using password: YES".  (You 
told me it said "Using password: NO" before).  That would indicate 
that mysql did read your .my.cnf file, but doesn't believe it contains 
the correct password.  Double-check you don't have a typo in there.  
Another possibility might be a special character such as a " or # in 
the password.
	There's the problem. Your original advice was to include:

In the case of root cron jobs then, you need a .my.cnf readable only by
root in root's home.  It should include
[client]
password="mysql_root_password"
	This is incorrect, unless the double quotes are part of the password. 
Removing them so that the entry reads:

[client]
password=mysql_root_password
will correct the problem.

 ___/
/
   __/
  /
 /
 Ed Leafe
Linux Love:
unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database Commit transaction !!!!!

[Swati K]

hi all,

I am trying to insert data into MYSQL via a excel sheet.
But the minute i disconnect ..the data disappears from the data base..
some how the transaction is not getting committed..
I am using ADO Recordset and USing both insert and Update for Data
manipulation..

Do advise as to why this could be happening??

Regards
Swati kalia
http://www.mecklai.com
where risk meets its match 
***
This message is intended for the individual or entity named above. If you 
are not the intended recipient, please do not read, copy, use or disclose 
this communication to others; also please notify the sender by replying to 
this message, and then delete it from your system. 
Mecklai Financial & Commercial Services Ltd. 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump query

[patrick kuah]

Hi guys,

I have configure a daily backup for mysql database. the problem is that i 
need to specifiy the password when using mysql

mysqldump --all-databases --opt --password=1234567 >testing.sql

how can i encypt this --password=1234567 
Thanks
patrick

_
Keep track of Singapore & Malaysia stock prices. 
http://www.msn.com.sg/money/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bug? mysql replication mysql 4.0.16..

[Victoria Reznichenko]

Peter Larsen <[EMAIL PROTECTED]> wrote:
> 
> Replication does not happend if inserts (update not tested) is made without 
> "mysql_select_db("database", $connection); " (yes, I use php..).
> 
> 
> Working:
> mysql_select_db("database", $connection);
> mysql_query("INSERT INTO table (text1, text2) VALUES ('bah', 'bah')");
> 
> 
> Not working (data only apreas in the log files on slave, and on master 
> database, but NOT in slave database)
> mysql_query("INSERT INTO database.table (text1, text2) VALUES ('bah', 
> 'bah')");
> 
> 
> This is extreamly annoying.

It's a correct behaviour if you use replicate-do-db option:

http://www.mysql.com/doc/en/Replication_Options.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql error

[Victoria Reznichenko]

"vikas kamble" <[EMAIL PROTECTED]> wrote:
> 
> I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or 
> access database it's given me
> following error.
> 
> ERROR 2002: Can't connect to local MySQL server through socket 
> '/var/lib/mysql/mysql.sock' (111)
> 
> Please guide me what should i do. even i try to instal nushere tool on R.H. 
> 9.0. but not able to connect mysql server.
> 

Is MySQL server running?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql error

[vikas kamble]

Hi,

I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or 
access database it's given me
following error.

ERROR 2002: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (111)

Please guide me what should i do. even i try to instal nushere tool on R.H. 
9.0. but not able to connect mysql server.

please replay me with suggestion

Regards

Vikas Kamble

_
BharatMatrimony.com. http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 
India's premium matrimonial website.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]