Re: UPDATE Based on Relation

Jesse wrote: I need to be able to do an UPDATE based on a relation. The following code works in Microsoft SQL. What is the MySQL Equivalent? UPDATE Chapters SET MatSentDate='2006-07-04' FROM Invoices I JOIN Chapters C ON C.ID=I.ChapterID JOIN Schools S ON S.ID=C.SchoolID WHERE I.InvoiceDate =

Re: Money

On Tuesday 04 July 2006 21:33, Karl Larsen wrote:     I have not yet found how I can put a $ in front of all the money columns :-) Either use concat() or do it in your program that retrieves the data from MySQL. Currency symbols are not something the database should have to store for you. --

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: To those who responded - read the question. He wants to combine the values from the data column of *2* rows into one, not just a straightforward string concatenation. Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the

re[2]: Newbie - CREATE VIEW Question

Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the tables. I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this case

Question on mysqldump --single-transaction

Hi everyone I'm wondering about the --single-transaction option on mysqldump. Documentation says --- This option issues a BEGIN SQL statement before dumping data from the server. ... --- So does this include the entire dump in one transaction? Or is it one transaction per database (or even

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the tables. I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the query for

Re: UPDATE Based on Relation

I'm using version 5.?. Excellent. That seemed to do the trick. Thanks, Jesse - Original Message - From: Remo Tex [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, July 05, 2006 2:31 AM Subject: Re: UPDATE Based on Relation Jesse wrote: I need to be able to do an UPDATE

NDB API Guide

Here's some information that's probably interesting for you if you're interested in MySQL Cluster ... As part of the effort of making MySQL Cluster a more mainstream product, it's been on our agenda for a very long time to rewrite the NDB API documentation so that it becomes usable by mere

mysqldump: Got errno 27 on write. file too large

I have musql 4.1.7 on Solaris 9, 64 bits and I want to mysqldump a +-4 gigas db. The dump I want to do is from a myISAM tables databank. I used to do that dump wihtout any problem until recently while the size of the Db double (+-2 to +-4) The full directory that contains the *.frm,

Re: mysqldump: Got errno 27 on write. file too large

How can I solve this problem? This might be a filesystem problem. Some filesystem (in certain configurations) cannot hold files larger than a particular size. Do you have any files larger than that cut dumpfile on that partition? -- MySQL General Mailing List For list archives:

PBXT version 0.9.5 has been released

Hi All, PBXT version 0.9.5 has been released and can be downloaded from http://www.primebase.com/xt. This version includes a number of major structural changes to the implementation in order to improve performance. In addition, all bugs reported so far have been fixed. For further

re[2]: Newbie - CREATE VIEW Question

I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this case it was a newbie question. And therefore it's most important that he tries to learn how to look at the doc. Remembering my own troubles learning MySQL, it can

RE: mysqldump: Got errno 27 on write. file too large

Thank you for your answer. Yes I have file larger than what mysqldump could manager. Here is an example of this. Both files are on the same partition. mercure{root}54: du -k mercure.log.jui2006 11948544mercure.log.jui2006 mercure{root}68: du -k myregendump 2098184 myregendump Which

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this case it was a newbie question. And therefore it's most important that he tries to learn how to look at the doc. Remembering my own troubles

Re: NDB API Guide

Stefan Hinz schrieb: Here's some information that's probably interesting for you if you're interested in MySQL Cluster ... As part of the effort of making MySQL Cluster a more mainstream product, it's been on our agenda for a very long time to rewrite the NDB API documentation so that it

MySQL service startup time

Hi, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in the

Re: mysqldump: Got errno 27 on write. file too large

Dominik Klein wrote: This might be a filesystem problem. Some filesystems (in certain configurations) cannot hold files larger than a particular size. Do you have any files larger than that cut dumpfile on that partition? Duhaime Johanne wrote: Thank you for your answer. Yes I have file

add users in mysql 5.0 ubuntu dapper drake

hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, then i guess i am suposed to add users there. i have tried man mysql i might have missed the part on how you add normal

Temporary table ERROR 1109 (42S02) where are temporary tables kept?

I ran the following commands: USE snort; CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp '2006-05-01'; ... SELECT count(*) from sidtemp; count(*) 7501376 DELETE FROM data WHERE data.cid = sidtemp.cid; ERROR 1109 (42S02): Unkown table 'sidtemp' in where clause SHOW

Re: Scheduled Backups Issue...

I am attempting to set and and schedule automated MySQL backups using the MySQL Administrator Tool downloaded from mysql.com. All of my back ups work fien when I perform them manually. However none of the scheduled backups ever get done. I am not sure where the glicth is but here is

Re: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Jacob, Raymond A Jr wrote: I ran the following commands: USE snort; CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp '2006-05-01'; ... SELECT count(*) from sidtemp; count(*) 7501376 DELETE FROM data WHERE data.cid = sidtemp.cid; ERROR 1109 (42S02): Unkown table

RE: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Thank you, I was definitely on the wrong track on this one. I annotated your commands to make sure that I understood what they were doing. Are my comments correct? --- You have the wrong syntax. You can't mention a table in the WHERE clause that wasn't in the FROM clause. Try

Dynamic link

Say I have two regular tables (table1, table2) and what a column (status) in the second table to update when it changes in table1. For example, if I set the status for a user in table1 to 0, the status for all that user's records in table2 dynamically changes to 0. Can this be done? What method

Re: MySQL service startup time

Hi Rob, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in

RE: Dynamic link

[snip] Say I have two regular tables (table1, table2) and what a column (status) in the second table to update when it changes in table1. For example, if I set the status for a user in table1 to 0, the status for all that user's records in table2 dynamically changes to 0. Can this be done? What

Re: Dynamic link

On Wednesday 05 July 2006 11:40 am, Jay Blanchard wrote: [snip] Say I have two regular tables (table1, table2) and what a column (status) in the second table to update when it changes in table1. For example, if I set the status for a user in table1 to 0, the status for all that user's

RE: MySQL service startup time

Considering there are a number of pieces that are involved in the connection being ready why not create a small program that tries to connect and checks the return value. If it fails sleep for 500ms to 1 sec and try again for up to X-times before aborting altogether? Bob -Original

Re: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Jacob, Raymond A Jr wrote: Thank you, I was definitely on the wrong track on this one. I annotated your commands to make sure that I understood what they were doing. Are my comments correct? --- You have the wrong syntax. You can't mention a table in the WHERE clause that wasn't in

RE: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Thanks again, raymond -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 14:54 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Temporary table ERROR 1109 (42S02) where are temporary tables kept? Jacob, Raymond A Jr wrote:

RE: Dynamic link

Is this the only option? I get Access denied. CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount; MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation This is sample code from mysql site,

Re: Dynamic link

How would a foreign key constraint work in this case? Thank you -- View this message in context: http://www.nabble.com/Dynamic-link-tf1896489.html#a5188192 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: MS Access gives error no. -7776.

-Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 04, 2006 5:45 PM To: C K; mysql@lists.mysql.com Subject: Re: MS Access gives error no. -7776. C K wrote: Thanks for your sugesstions. I tried to search this issue on microsoft's website. and

Re: Dynamic link

On Wednesday 05 July 2006 12:26 pm, z247 wrote: How would a foreign key constraint work in this case? An example of a foreign key constraint would be something like: CREATE TABLE users ( id BIGINT UNSIGNED NOT NULL UNIQUE, username VARCHAR NOT NULL, password VARCHAR NOT NULL, status INT

Re: Show tables replacement

Anyone have an idea on this? Thanks Ed Reed [EMAIL PROTECTED] 6/30/06 2:51:44 PM Opps! Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL 4.1.11 Any other suggestions? Thanks again. Dan Nelson [EMAIL PROTECTED] 6/30/06 2:48:57 PM In the last episode (Jun 30),

automatic timestamp

People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name varchar(100) NOT NULL

Re: automatic timestamp

People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name

Re: automatic timestamp

Nestor wrote: People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name

Re: Question on mysqldump --single-transaction

Dominik Klein wrote: Hi everyone I'm wondering about the --single-transaction option on mysqldump. Documentation says --- This option issues a BEGIN SQL statement before dumping data from the server. ... --- So does this include the entire dump in one transaction? Or is it one transaction

space usage

Does anyone havea clue of how mysql optimizes empty fields and how query speed is affected? i have a db with around 3 million rows where i need to add 2 new fields - one smallint and one varchar(10) for alot of the rows they will be empty, but because of query speed i opt to put them ion

Re: mysqldump: Got errno 27 on write. file too large

On Wednesday, 5 July 2006 at 9:12:52 -0400, Duhaime Johanne wrote: I have musql 4.1.7 on Solaris 9, 64 bits and I want to mysqldump a +-4 gigas db. ... The full directory that contains the *.frm, *.MYD,*.MYI files has the following size: du -ks /seqdata/mysql/autres_bds/regen 3702719

Re: add users in mysql 5.0 ubuntu dapper drake

Dimitri Mallis wrote: hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, then i guess i am suposed to add users there. You've got things confused. 'mysql' the service,

Re: Dynamic link

z247 wrote: Is this the only option? I get Access denied. CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount; MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation Read the error message. You don't have super

binary select - case sensitive

hi all... i found this on the mysql dev manual site: MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison. so here i tried it but no good. any ideas?! the field is not declared binary but i do

Re: binary select - case sensitive

kalin mintchev wrote: hi all... i found this on the mysql dev manual site: MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison. so here i tried it but no good. any ideas?! the field is not

Re: binary select - case sensitive

http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html It has some good examples. got it thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]