Re: strange group/max date question...

bruce wrote: hi... i have the following select... SELECT itemID, process, status, tblType, MAX(date) FROM historyTBL WHERE (tblType = '3' or tblType = '2') GROUP BY tblType; it seems to work, in that it gives me the rows for the two types that i'm grouping by. the problem is that i want the row tha

Best way to get Access DB structures into MySQL ??

What is the best way to take the structure of multiple tables in Access and get them re-created in MySQL without doing that all by hand? Is there a way to do the equivalent of a Show Create Table in Access, that I could then use in MySQL ?? Chris Hood Investigator Verizon Global Se

Re: strange group/max date question...

Have you tried this: select ..., max(date) as mdate from ... where ... group by ... order by mdate desc ? I haven't tested it, but it should order the results by max date descending, giving you the greatest date first. On Fri, 10 Sep 2004 18:16:00 -0700, bruce <[EMAIL PROTECTED]> wrote: > hi...

strange group/max date question...

hi... i have the following select... select itemID, process, status, tblType, max(date) from historyTBL where (tblType = '3' or tblType = '2') group by tblType; it seems to work, in that it gives me the rows for the two types that i'm grouping by. the problem is that i want the row that conta

Re: Analyze Dreaweaver's PHP/MySQL code

You have a pretty good handle on what's happening there, I hope I can add some clarity. The Resource Id you're trying to echo is a pointer to a MySQL result set, you aren't actually working with the data yet. That's where the mysql_fetch functions come in. The mysql_fetch_assoc function fetches

Re: mysql_config missing - already read much docs

At 9:39 -0500 9/10/04, sean c peters wrote: I just upgraded Mysql to 4.1.4-0 on linux using the following: MySQL-server-4.1.4-0.i386.rpm MySQL-client-4.1.4-0.i386.rpm So when i went to upgrade my perl DBI & DBD::mysql packages, it noticed that mysql_config was missing. My understanding is that mysq

RE: group by issue...??

paul i do a select ID from hTBL group by type and i still only get a single row for each type, where i would expect to get the ~5000 rows, grouped around the 3 different types. what's going on thanks... -bruce -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Se

RE: group by issue...??

At 16:58 -0700 9/10/04, bruce wrote: paul i do a select ID from hTBL group by type and i still only get a single row for each type, where i would expect to get the ~5000 rows, grouped around the 3 different types. Hmm. I see my previous answer said "with" and should have said "without". If you

Re: Copy a record

At 16:59 -0700 9/10/04, Dan Sashko wrote: hi, a quick question. is there a way to duplicate a record (without knowing fields in advance) in sql alone? the only thing is know is that `id` is a primary key (autonumber) something of this sort: INSERT INTO the_table SELECT * FROM the_table WHERE id=the

RE: group by issue...??

At 16:51 -0700 9/10/04, bruce wrote: paul forgive me for being a neophyte!!! but i have no idea how what you said helps me get to how i can actually get a grouping is there anyway to get a grouping... is there some other way to accomplish this..? am i totally lost! If you just want to s

Copy a record

hi, a quick question. is there a way to duplicate a record (without knowing fields in advance) in sql alone? the only thing is know is that `id` is a primary key (autonumber) something of this sort: INSERT INTO the_table SELECT * FROM the_table WHERE id=the_number this fails due duplicate entry

RE: group by issue...??

paul forgive me for being a neophyte!!! but i have no idea how what you said helps me get to how i can actually get a grouping is there anyway to get a grouping... is there some other way to accomplish this..? am i totally lost! thanks.. ps. i'm really trying to figure out how to g

Re: group by issue...??

At 16:27 -0700 9/10/04, bruce wrote: hi... if i do this... select h1.itemID as hitem, h1.process as process, h1.status as status, h1.tblType as tbl, h1.date as date from historyTBL as h1 where (h1.tblType = '3' or h1.tblType = '4'); i get a results table with ~5000 rows... if i add the 'group by'

Re: ORDER BY problem with JOINs

At 17:00 -0600 9/10/04, René Fournier wrote: I've got a SELECT statement that is returning the data I want, but not in the right order (and I don't know why...). Let's say there are two tables, People and History. Some records in People have corresponding records in History, but not all--so I

RE: Local Master replication issue

--log-slave-updates did the job. Regards, -Original Message- From: Sanjeev Sagar [mailto:[EMAIL PROTECTED] Sent: Fri 9/10/2004 3:36 PM To: [EMAIL PROTECTED] Subject: Local Master replication issue Hello All, I am seeing a small problem in Ring replication where one slave is acting as

group by issue...??

hi... if i do this... select h1.itemID as hitem, h1.process as process, h1.status as status, h1.tblType as tbl, h1.date as date from historyTBL as h1 where (h1.tblType = '3' or h1.tblType = '4'); i get a results table with ~5000 rows... if i add the 'group by' sql, select h1.itemID as hitem,

Re: Analyze Dreaweaver's PHP/MySQL code

--- Robb Kerr <[EMAIL PROTECTED]> wrote: > I'm trying to inform myself about exactly what > Dreamweaver's PHP/MySQL code > is doing when creating a recordset and repeat > region. Please help if you > can. > > DW MX generates the following to create a simple > recordset... > Line 1) require_once(

Re: ORDER BY problem with JOINs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 10 September 2004 18:00, René Fournier wrote: > I've got a SELECT statement that is returning the data I want, but not > in the right order (and I don't know why...). Let's say there are two > tables, People and History. Some records in Peopl

Drop database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In mysql 4.0.18 I have a database with innodb tables and foreign keys. I need to drop / recreate the database for testing purposes. When I enter the command drop database xxx I get an error message indicating a foreign key violation. As I a

ORDER BY problem with JOINs

I've got a SELECT statement that is returning the data I want, but not in the right order (and I don't know why...). Let's say there are two tables, People and History. Some records in People have corresponding records in History, but not all--so I need a LEFT JOIN TO connect history.people_id

Local Master replication issue

Hello All, I am seeing a small problem in Ring replication where one slave is acting as Local Master. See below M - Super Master S1/LM1 - Slave of super Master and act as Local Master for S2 S2 - slave of LM1 I ran one Insert on M, it showd up on S1/LM1 but it did not showed up in S2. What I c

Re: Compilation Error

--- Jim Grill <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I am trying to compile MySQL. I know that it is > possible to install this > > as a binary, that is not my goal. > > > > My environment consists of the following: If there > are other tools that > > I need to specify please let me know. > >

RE: The UNION makes us strong^H^H^H^Hcrazy

Why not just do it like this. You will need to compare the results yourself to make sure. But the numbers should be the same. And you don't have to do a union. select empssn,paycode_1,payrate_1 from paympe where paycode_1 != '000' or paycode_2 != '000' That might need to be an "and" and not an

RE: date question..

sorry... still couldn't see how to apply that particular page to my question... still trying to get an answer/solution.. -bruce -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 2:18 PM To: [EMAIL PROTECTED] Cc: 'gerald_clark'; [EMAIL P

Re: Local variables

Carlos Savoretti wrote: Hello all: I need to make certain operations like this: select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total' I'm using the C API; so I make it through mysql_query() Problem is than having `tbl_db' and 'tbl_hb' with certain values no operation is carried

Re: Keyword Searches

On Fri, 10 Sep 2004 14:24:23 -0700, Andrew Kreps wrote: > I've recently been doing a lot of work on keyword searches. The > methodology I've adopted consists of generating a list of keywords > based on the product information (while removing noise words), and > creating a table with one keyword p

Re: Keyword Searches

I've recently been doing a lot of work on keyword searches. The methodology I've adopted consists of generating a list of keywords based on the product information (while removing noise words), and creating a table with one keyword per line, relating to the product ID (many rows per product). The

Re: date question..

The manual describes 3 solutions to this problem . Michael bruce wrote: the earlier suggestion didn't work, as it only returned a single value... here's the entire issue i have... i have a select: mysql> select -> u1.url

Analyze Dreaweaver's PHP/MySQL code

I'm trying to inform myself about exactly what Dreamweaver's PHP/MySQL code is doing when creating a recordset and repeat region. Please help if you can. DW MX generates the following to create a simple recordset... Line 1) require_once('Connections/TBA.php'); Line 2) mysql_select_db($database_TBA

RE: date question..

the earlier suggestion didn't work, as it only returned a single value... here's the entire issue i have... i have a select: mysql> select -> u1.urltype as type, -> p1.name as fname, -> p1.fileID as ID, -> h1.itemID as hitem, -> h1.process as process, -> h1.status as statu

Re: where oh where, help!

Stuart Felenstein wrote: I have this query (below) that on it's own , directly into the database seems to return all the records just fine. Apparently though feeding it into a php loop, the lack of "where" is causing great distress(at least to the author) I'm wondering where to put it though. Be

Re: Local variables

Carlos Savoretti wrote: Hello all: I need to make certain operations like this: select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total' I'm using the C API; so I make it through mysql_query() Problem is than having `tbl_db' and 'tbl_hb' with certain values no operation is carried

Re: The UNION makes us strong^H^H^H^Hcrazy

On Fri, 2004-09-10 at 14:12, [EMAIL PROTECTED] wrote: > According to the docs, this should work in versions past mySQL 4, and I seem > to be running a version rather later than that > > mysql Ver 11.18 Distrib 3.23.52, for pc-linux (i686) > > What am I doing wrong here? I have two valid SELECT

RE: The UNION makes us strong^H^H^H^Hcrazy

Ah, so it is. Thanks. -- Dave Weingart, Sr. Programmer/Analyst"I can call modules from the vasty Private Label Servicesdeep." -- "Why, so can I, or so can Voice: +1-516-682-1470any programmer. But will they run FAX : +1-516-496-3160

Keyword Searches

Anyone created one? I've got a project that consists of a product catalog which the client wants to be "keyword" searchable. I have thought through several possible construction scenarios... 1) Table of products consisting of a single record per product. Each record contains a field in which they

Re: The UNION makes us strong^H^H^H^Hcrazy

> In a further followup to my needing to combine colummns, I have the two > following SELECTS that each work when I do them alone > > select empssn,paycode_1,payrate_1 from paympe where not paycode_1 = '000' > select empssn,paycode_2,payrate_2 from paympe where not paycode_2 = '000' > > However,

The UNION makes us strong^H^H^H^Hcrazy

In a further followup to my needing to combine colummns, I have the two following SELECTS that each work when I do them alone select empssn,paycode_1,payrate_1 from paympe where not paycode_1 = '000' select empssn,paycode_2,payrate_2 from paympe where not paycode_2 = '000' However, when I do sel

Local variables

Hello all: I need to make certain operations like this: select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total' I'm using the C API; so I make it through mysql_query() Problem is than having `tbl_db' and 'tbl_hb' with certain values no operation is carried out, and `Total' is

Advanced Query Wizard

This is not a sales post. I have been struggling with JOINed SELECT statements for a while now. The syntax just seems to elude me. However, I just found a Win Dreamweaver extension that rocks. The Advanced Query Wizard allows me to very quickly and easily write sophisticated, joined queries wit

where oh where, help!

I have this query (below) that on it's own , directly into the database seems to return all the records just fine. Apparently though feeding it into a php loop, the lack of "where" is causing great distress(at least to the author) I'm wondering where to put it though. Before each join ? And then

RE: What's Faster? MySQL Queries or PHP Loops?

I assume he means selecting every entry in a given table ("select column from table"). You should be able to easily find the answer to this by inserting some code that records times as you run. My bets are on SQL. Cheers, Brian -Original Message- From: Stuart Felenstein [mailto:[EMAIL PR

Re: search a field in all the tables?

Thanks so much for taking time replying, Rhino. Unfortunately, I don't know Java much. But I got your point. Yeah, I wish it could be done within MySQL. Bing > > - Original Message - > From: "Bing Du" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 10, 2004 10:5

Re: date question..

bruce wrote: i have a tbl with the following... foo date1 foo2 date2 etc... how can i do a select to get the last or 1st row based on the (latest/earliest) date? SELECT * FROM tbl order by datecolumn DESC LIMIT 1; SELECT * FROM tbl order by datecolumn ASC LIMIT 1; can't seem to get it to work..

RE: What's Faster? MySQL Queries or PHP Loops?

I've been meaning to follow up on this post. Can either Peter or someone expand and provide an example of "get all information in a single query..." Thank you , Stuart --- Peter Lovatt <[EMAIL PROTECTED]> wrote: > Hi > > What I do is to try and get all information in a > single query and th

date question..

i have a tbl with the following... foo date1 foo2 date2 etc... how can i do a select to get the last or 1st row based on the (latest/earliest) date? can't seem to get it to work.. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: search a field in all the tables?

- Original Message - From: "Bing Du" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 10, 2004 10:52 AM Subject: search a field in all the tables? > Many times I need to do this. I know the name of a specific field. But I > don't know which table has this field. Th

RE: Problem with Replication - Slave Option replicate-ignore-tabl e and replicate-wild-ignore-table

In the slave's my.cnf have you tried just expliciting statement what tables to ignore? replicate-ignore-table=db.table1 replicate-ignore-table=db.table2 ... replicate-ignore-table=db.tablen And remove the other statements? -Original Message- From: Mike Lohman To: [EMAIL PROTECTED] Sent:

Implementing xml/xpath UDF with libxml2

I'm trying to implement a UDF that supports xpath evaluation on a column using the gnome libxml2 library. The library is thread-safe EXCEPT for the initialization and deinitialization routines which need to be called on a pre-process basis. My question: 1. Is there a good place (or any place??)

Anyone familiar with dbQwiksite Pro

Wondering if there is anyone on the list who knows this product . Thank you, Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with Replication - Slave Option replicate-ignore-table and replicate-wild-ignore-table

Hi, I've got a running Master-Slave environment with 8 Slaves and 1 Master. The problem is not the replication itself, but to exclude some tables out of it. Excluding databases runs without problems. All server are of the same version: mysql --version mysql Ver 12.22 Distrib 4.0.18, for pc-linu

Re: Moving Data

SAN --- I think that's the key piece to this puzzle. It doesn't matter how fat your network pipes are, you will always encounter some network lag when reading or writing data from and to a SAN. There is an abstraction layer that must bundle your request to the disk then translate it from the

RE: Breaking table columns into separate rows

I'm going to be creating a printed report for the users using a report writing application (developed in-house by me, so I could,at some point, change it to do more t han it does, but there are only so many hours in a day) The table structure is not under my control; it's a legacy table structure

Re: Moving Data

J S wrote: How fast do your disks rotate? What kind of disk controller are you using (ATA, SATA, SCSI, ...)? Are they in a RAID array or not. If they are what RAID scheme are you using? I had to ask about this one because I'm not too sure about these sort of things. Apparently the box is using

Re: Breaking table columns into separate rows

First, I think your data structure is wrong. Like data should be in a single column, like an attribute column. This provides scalability (no limit on attributes) and efficiency (no empty columns). But, since you are probably stuck with what you have, try something like this: SELECT CONCAT(KeyF

Re: Moving Data

How fast do your disks rotate? What kind of disk controller are you using (ATA, SATA, SCSI, ...)? Are they in a RAID array or not. If they are what RAID scheme are you using? I had to ask about this one because I'm not too sure about these sort of things. Apparently the box is using ESS disks on

Optimize index building

Hi, We are using following steps to re-load and re-build a table every day: truncate the table disable index load data enable index What are the important parameters I should be watching out to make the "ebale index" step faster? Out table is over 10million rows and has two fulltext indexes. T

search a field in all the tables?

Many times I need to do this. I know the name of a specific field. But I don't know which table has this field. There usually are a lot tables in one database. So the question is how I can find out which table or tables has this field? If it can be done within one database, can it also be done

mysql_config missing - already read much docs

I just upgraded Mysql to 4.1.4-0 on linux using the following: MySQL-server-4.1.4-0.i386.rpm MySQL-client-4.1.4-0.i386.rpm So when i went to upgrade my perl DBI & DBD::mysql packages, it noticed that mysql_config was missing. My understanding is that mysql_config should be installed with the cl

RE: Dump question: transactions vs. locking

Maybe MyISAM is still a better choice for this use...? For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary column (or three columns in your case) in a multiple-column index. In this case, the generated value for the AUTO_INCREMENT column is calculated as MAX(auto_increment_colu

Re: Help with query

Shawn > SELECT CityName, Count(ClientID) as ClientCount > FROM City > INNER JOIN Client > on City.CityID = Client.CityID > GROUP BY CityName > HAVING ClientCount > 30; Thank you very much, It should solve by problem... :-) Ronan -- MySQL General Mailing List For list archives: http:/

Re: Help with query

SELECT CityName, Count(ClientID) as ClientCount FROM City INNER JOIN Client on City.CityID = Client.CityID GROUP BY CityName HAVING ClientCount > 30; Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ronan Lucio" <[EMAIL PROTECTED]> wrote on 09/10/2004 11:14:37 AM: >

Re: Breaking table columns into separate rows

When you say "report" what exactly do you mean? In the client., have you looked at using \G and not ; to terminate your queries? Why not transform your data structure and keep only one column of data, as you suggested? Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL

Re: Auto_increment

I hate to dampen your spirits but I think you have made a poor design choice. The word "key" is a reserved word in MySQL. In order to assign to a database object a name that is either a reserved word or a name that uses a special character, you must surround that with a pair of backticks, ``

Help with query

Hello, A have two tables: City: CityID CityName Client: ClientID ClienteName CityID How can I make a SELECT that returns me only the cities that have more than 30 (example) clients? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Breaking table columns into separate rows

I have a table that has a structure similar to this | KeyField | Attrib1 | Attrib2 | Attrib 3 | What I need to do for a report that I need to generate is break this into multiple rows, as | KeyField | Attrib1 | | KeyField | Attrib2 | | KeyField | Attrib3 | Key field is not unique, and obvio

RE: How can I avoid warm-up time?

You didn't mention you release number, but on 4.1 you can use "LOAD INDEX INTO CACHE". You can also use options like --init-file and enter your startup sql there for your warmup. Ed -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 7:36 AM T

Fw: moving data

How fast do your disks rotate? What kind of disk controller are you using (ATA, SATA, SCSI, ...)? Are they in a RAID array or not. If they are what RAID scheme are you using? How big are your buffers and other working areas? (show variables like '%buff%'; show variables like '%size%';). Your C

Auto_increment

Dears, I need to define a column within my table.I want to name it "key".Also i need to it is auto_increment & not null.Also i want to it is primary key. Please tell its statement. Yours,Mohsen = -DIGITAL SIGNATURE--- ///Mohsen Pahlevanzadeh Network admin

RE: How can I avoid warm-up time?

Tamar, The only way to fill the caches up is to execute queries. If there is a delay between your server coming up and the application being used, try executing the queries that your application will use from a start-up script (you'll need to work these out carefully. This way the caches will be

Re: Perl with MySQL

This is the 3rd time you have asked this. Perhaps you should take it to a perl list where it belongs. Kirti S. Bajwa wrote: Hello: I am trying to install Perl support with MySQL. After installing MySQL (v4.0.20)I run the following commands: % echo $PATH % perl -MCPAN -e shell No

mysqlcheck --check --extended --auto-repair

Hello, the mysqlcheck manpage and the MySQL Manual is unclear about repair options when issuing a mysqlcheck with --auto-repair. For example mysqlcheck --check --extended --auto-repair It seems to be clear that mysqlcheck does an extended check. But: if there are corrupt tables, will the re

Re: state my question more clearly Re: WHY this query keeps failure?

The name of the table is "temp". Could that mean it's a TEMPORARY TABLE or is it just a regular table with the name "temp"? If it IS a temporary table and you are trying to read its contents from a connection different than the one that created it, you won't be able to. Temporary tables are s

Open Source Survey

Dear all, I am conducting a survey on open source software. This is for my coursework at the Curtin Uuniversity of Technology. It will be great to have your participation in this survey. Below are the links: Brief introduction page: http://web.singnet.com.sg/~mikecck/opensource/Introduction1.htm

How can I avoid warm-up time?

Hi, We are now in the last phases of testing a new system on Mysql. We are using all MyISAM tables, on Linux. We found that after the mysql server is restarted, our application is very slow for a couple of minutes. We understand that this is because the caches have to fill up first - th

Dump question: transactions vs. locking

Hi, I think I have some problems understanding how transactions work, and how they relate to locking. Can someone please explain? The question is this: I have a table where I have a column into which I insert numbers in sequencial order - it is not set to auto_increment, though, because the fie

delay_key_write usage

According to the documentation, when delay_key_write is active the index keys aren’t written to disk until the table(s) are closed. When is a table closed? Is it only when a connection is closed? Thank you, Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

Re: moving data

Hi Shawn, Thanks for helping me out again! I've cut and pasted the answers below your questions: I would love to say how adequate your hardware should be but I have forgotten what hardware you have, sorry! Would you mind re-posting all of the specs for your DB server? 2 x 500Mhz CPUs 8GB Memory m