Re: Selecting records based on max and value

Hi David, David Ruggles wrote: Supplyorder uid double (auto) (pk) sitedouble datedate Supplyorderhistory uid double (auto) (pk) supplyorderuid double status double Supplyorderlineitems uid double (auto) (pk)

Re: Problems with INSERT

[EMAIL PROTECTED] wrote: > I keep getting the following error: > > 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 's > resources than dual monitor mode to generate the video output. Running > in dual' at l

external updates/additions of database entries

Hello, I'm looking for help in merging the contents of two database tables with identical columns between them. A base set of data will be stored in the "permanent" table, and incremental additions and/or changes will be introduced in the "staging" table the ID's of the data in the tables

Re: making graphs with MySQL data

C.R.Vegelin escribió: > Dear List, > > I have a MySQL database (V5.0.x) and I need to make graphs. > Does anyone know about good utilities to make graphs ? > I would appreciate your expertise or links. > > TIA, Cor > A very good one is BIRT (http://www.eclipse.org/birt/phoenix/) to be deployed

Re: Insert ... Select troubles

Thanks for the suggestion Brent. The auto_increment won't work in my situation though. My t1 table has a RecID field that already is my primary key and set to auto_increment. Is there another way that this can be done? Thanks >>> "Brent Baisley" <[EMAIL PROTECTED]> 1/12/07 1:10 PM >>> Sine Ite

Re: making graphs with MySQL data

On Friday 12 January 2007 12:51, C.R.Vegelin wrote: > Dear List, > > I have a MySQL database (V5.0.x) and I need to make graphs. > Does anyone know about good utilities to make graphs ? > I would appreciate your expertise or links. If you're using Python, matplotlib is an excellent package. If yo

Re: Problems with INSERT

> I keep getting the following error: > > 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 's > resources than dual monitor mode to generate the video output. Running > in dual' at line 2 > > when I try to add

RE: Problems with INSERT

[snip] 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 's resources than dual monitor mode to generate the video output. Running in dual' at line 2 when I try to add: Note : Single-monitor mode uses more of y

Problems with INSERT

Hi everyone, I'm a dbase rookie and I've ran into a small problem. I created a basic faq table and all is fine regarding displaying & searching the Q & A's on a web page. Up until now, I;ve entered all Q & A's from phpMyAdmin. I'm trying to create an admin page to enter the Q & A's and for t

Re: Insert ... Select troubles

Sine ItemCount is part of your unique key, you should just make ItemCount an auto_increment field. Mysql will then handle providing sequential numbering within the group. For example: CREATE TABLE t1 ( GroupCount int, ItemCount int auto_increment, PRIMARY KEY (GroupCount,ItemCount) ) When you d

Re: making graphs with MySQL data

C.R.Vegelin wrote: Dear List, I have a MySQL database (V5.0.x) and I need to make graphs. Does anyone know about good utilities to make graphs ? I would appreciate your expertise or links. TIA, Cor Perl with GD? MS Access/MyODBC could do it too. You may have to be more specific. -Ryan

making graphs with MySQL data

Dear List, I have a MySQL database (V5.0.x) and I need to make graphs. Does anyone know about good utilities to make graphs ? I would appreciate your expertise or links. TIA, Cor

RE: Selecting records based on max and value

Thanks! I'll make the column type change. Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 3:42 PM To: David Ruggles Cc:

Re: Row position in table when sorted?

[EMAIL PROTECTED] (Nuno Oliveira) wrote in news:[EMAIL PROTECTED]: > (Off-Topic: I'm using Thunderbird/1.5 & Gmail and I do a Reply All > which sends the messages to the person I'm replying and CC's to the > list but I never receive my own messages. Is this the normal behavior? > Thanks) Lookin

Re: Selecting records based on max and value

David, I want to select for a given date all sites that have the last history record with a certain status. Try something like ... SELECT h1.supplyorderid FROM supplyorder o JOIN supplyorderhistory h1 ON o.uid=h1.supplyorderuid LEFT JOIN supplyorderhistory h2 ON h2.supplyorderuid = h.supply

Re: Row position in table when sorted?

Jerry Schwartz wrote: Now that I re-read your question, I think your answer is that the LIMIT clause applies to the set of records retrieved after all of the conditions are applied. In your example, SELECT * FROM clients WHERE name LIKE "Mark%" ORDER BY name LIMIT 1, 7; Then SELECT * FROM clie

Re: [OT} How to pronounce GIF

In an effort to quell this off-topic and rather pointless dialog, allow me to refer you to the Wikipedia article on the subject: http://en.wikipedia.org/wiki/GIF Specifically the section: "According to the creator of the "GIF" format, Steve Wilhite, the pronunciation is with a soft "g" and the

Selecting records based on max and value

I'm new to this list, but have searched through the archives and haven't found anything that addresses my question. First a little background: I'm creating a supply ordering system. Each supply order may be modified many times before being approved and finally filled. I created the following dat

RE: [OT} How to pronounce GIF

Way offoptic now How do you pronounce "gift"? :^) $ egrep '^gif' /usr/share/dict/words gift gift's gifted gifting gifts To heck with the spec, all precedent in English says hard G. Next they'll tell us to pronounce "jpeg" as "gay-peg". -Original Message- From: Gerald L. Clark [ma

Re: [OT} How to pronounce GIF

Brian Dunning wrote: On Jan 7, 2007, at 4:23 PM, TK wrote: In short, the original inventors of the GIF format (CompuServe, 1987) have always defined the pronunciation to be like "JIF." So, that has always been the "correct" pronunciation. Sure, so I'll start pronouncing "graphics" as "jr

RE: [OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

... Especially for tall ones. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Brian Dunning [mailto:[EMAIL PROTECTED] > Sent: Friday, January 12, 2007 1:49 PM > To: mysql > Su

RE: Row position in table when sorted?

Now that I re-read your question, I think your answer is that the LIMIT clause applies to the set of records retrieved after all of the conditions are applied. In your example, SELECT * FROM clients WHERE name LIKE "Mark%" ORDER BY name LIMIT 1, 7; Then SELECT * FROM clients WHERE name LIKE "Mar

Re: [OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

On Jan 7, 2007, at 4:23 PM, TK wrote: In short, the original inventors of the GIF format (CompuServe, 1987) have always defined the pronunciation to be like "JIF." So, that has always been the "correct" pronunciation. Sure, so I'll start pronouncing "graphics" as "jraphics". -- MySQL Gen

Re: Insert ... Select troubles

ItemCount is essentially a counter of the records from the select statement. So, every new INSERT ... SELECT statement gets a new GroupCount (the next number up) and ItemCount represents the ID of the items in that new group. Does that make sense? - Thanks >>> "Michael Dykman" <[EMAIL PROTECTE

Re: Row position in table when sorted?

[EMAIL PROTECTED] (Nuno Oliveira) wrote in news:[EMAIL PROTECTED]: > My problem/question is how can I know the link for each one of these > found records??? Which is the for the LIMIT??? The way to retrieve individual records is by id, not by LIMIT n, m: SELECT * FROM Clients WHERE id = <>

How to randomly select one value per group-by column?

Dear list, Suppose a table with articles that persons have ordered: create table t (pers_id int(6), odate date, art_id int(8)) I want to select one randomly choosen odate for every pers_id. I can easily select the minimum or the maximum odate: select pers_id, min(odate) from t group by per

Re: Row position in table when sorted?

Rolando Edwards wrote: I think you need this syntax SELECT * FROM Clients ORDER BY Name LIMIT , Your offset must be rows per page * pagenumber where minimum pagenumber is 0 You should also count the full result set divide that count by the number of rows per page to get the last page number If

Re: Row position in table when sorted?

I think you need this syntax SELECT * FROM Clients ORDER BY Name LIMIT , Your offset must be rows per page * pagenumber where minimum pagenumber is 0 You should also count the full result set divide that count by the number of rows per page to get the last page number If the remainder is not zero

Row position in table when sorted?

Hello, I'm working on a web site which have a page for the admin to browse the clients table in a database. To facilitate the interaction, I'm ORDERing BY Name... The pagination buttons in this page are something like: href=".?Page=7" and when loaded, it will "SELECT * FR

UTF-8 sorting problem

Hello I've got a problem,, I've tried to search the archive for this list with no luck. Maybe it's because Unicode problems isn't that rare... Anyway .. Here is my problem. Sorting on a VARCHAR collate utf8_swedish_ci (table with default charset utf8).. As many probably know, in Swedish

no caching of Stored Procedure results?

I am using MySql 5.1.14-beta with Java/ConnectorJ on the client. Section '5.14. The MySQL Query Cache' states 'The query cache is not used for server-side prepared statements' and I have confirmed that the results of a stored procedure that makes use of a passed in parameter are not in fact stored

Re: Dual Hardisk

Hi, Your storage engine is Innodb?. If your answer is yes, please see below : innodb_data_file_path=/u01/ibdata1:50M;/u01/ibdata2:50M*;/u03/ibdata3:100M * You can create a new ibdata ( tablespace) in a new device : 1) Stop mysql 2) Change conf ( add new one tablespace) 3) start mysql Regards,

Re: Primary key

> In the last episode (Jan 11), Steffan A. Cline said: >> Is there anyway to do a SELECT or DESCRIBE or SHOW statement which can >> return the primary key field of a specified table? >> >> Pseudo code: select primary_key_field_name from mytable. > > SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USA

RE: Need any that can translate this

Oh my god it work.Thank you very much Felix (thanks all for answer). I don't have knowlege in MySql. Thanks thanks thanks. I have one more select (the last), if you can help me with this please. SELECT * FROM login_users WHERE id IN (SELECT o.user_id from orders o,facturas f where factura_id='