Hendro Suryawan [EMAIL PROTECTED] wrote on 05/25/2005 06:23:52 PM:
Hi Mathias,
Thanks for your suggestion, but i run this query to find multiple
records with the same name in field barang (double records). And the
results i found 94 rows at 54813 ms. I try your idea and the result is
the
Scott Purcell [EMAIL PROTECTED] wrote on 05/25/2005 09:22:32 AM:
I can do this programatically, and will alter the table. But there
are three tables that have foreign key references to the table I
will be altering.
They look like this.
CREATE TABLE ITEM_CAT_REL (
id INT,
matt g [EMAIL PROTECTED] wrote on 05/25/2005 12:45:22 PM:
While updating a record in a database, I inadvertantly forgot a
where statement; so instead of changing just one record, I changed
all 900 records in the database.
I've been trying to figure out how to fix this. My latest backup
Brian Mansell [EMAIL PROTECTED] wrote on 05/25/2005 03:09:03 PM:
Scott -
Check this excerpt out (
http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
Documentation. I hope it helps!
--bemansell
...
Every correct word in the collection and in the query is
Scott Purcell [EMAIL PROTECTED] wrote on 05/25/2005 03:35:54 PM:
Thanks Sean fo the info.
I see where it states the server is configured for 4 character
indexing. I would like to try and set it to 3 and do not understand
what an options file is:
The documentation states the following:
Dan Bolser [EMAIL PROTECTED] wrote on 05/24/2005 06:08:32 AM:
Hello,
I have data like this
PK GRP_COL
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
And I want to write a query to select data like this...
PK FK GRP_COL
1 1 A
2 1 A
3 1 A
4 4
shaun thornburgh [EMAIL PROTECTED] wrote on 05/24/2005
07:35:03 AM:
From: [EMAIL PROTECTED]
To: shaun thornburgh [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: 2 Joins in 1 Query
Date: Mon, 23 May 2005 12:20:05 -0400
shaun thornburgh [EMAIL PROTECTED] wrote on 05/23/2005
Michael Stassen [EMAIL PROTECTED] wrote on 05/24/2005 10:26:14
AM:
[EMAIL PROTECTED] wrote:
Dan Bolser [EMAIL PROTECTED] wrote on 05/24/2005 06:08:32 AM:
Hello,
I have data like this
PK GRP_COL
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
And I want to write
Martijn Tonies [EMAIL PROTECTED] wrote on 05/24/2005 02:32:05 PM:
Something like this would make more sense to me and provide greater
flexibility;
It doesn't to me...
student
student_id
name
age
address
---
address_id
street_name
Anoop kumar V [EMAIL PROTECTED] wrote on 05/24/2005 03:02:11 PM:
Thanks Peter - you gave me some ideas...
here is what I have so far (simplified for simplification..)
select t2.dt_aud_rec, t1.id_secr_rqst from isr2_aud_log t1, isr2_aud_log
t2
where t1.id_secr_rqst=t2.id_secr_rqst
and
Michael Gale [EMAIL PROTECTED] wrote on 05/24/2005 04:10:35 PM:
Hello,
Currently I have a large mysql table (36 million rows) and according to
the mysql-admin the data length is 6.5GB and my index length is 8.8GB.
I am new to mysql, but I would assume that my index should not consume
Hank [EMAIL PROTECTED] wrote on 05/24/2005 05:02:47 PM:
I have a table of school class assignments with the following fields -
the first four fields are the primary key:
Year (int)
Term (enum, Spring, Fall,Winter)
ClassID (int)
SectionID (int)
Attachement (varchar 225)
The attachment
shaun thornburgh [EMAIL PROTECTED] wrote on 05/23/2005
10:18:29 AM:
Hi,
The following query produces the number of bookings per project grouped
by
week:
SELECT WEEK(Booking_Start_Date) AS WEEK,
SUM(IF(B.Project_ID = 23, 1,0)) AS `Project A`,
SUM(IF(B.Project_ID = 42, 1,0)) AS
Cut and paste bites me again. The table reference portion (cut out
accidentally) should have been:
FROM Weeks w
LEFT Bookings b
on WEEK(b.Booking_Start_Date) = w.Week_Number
LEFT JOIN Projects p
ON p.Project_Id = b.Project_ID
sorry all!
Shawn
[EMAIL PROTECTED] wrote on
Computer Programmer [EMAIL PROTECTED] wrote on 05/20/2005 07:56:39 AM:
SELECT t2.`col1`, t3.`title`, t3.`col3`, t4.`published` FROM t1 LEFT
JOIN
t2 ON (t2.`catid`=t1.`id`) LEFT JOIN t3 ON (t3.`id`=t2.`sid`) CROSS JOIN
`main_data` t4 ON (t4.`id`=t2.`sid`) WHERE t2.`catid`='7' AND
Matthew Simpson [EMAIL PROTECTED] wrote on 05/20/2005 02:21:54 PM:
I use Mysql to store call detail records from telephone calls. I have
around 20 voice switches that send the call detail records in real time
using INSERT statements.
I am having a problem where I need to delete junk call
Alan Scott [EMAIL PROTECTED] wrote on 05/20/2005 03:47:55 PM:
MySQL Server v4.1.x
Is there a table in any instance of mysql that I write some queries and
insert/update statement against for moving databases between systems?
Any assistance would be appreciated.
Your question and
Lieven De Keyzer [EMAIL PROTECTED] wrote on 05/18/2005
01:44:31 PM:
I 'm writing a webapplication in Java that allows users to store
bookmarks.
The system scans these pages for differences at user-selected intervals.
At
another user-selected interval, the system sends notification mails
Lieven De Keyzer [EMAIL PROTECTED] wrote on 05/18/2005
03:21:02 PM:
From: [EMAIL PROTECTED]
To: Lieven De Keyzer [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Different TIMESTAMP columns
Date: Wed, 18 May 2005 15:05:17 -0400
Lieven De Keyzer [EMAIL PROTECTED] wrote on
Kristen G. Thorson [EMAIL PROTECTED] wrote on 05/17/2005
02:37:12 PM:
I am moving some code that was developed against MySQL 4.1 to a server
with 3.23, and I have one query that uses a subquery. I'm having a bear
of a time wrapping my mind around how to convert this. The original
query
Seena Blace [EMAIL PROTECTED] wrote on 05/16/2005 10:08:15 AM:
Any suggestion pl?
Seena Blace [EMAIL PROTECTED] wrote:hi,
here is table description
report1
+-+--+--+-
+-++
| Field | Type | Null | Key |
Seena Blace [EMAIL PROTECTED] wrote on 05/16/2005 11:13:48 AM:
shawn
I think 2nd query will return only 10 rows.
I want out like followings
date domain spam
05/05/05 hotmail.com120
05/05/05 yahoo.com 110
05/05/05
Ronan Lucio [EMAIL PROTECTED] wrote on 05/16/2005 04:21:17 PM:
Mathias,
Hi,
look at group by ... with rollup at :
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
Thank you very much for your help.
My needs arenĀ“t this, exactly.
GROUP BY WITH ROLLUP, returns me several
Please try my solution before you tell me it's broken, OK? I know you want
to see the top 10 spammers for EACH day. That's what I wrote for you.
Please try my solution with your data and get back to me with the results
and explain to me what's wrong so I can fix it.
Thank you for your
Scott Purcell [EMAIL PROTECTED] wrote on 05/13/2005 12:05:05 PM:
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with
this following query which uses the IN. I am running mysql ( Ver 12.
21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support the
IN.
How
Neculai Macarie [EMAIL PROTECTED] wrote on 05/12/2005 03:26:33 AM:
Not that I'm aware of. What type of conversions are you doing that
you
need 30,000 use vars? An easy solution would be to try it and find
out
:)
I need to move multiple linked entries (in around 12 tables) from
one
news [EMAIL PROTECTED] wrote on 05/11/2005 09:09:36 AM:
In article [EMAIL PROTECTED],
Peter Brawley [EMAIL PROTECTED] writes:
Scott, sorry, my mistake,
SELECT price
FROM fedex_zones z
INNER JOIN fedex_rates r ON z.zone=r.zone AND z.zip=94947
WHERE r.weight = 25;
PB
Steve Buehler [EMAIL PROTECTED] wrote on 05/11/2005 09:36:44 AM:
I am trying to figure something out about the compress function. If
I
wanted to compress a field in a column/row and write it back to the
table,
how can I do this? Is it possible to do it in one command? I tried:
update
Andy Pieters [EMAIL PROTECTED] wrote on 05/11/2005 04:41:05 PM:
Hi all
I want to 'copy' the contents of the table 'cart', where userid=... to
the
table pending_cart.
Here is some example data for the table 'cart'
++++-+
| id | userid | prodid | qty |
Chris [EMAIL PROTECTED] wrote on 05/10/2005 12:20:57 PM:
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
hi,
your need is:
select * from temp LIMIT 3,4;
-- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A
news [EMAIL PROTECTED] wrote on 05/06/2005 06:08:18 PM:
hi,
When designing data it is common to have lookup tables such
animal_type : dog=1, cat=2,bird=3 etc
And then in other tables to refer to animals by their number 1, 2
or 3. This is memory and
presumably speed efficient. Howver
You can use mysqldump to create a text version of your database. Mysqldump
will generate the statements that will both (re)generate your tables and
populate them with data. It may be the low tech solution you asked
about. Just dump your DB to file (memory stick, zip disk, CD-RW) and
move it
shaun thornburgh [EMAIL PROTECTED] wrote on 05/04/2005
06:54:23 AM:
Hi,
I have four tables among others in my database: Bookings, Work_Types,
Practices Projects. Bookings occur in a Practice for a Project and
have a
Work_Type. A Practice can have many Bookings but must have one and
Mahmoud Badreddine [EMAIL PROTECTED] wrote on 05/03/2005 01:43:55
PM:
Hi,
I would like to run a query on two tables that reside in two distinct
databases:
select * from db1.table1 join db2.table2;
This lists both tables adjacent to one another rather than in a
sequential
fashion as
My comments imbedded
Scott Hamm [EMAIL PROTECTED] wrote on 05/03/2005 03:16:31 PM:
Since I'm learning about Left joins and am trying to figure out a way
to quickly gather info from Database all at once, here is the SQL
statement. Please give me feedback how I should improve it for
Scott Klarenbach [EMAIL PROTECTED] wrote on 04/29/2005 05:39:36
PM:
Thanks Shawn, that helps a lot. I like your general idea of handling
it at application level. I guess my main concern w/ web apps and
locking the record (even at app level) is orphaned locks, resulting
from browser closes
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 05/01/2005
07:14:57 PM:
I created a mysqldump with --quote-names option, but I get this
error:C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test5.
txtERROR 1005 at line 54: Can't create table '.\db2\shift.frm'
(errno:
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
CREATE PROCEDURE cart_items_validate
(IN mcustid INT
V. Agarwal [EMAIL PROTECTED] wrote on 05/02/2005 02:26:28 PM:
which sytem table is checked when 'show tables'
command is executed in MYSQL ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Vivian,
Mathias was correct. I will be building on Mathias's answer by using your
PK for your original data table (since you neglected to name it I will
call it source_table) WITH THE ASSUMPTION that you cannot change your
data structure and that you already have a PK on the table:
Create a
How do you determine most recent? Is it based on the highest ID number
for a person or some datetime value you didn't show us?
This is another form of the groupwise maximum problem described here:
http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html
If after reading the
Anoop kumar V [EMAIL PROTECTED] wrote on 04/29/2005 11:00:11 AM:
Is it possible to do a date field validation using an sql query.
Its like we have an html field- its a free form text field and the end
user
should type in a valid date, of course in a predefined format only
(MM/dd/yyy). I
Re-read the section on foreign keys
(http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html).
It clearly says (in the second and third bullets) that you must index the
columns on both ends of a FK.
Add an index to ITEM_ASSET_REL that contains id as its first term then you
will
Scott Klarenbach [EMAIL PROTECTED] wrote on 04/29/2005 02:28:25
PM:
Hello,
I'm using MySQL 5.0.3 Beta, and I'm hoping for some general
tips/experience you guys may have had regarding optomistic vs
pessimistic locking in a web app (PHP 5.0.3)
I'm more of a windows programmer, and I've
mdnazrul [EMAIL PROTECTED] wrote on 04/28/2005 08:41:16 AM:
Dear Sir/Madam,
I'm new to mysql
Does any body know following program written in which language? is that
C++
or Java
Thank you for your support.
Sincerely
Nazrul
If you download MySQL you will also get a copy of it's
Berman, Mikhail [EMAIL PROTECTED] wrote on 04/28/2005 10:32:53 AM:
Hi,
I am promoting this E-mail to larger list in hope to find people who can
help me.
Regards,
Mikhail Berman
-Original Message-
From: Berman, Mikhail [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27,
Berman, Mikhail [EMAIL PROTECTED] wrote on 04/28/2005 10:50:17 AM:
Yes,
I do test DSN connection itself. It returns Success. Connection was
made. I am creating User DSN.
That's a good sign.
The only tool able to connect to my UNIX databases via ODBC driver is
MS-Access, not Excel.
If
OK, I am still confused. Let's run down the list of what's working and
what isn't:
a) In the ODBC manager, create a System DSN and click on the TEST
CONNECTION button. What happens?
b) In SigmaPlot, tell the software to use the connection you just created
and tested. What happens?
If we
Thank you for being so patient with me. What options does SigmaPlot give
you when selecting an ODBC data source? Have you verified that you are
either using the default settings (as you defined when you set up the
connection) or that you are using the same credentials you used to test
your
MySQL is not listed in the screenshot because that is a sample screenshot
provided by the **manufacturer**, not a screen shot from his installation.
I was trying to use it to get a sense of how many connection-specific
options he may have had control over from within SigmaPlot. Basically, it
Jay Blanchard [EMAIL PROTECTED] wrote on 04/28/2005
04:24:23 PM:
[snip]
I have question about how I can get top 2 rows for each group.
like I have table test
| seqno |
+---+
| 00122 |
| 00123 |
| 00123 |
| 00123 |
| 00336 |
| 00346 |
| 00349
Jonathan Mangin [EMAIL PROTECTED] wrote on 04/26/2005 05:09:23
PM:
- Original Message -
From: [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, April 26, 2005 3:20 PM
Subject: Re: Efficient select/insert
Jonathan Mangin [EMAIL
James Black [EMAIL PROTECTED] wrote on 04/27/2005 10:36:20 AM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am curious if there is a simple way to do this. I was just asked to
give some data that requires me to group by day of week and also group
by hour in day (two different pages).
Ed,
UNIQUE indexes (which you quote) and PRIMARY KEYS are similar but are NOT
the same thing. Both types of keys guard against duplication of values for
the tuple defining the index. However, PRIMARY KEYs hold special
significance in that many RDBMS storage engines will use the PK to
uniquely
[EMAIL PROTECTED] wrote on 04/26/2005 09:46:37 AM:
Hello,
I have a big problem, I only want to check if it's the minute 45
currently.
I want to make a virtual SELECT without tables:
mysql SELECT MINUTE(CURRENT_TIMESTAMP()) WHERE
MINUTE(CURRENT_TIMESTAMP()) = 45;
ERROR 1064 (42000):
Jigal van Hemert [EMAIL PROTECTED] wrote on 04/26/2005 10:35:06 AM:
From: Harald Fuchs
id INT(11) - accountID
name VARCHAR(32) - parameter name
value INT(11) - parameter value
Other tables contain string, datetime, etc. parameters.
Since most searches are made for a value
james tu [EMAIL PROTECTED] wrote on 04/26/2005 12:06:34 PM:
I have four different activities. Each has its own set of data that
I want to save. So, I made four different tables to hold the saved
data. Each record also has 'keywords' field (essentially this is the
only field that all
If you posted your actual table structures (SHOW CREATE TABLE xx\G) I
think I could be more helpful. Right now I am just shooting in the dark.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
James [EMAIL PROTECTED] wrote on 04/26/2005 02:15:49 PM:
I tried that and
Jonathan Mangin [EMAIL PROTECTED] wrote on 04/26/2005 12:26:20
PM:
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q-param(); # HTML checkboxes
foreach my $element (@array) {
my $sql = select col2,
Ed Reed [EMAIL PROTECTED] wrote on 04/25/2005 02:33:23 AM:
Does anyone else have any ideas about this topic?
Thanks
Ed Reed [EMAIL PROTECTED] 04/23/05 1:29 pm
Thanks for the reply,
I realize that user variables disappear when the connection closes
but I don't understand why what
Frank Bax [EMAIL PROTECTED] wrote on 04/25/2005 11:47:12 AM:
At 10:44 AM 4/25/05, Art.M (Wikki) wrote:
I have a large .sql file to upload which is about 9 mb and I was
wondering if anyone knew of a program that could break it up into
chunks of 2 mb or under? So I can upload it to a shared web
Frank Bax [EMAIL PROTECTED] wrote on 04/25/2005 02:27:58 PM:
At 02:07 PM 4/25/05, Scott Gifford wrote:
[EMAIL PROTECTED] writes:
Frank Bax [EMAIL PROTECTED] wrote on 04/25/2005 11:47:12 AM:
Or simply use split, default is 1000 lines, but can be changed
via
command line.
That's
Jeff McKeon [EMAIL PROTECTED] wrote on 04/25/2005 03:00:55 PM:
I have a table that contains records that link back to a main talbe in a
many to one configuration linked by table1.id = table2.parentid
Table1 (one)
Table2 (many)
I want to pull the latest records from table2 for each record
mathias fatene [EMAIL PROTECTED] wrote on 04/25/2005 03:19:33 PM:
Hi,
You can do something like that :
mysql select * from son;
+--+
| a|
+--+
|1 |
|2 |
|3 |
+--+
3 rows in set (0.02 sec)
mysql select * from mother;
+--+--+
| a| b|
Jeff McKeon [EMAIL PROTECTED] wrote on 04/25/2005 04:08:29 PM:
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:01 PM
To: Jeff McKeon
Cc:
mathias fatene [EMAIL PROTECTED] wrote on 04/25/2005 04:24:42 PM:
Hi,
Im sorry to disappoint you but this is an anti-performance solution.
Use joins rathers than subqueries, and don't use joins if you can (all
data in the mother table).
Imagine that table2 has 30.000.000 records, and not
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005 05:46:25
PM:
On 4/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005
01:56:03 PM:
On 4/20/05, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Apr 20), Willie Gnarlson
James Nobis [EMAIL PROTECTED] wrote on 04/21/2005
10:44:07 AM:
The problem is something fairly simple but yet MySQL seems to make this
complicated. Essentially, find a list of customers who have not
bought product
X ever. (Customers have orders, orders have order line items). All
3
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/21/2005 01:39:15
PM:
On 4/21/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005
05:46:25 PM:
On 4/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Willie Gnarlson [EMAIL PROTECTED]
Dan Rossi [EMAIL PROTECTED] wrote on 04/20/2005 12:55:45 AM:
Hi there, I was wondering how its possible to get the MAX of a primary
key of a table during an insert. I basically want to create a ticket
number, but use the primary key as part of the ticket number ie
FAULT-001 or
Willie Gnarlson [EMAIL PROTECTED] wrote on 04/20/2005 01:56:03
PM:
On 4/20/05, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Apr 20), Willie Gnarlson said:
I have been attempting to uncover a fast method for retrieving
unique
items from every column in a table. The table has
Hank [EMAIL PROTECTED] wrote on 04/19/2005 01:33:51 PM:
On 4/19/05, Keith Ivey [EMAIL PROTECTED] wrote:
Also, the index on zip_code, latitude, and longitude doesn't
make sense.
Yeah - I didn't even notice the indexes in the table def (I used my
own existing zip code table). That table
Rich Brant [EMAIL PROTECTED] wrote on 04/19/2005 03:05:51 PM:
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL.
OK, I don't see much wrong with this version either.
Again I ask you:
Which version you are using?
Can you post some sample data and the incorrect results?
Here is a similar query that is working for me. This matches Projects with
the people who have the resources to complete them (Suppliers).
James Nobis [EMAIL PROTECTED] wrote on 04/19/2005
04:04:24 PM:
The link below essentially means subquery support is useless for many
traditional purposes. You are stuck in a correlated subquery thus
performance
is the query being run out-to-in (subquery run for every row?) instead
of
Martin Gallagher [EMAIL PROTECTED] wrote on 04/16/2005
08:49:35 AM:
Hi,
I have the following query:
SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1
This returns a person randomly, but the chance of the person being
selected
is increased with a higher
Reynier Perez Mira [EMAIL PROTECTED] wrote on 04/18/2005
10:44:39 AM:
Hi list
I need to make a Quero that select all fields in wich the date are
inferior in 10 days to actual date. Something like this:
Actual date: 18-04-2005
Select all fields in which are bigger than: 08-04-2005.
Kendall Bennett [EMAIL PROTECTED] wrote on 04/14/2005 06:55:02
PM:
Hi Guys,
I am trying to work out if it is possible to create a select statement
that will sum table data into columns with different criteria and have
it all in one select statement. For instance I have the following that
Chris Knipe [EMAIL PROTECTED] wrote on 04/15/2005 04:36:17 AM:
SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS
Destination LEFT JOIN DepartureLocation ON
tlb2.DepartureID=tlb1.LocationID LEFT JOIN DepartureLocation ON
tbl2.ArrivalID=tbl1.LocationID ORDER BY
Aji Andri [EMAIL PROTECTED] wrote on 04/15/2005 09:01:40
AM:
Yes, I want to update all row in one query
--- Michael Stassen [EMAIL PROTECTED]
wrote:
Aji Andri wrote:
my table properties
`STY_REPORT_200501` (
`std_nis` int(10) NOT NULL default '0',
`std_class`
Aji Andri [EMAIL PROTECTED] wrote on 04/15/2005 12:34:23
PM:
STY REPORT
std_nis std_class std_item std_value
1111 1 8
111 1 2 7
111 1 5 6
111 1 4 9
222 3 1 6
222 3
Fan, Wellington [EMAIL PROTECTED] wrote on 04/15/2005 12:50:07 PM:
Hello all,
I have a link table that relates 'Profiles' with 'Categories':
CREATE TABLE lnk_profile_category (
profile_fk int(11) NOT NULL default '0',
category_fk int(11) NOT NULL default '0',
PRIMARY KEY
Chris Knipe [EMAIL PROTECTED] wrote on 04/15/2005 01:20:33 PM:
I eliminated your GROUP BY clause because you weren't actually
GROUPing
anything. You weren't looking for a MIN(), a MAX(), an AVG(), or
anything
else that GROUP BY was intended to be used for. That method of
de-duplicating
(You always need to include the list on all responses. In this case, I do
not work in PHP enough to be able to help with this particular problem but
I know there are several PHP experts on the list.) -- SG
- Forwarded by Shawn Green/Unimin on 04/15/2005 02:38 PM -
Aji Andri [EMAIL
Fixing my brain farts :-(
snip
Run your current status queries against the current table while if
you
want in-depth history of a particular flight, use the history table.
This will increase your responsiveness considerably as there should be
only 1 record per active flight in that table.
Aji Andri [EMAIL PROTECTED] wrote on 04/15/2005 03:49:52
PM:
this is my prosedure
1st. I'm, selecting base on std_nis=111 in
STY_RANK_200501
2nd. looping and fetching echoing
looping and fetching echoing
while ($nline = mysql_fetch_array($result)) {
echo
Graham Anderson [EMAIL PROTECTED] wrote on 04/14/2005 11:51:58 AM:
many thanks
that was exactly what I needed.
Building upon the initial question:
Is there a way to get Match statements to do partial word
searches...like %LIKE% ?
For example, if the below Match Against query with
A. Clausen [EMAIL PROTECTED] wrote on 04/14/2005 12:19:05 PM:
I'm running MySQL 3.23.58 on a Win2k server with multiple IP addresses
and
I'm wondering whether there is a way to limit the MySQL server to
answering
on just one IP address.
--
A. Clausen
Yes.
Andy Pieters [EMAIL PROTECTED] wrote on 04/14/2005 12:55:20 PM:
Hi all
I will first set out what I need and then why I need it. Since I'm
currently
implementing I can still change stuff.
I have a product input form that stores the information in a table.
The product can be assigned
Fernando Henrique Giorgetti [EMAIL PROTECTED] wrote on 04/14/2005
02:34:30 PM:
Hi Folks!
Here, I have the following table:
CREATE TABLE `accesses` (
`time` varchar(15) NOT NULL default '',
`duration` int(10) default NULL,
`user` varchar(25) NOT NULL default '',
`ipaddr`
ManojW [EMAIL PROTECTED] wrote on 04/13/2005 04:23:31 AM:
Dear Shawn,
First off, apologies for the delay in reply to this email.
Secondly, thanks a lot for a very illuminating dicussion on
composite keys and the way MySQL handles them. Reading through the
whole discussion, I
mel list_php [EMAIL PROTECTED] wrote on 04/13/2005 05:43:07 AM:
Hi Gordon, hi list!
Thank you for your help.
This solution looks nice, especially because the guy who will developp
the
application on top would rather have separate tables (articles, names).
That would give a schema like:
mel list_php [EMAIL PROTECTED] wrote on 04/13/2005 11:07:44 AM:
When you mention external databses, I got curious. Do you mean
external
as in not on that MySQL server? Or, do you mean external as in
same
server, different database?
If you are designing your site correctly, the user
Tom Crimmins [EMAIL PROTECTED] wrote on 04/13/2005 12:37:44 PM:
On Wednesday, April 13, 2005 11:29, [EMAIL PROTECTED] wrote:
Hi,
The MYSQL command line interface is very basic. Can it be modified
like the shell command prompts so that I can include date/time for
timing benchmarks?
Graham Anderson [EMAIL PROTECTED] wrote on 04/13/2005 01:46:35 PM:
Hi
I am trying to set up my Match statements to filter the result of the
main query [which works]
If 'chris' does not exist in the first MATCH statement [AND MATCH
(media.name, media.product)], then the results get a bit
B Wiley Snyder [EMAIL PROTECTED] wrote on 04/11/2005 10:38:12 PM:
Hello experts,
I just need someone to please point me in the right direction on
retaining
my key or id order in my table when I delete a row. So for example I
have
10 rows Id 1-10 that are created automatically when the
James Nobis [EMAIL PROTECTED] wrote on 04/12/2005
10:19:33 AM:
Hi all,
Essentially I was asked to look into a problem with a query at the
office which
used AVG on a datetime column which produces incorrect results. (MySQL
4.1.10
on RHEL 3 update 4) As you can see below the stark
I think that's because those databases render datetime values into their
seconds from epoch values (whichever epoch they use) when casting to a
numeric type (I know MS SQL does. I assume the others do, too.) It seems
that MySQL is the oddball on this issue.
Shawn Green
Database Administrator
Dan Bolser [EMAIL PROTECTED] wrote on 04/08/2005 06:45:42 PM:
On Fri, 8 Apr 2005 [EMAIL PROTECTED] wrote:
Dan Bolser [EMAIL PROTECTED] wrote on 04/08/2005 12:41:35 PM:
On Thu, 7 Apr 2005, Sean Nolan wrote:
I think you'll find you can do what you want with a cross join. A
cross
Dan Bolser [EMAIL PROTECTED] wrote on 04/11/2005 11:50:31 AM:
On Mon, 11 Apr 2005, Dan Bolser wrote:
Requirement:
Given two columns of a table (Column1 and Column2) of length x, return
two
columns (Column1_Scram and Column2_Scram) such that the distributions
of
values in Column1 and
701 - 800 of 1587 matches
Mail list logo