bigint(20) UNSIGNED DEFAULT NULL,
port_id tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
KEY date_id (date_id),
KEY country_id (country_id),
KEY comcode_id (comcode_id,date_id)
) ENGINE=MyISAM ROW_FORMAT=FIXED;
TIA,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
queries
were not dealt with by the query cache.
Any ideas?
Thanks, James Harvard
# Time: 060103 9:45:12
# [EMAIL PROTECTED]: lasso[lasso] @ localhost [127.0.0.1]
# Query_time: 86 Lock_time: 0 Rows_sent: 12 Rows_examined: 6733255
select sql_cache dates.date_month from data_gb_e data inner join
using PHP's mysql_pconnect for all my scripts. Could this be causing
the failed/aborted attempts?
What is not clear in the documentation is whether mysql_pconnect will open
another connection if the current one is in use.
-James
testing
with large data in development. I'm looking at the data heavy tables in
production and they average 140K per row...which is not even close to the
1MB max_allowed_packet default limit.
Any ideas? Anybody else encounter this?
-James
wp_options.MYI*
The symlink looks like this:
lrwxrwxrwx 1 mysql 25 2005-12-29 13:40 wordpress -
/mnt/docs/mysql/wordpress/
Does anyone have any ideas?
Many thanks,
James.
Logan, David (SST - Adelaide) wrote:
Hi James,
There are a couple of options (from the Linux side of things
,
James.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Aftab Khan wrote:
I have installed mySQL with admin ID and password. However when I login
using the mysql Administrator, it allows logons without a password. How do
I force it to get the password and authentic rather allowing only user id?
Thaks
Please refer to this page:
of my head if that would be able to use an index on
(year,period,week) though. Anyone?
Good luck,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am new to mySQL and have mac OS X. Please could any other Mac users or
anyone for that matter tell me the best way of connecting to a mySQL
database?
Should I use terminal or a program like PHPmyAdmin?
Cheers,
James
, of course, but
my-huge.cnf is a better starting point than my.cnf.
James Harvard
At 6:45 am -0800 23/12/05, Grant Giddens wrote:
I think that the reason the original query is so slow is that I don't have
enough RAM allocated to mysql. When the original query takes place, I see a
process
),
and IIRC MySQL uses 64 bit maths.
FWIW my preferred web app middleware - Lasso - does the same thing (only with
signed 64 bit numbers).
HTH,
James Harvard
At 11:17 pm +0200 23/12/05, Gleb Paharenko wrote:
On both 4.1.16 and 5.0.17 I've got the same results, however not 2^32
At 2:30 pm + 22/12/05, C.R.Vegelin wrote:
Hi James,
I saw your email about are primary keys always essential ?.
And that your app is essentially creating summary reports from large amounts
of summary data.
May I ask what reporting tool you use for summary data ?
My client sells (well
- might be useful if you continue to have trouble.
HTH good luck,
James Harvard
For the first time, I'm working with a really large database. I have 1
SQL statement that brings my server to it's knees. This setup is currently
on my home development PC, and not in production. The server
That's why I suggested simply using the supplied my-huge.cnf config file,
because I assume it was contructed by some MySQL uber-guru who does know how
much RAM to allocate to each variable!
James Harvard
Like I mentioned before, I am tweaking the .cnf files by blind trial and
error. I
worried about shaving 40 MB off a 2 GB file,
because 40 MB _was_ my hard disc! So presumably as the years go by increasing
processor power and storage speed size will mean we will no longer have to
compromise on purity of db design to get acceptable performance.
OK, now I'm just rambling.
James
, that is -
sorry!
TIA,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
destination country, trade
commodity category etc., but they are _not_ themselves referenced by any other
table. Therefore I have not yet found, nor do I envisage finding, any use for
an arbitrary auto_increment primary key. So why would/might I need a PK at all?
TIA,
James Harvard
--
MySQL
In hindsight my thread title was misleading - sorry. Should have been are
primary keys _always_ essential?.
JH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it
with the last time the table was ordered.
HTH,
James Harvard
At 9:29 am + 19/12/05, C.R.Vegelin wrote:
Now I use: ALTER TABLE t ORDER BY a, b, c, d, e, f;
This works fine, but takes about 13 minutes for 6 million rows.
Without inserts, deletes or other sorts, this PK order remains intact
hypenated words.
... MATCH (col_name) AGAINST ('s-au' IN BOOLEAN MODE) ...
HTH,
James Harvard
At 5:26 pm +0200 18/12/05, Octavian Rasnita wrote:
Please tell me how can I configure MySQL 5 in order to be able to search
(using fulltext indexes) for combined words like s-au.
--
MySQL General Mailing
Maybe I'm missing something, but can't you just multiply the number by itself?
select (3 * 3);
select (int_col * int_col) as squared from table_name;
James H
At 5:36 pm -0600 18/12/05, mos wrote:
How do I square a number in MySQL 4.1? I thought it would be something simple
like:
select 3**2
Well it works on Mac OS X!
While there is no beep command, you can possibly get it to beep by selecting
the character code for a terminal beep (this is what the mysql client uses
internally)
Try out:
SELECT char(7);
--
MySQL General Mailing List
For list archives:
Hi Cory - nice to see a fellow Lasso user here!
I've not use transactions myself but I think you might be having a problem with
autocommit.
http://dev.mysql.com/doc/refman/5.0/en/commit.html
HTH,
James Harvard
At 12:44 am -0700 15/12/05, Cory @ SkyVantage wrote:
I have a transaction
Thanks for all the feedback on this.
Is there any received wisdom on whether 1 dual core processor is better than 2
'normal' processors?
Also, is there any advantage to SCSI over SATA?
TIA,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
brands available in the UK, or UK based companies that
will build servers, supporting 3 discs (2 RAID 1 for the OS)?
Many thanks,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am looking for, as I want to see if sending 100
inserts at one time is faster than doing 100 inserts, one at a time. I
expect it is, but I would like to get some numbers for my query.
Thank you for any help.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black
nb.name
from stats_names sn
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDg4QcikQgpVn8xrARAsFUAJ4h
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDgdwkikQgpVn8xrARAky9AJ4lcBoVIsqkU2nBpca6fAZZsl5dvgCfR3H5
7ed5A7RcOLrcm2XxQh/zSD8=
=+Xos
-END PGP SIGNATURE-
--
MySQL
)
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDaRv2ikQgpVn8xrARAswuAJ9+bcmZ0i17hD2AJatCo4pAi1yBggCgjTv8
I have solved this problem, I was missing a slash in the path to the data
directory
Thanks,
James
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, October 26, 2005 4:41 AM
Subject: Re: Mysql 4.0 cpu usage
Hello.
Are you able
dumped was utf8 as well.
James
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, October 26, 2005 3:25 AM
Subject: Re: Error 1406
Hello.
I also tried modifying the mediumtext to longtext in the dumpfile but it
produces a column
Any help would be appreciated,
James
SOLVED, sorry for the message.
It was a different error, will post on it shortly
James
- Original Message -
From: James Sherwood [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 1:39 PM
Subject: Error 150 when inputing a dump
Hello,
I dumped a database
but it
produces a column with a -1 size for some reason.
Any ideas?
Thanks,
James
the process in the task manager. Any ideas?
Thanks,
James
) | NO | || |
| fullname | varchar(24) | NO | | | |
| ip | varchar(40) | NO | PRI | ||
| alive | int(11) | NO | | 0 | |
+---+-+--+-+-+---+
10 rows in set (0.02 sec)
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Brawley wrote:
James,
You can reproduce that error by writing ...
SELECT ...
FROM a, b INNER JOIN c ON a.x=c.y
The error goes away if you instead write ...
SELECT ...
FROM b, a INNER JOIN c ON A.x=c.y
I will try
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Brawley wrote:
James,
You can reproduce that error by writing ...
SELECT ...
FROM a, b INNER JOIN c ON a.x=c.y
The error goes away if you instead write ...
SELECT ...
FROM b, a INNER JOIN c ON A.x=c.y
so you might try
to an error of:
Unknown column r.rid in on clause.
Guess I will start working on creating a test db where I can
demonstrate this bug, to make it easy to reproduce.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE
We are having slowness issues with MySQL on Mac OS X 10.4. Here is what has been done...1) Tiger's native version of mysql was installed.2) A delete was attempted on 1.5 million records Note: These records are heavily referenced to other tables3) 8+ hours later the delete was cancelled and it
to the logs except the relay-log.
Can someone please advise? Using InnoDB's hotbackup.pl file to perform
the backups.
Cheers,
--
James Green
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
Dear Jim,
Re: your post at http://lists.mysql.com/mysql/189058, why bother
creating the mysqldump if you already have the snapshot? Why not just
backup the snapshot?
(I'd have hit reply online but didn't see a Reply button and
On Mon, 2005-09-19 at 13:14 -0400, George Herson wrote:
James G. Sack (jim) wrote:
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
Dear Jim,
Re: your post at http://lists.mysql.com/mysql/189058, why bother
creating the mysqldump if you already have the snapshot? Why
in the processlist seems to increment by
perhaps 5-10/second.
Is there a way to monitor the server, without putting too much of a load
on the mysql server, to see what is going on?
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP
this entry:
User: user1
Host: %
Now I'm allowed to access the MYSQL server. Doesn't % open it up to
all clients wanting to connect? I want to restrict which machine can
connect to the server. How do I do that?
--
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
quoting Alan Williamson [EMAIL PROTECTED] ..
This recipe is intended to minimize the impact on ongoing database
operations by inhibiting writes only during a relatively speedy
operation (creating a snapshot). The long dump operation can ...
This seems to be a rather long winded way of doing
This recipe is intended to minimize the impact on ongoing database
operations by inhibiting writes only during a relatively speedy
operation (creating a snapshot). The long dump operation can then be
performed on the (stable) snapshot, without interfering with ongoing use
of the live database.
-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDF1JEikQgpVn8xrARAmaBAJ4jDyW+RdjLBh+tW21PnYR8XRVajwCfbWCV
uQcsbwMY9HKRAa7srzk9TpY
on story_id = '3' fails?
In method A, 1 and 5 are deleted.
in method B, is only 1 deleted? are 1 and 5 deleted, or are none of
them deleted (i.e. MySQl treats this as one unit of work)?
--
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
/mysqld.log: No such file or directory
STOPPING server from pid file /var/run/mysqld/mysqld.pid
tee: /var/log/mysqld.log: Permission denied
050812 12:13:16 mysqld ended
tee: /var/log/mysqld.log: Permission denied
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
James
/mysqld.log: No such file or directory
STOPPING server from pid file /var/run/mysqld/mysqld.pid
tee: /var/log/mysqld.log: Permission denied
050812 12:13:16 mysqld ended
tee: /var/log/mysqld.log: Permission denied
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
James
.
Thanks for your ideas thus far,
James
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, August 15, 2005 1:41 PM
Subject: Re: French Characters, Still no answer
Hello.
You've already got a good answer:
http://lists.mysql.com/mysql
Hello,
I dont think we want to go this route as it was working fine on the 4.0
database on the other server.
I also might add that the old server was linux, and the new one is Windows
2000 Server
Thanks,
James
- Original Message -
From: Ace Dimitrievski [EMAIL PROTECTED]
To: [EMAIL
On Mon, 2005-08-15 at 20:01 -0700, Patrick Michael Kane wrote:
Did you ever get any responses on how to get innodb to a consistent
on-disk state for LVM snapshotting?
FYI, under LVM2 read/write snapshots are allowed.
I never got any replies.
If you look closely into my rambling posting,
I think I have found the problem:
Doing Select @@character_set_database , results, client and connection it
all returns
latin1
I tried set character_set_x = utf8; for them all but it did not work,
they stayed latin1 and need to be utf8
Any ideas how to change this?
Thanks,
James
We are using 3.0.9 and the latest is 3.1.10
But we connect to the old 4.0 database fine, would the connector matter?
James
- Original Message -
From: Jason Pyeron [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 16, 2005 1:59 PM
Subject: Re: French Characters, Still
the tomcat back to
the new database, it will not play nice with french characters. (they come
out as outlined squares etc)
Any ideas would be greatly appreciated
James
The older version is 4.xx.xx im not sure how to tell.
New version is 4.1.12
Thank you,
James
- Original Message -
From: Bruce Dembecki [EMAIL PROTECTED]
To: James Sherwood [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, August 15, 2005 2:50 PM
Subject: Re: French Characters
. (they come
out as outlined squares etc)
Any ideas would be greatly appreciated
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) AS open
FROM shipments, returns
GROUP BY shipments.DateShipped
ORDER BY shipments.DateShipped DESC
LIMIT 5
That's it. Im SO stuck with this query. I would really really appreciate
any help, hints, links, or ideas about it.
James G.
--
MySQL General Mailing List
For list archives
-Original Message-
From: James M. Gonzalez
Sent: 12 August 2005 16:58
To: 'Scott Noyes'
Subject: RE: Complex query. (It's killing me)
Sorry, I will explain myself more clearly:
Everyday, we ship packages, and we also receive some packages.
The one we receive, has been shipped by us
of conditions (like where clausules)
James
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 12 August 2005 16:41
To: [EMAIL PROTECTED]
Cc: James M. Gonzalez; mysql@lists.mysql.com
Subject: Re: Complex query. (It's killing me)
Sorry - I think you need a LEFT
Am I doing something wrong, or does the innodb engine design preclude
loading a server with a readonly database snapshot?
I'm talking about 4.1.x (or maybe 4.x) and linux lvm snapshots (lvm2)
specifically about MySQL-4.1.12 (mysql-4.1.12-2.FC4.1.x86_64.rpm)
tested on an AMD-64 + FC4
on and on.
Any help will be greatly apprecieted. (Im begging for help)
James
nams.prefs AS p ON(sne.badge=p.badge) WHERE
sne.badge=c.badge) AS UserFullname,
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http
in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFC1R8dikQgpVn8xrARAjsfAJ4hsAKn81s0/rjP3V9N1MccjUVPIACdHbSV
XiUuUvFYubdZgQnrfTGBNpw=
=mAcq
-END
since the last
backup is acceptable.
-James
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
How would I add a comment to rows in an existing table, if I am not
changing the row definition?
This is for mysql 4.1 and 5.0.
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED
2
chars and above. This will make the index files huge no?
--
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
performance?
-James
At 1:06 PM -0400 6/22/05, James wrote:
I have a table which includes the following columns in addition to
lots of other ones
name - populated with just one name
city - populated with just one city
keywords - lots of keywords
I'm definitely going to use a FULLTEXT
for this are to use mysqldump to reload
the tables. This isn't an option for us due to the size of the dataset
and it's 24/7 availability, hence we bought innodb hot backup.
And thus we are looking for suggestions. Any advice appreciated.
Thanks,
James
--
MySQL General Mailing List
For list
will be greately
appreciated.
James.
. Thoughts?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
James Nobis
Web Developer
Academic Superstore
223 W. Anderson Ln. Suite A110, Austin, TX 78752
Voice: (512) 450-1199 x453 Fax: (512) 450-0263
http
-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCqKXvikQgpVn8xrARAgLjAJ0aD8nDJu49TbD2xFAQPtoEgyXF3wCfXcRQ
krNHXdaEqrieu8efbpTM41I
EMS mysqlmanager it says 100.
I restarted the server etc. Any ideas as to why the max is not going to 200
in the variables list?
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This error is thrown in a mask we use called Torque, it does the connection
pooling but we have never had a problem with it such as this until now.
James
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 1:23 PM
Yes, we have been looking into that as well, the problem is is that some
changes we have made seemed to have helped and it takes 12hours or so for
the error to occur, making it a slow process:)
James
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql
is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCpFVBikQgpVn8xrARAhJaAJ0YINBpRLhq3VZ+YFkCSHMr1arxUACeKLTe
1ld
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCpFlmikQgpVn8xrARAh9qAJ0ekN/cqiuFPRs2urLkU5e2ulbFlQCfQ5+r
TJknK26B3tkDnFGa6hrlcXM=
=oLsU
-END PGP SIGNATURE-
--
MySQL
it to work now.
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCpJYGikQgpVn8xrARAlslAKCMf8ChA6s+pngbJ82D5WWOjZYLvACeJDPD
F4dI37k5oEv1H8SeaLfLB24=
=7MBu
-END PGP
it and change
the time format.
From - 30-May-05
To - 2005-05-30
The txt file is initially generated from an excel sheet.
Im using: MySQL 4.1.11 on Red Hat 9 with kernel 2.4.20
Any ideas?
James Collado
Thank you for all of your answers and suggestions. I feel a lot more
confident finishing my table designs
-James
, TABLE_B.Data
FROM TABLE_A, TABLE_B
WHERE
Activity = 'draw' AND Age 24 AND TABLE_A.Data_ID = TABLE_B.Data_ID;
(Aside: Would this query give me the same results as the above query?)
-James
internally?
Does it first create some sort of CROSS JOIN with the two tables (resulting
in a 5,000,000,000 row table)
and then finding the matching rows based on the WHERE clause?
-James
the contents of the data directory? Should that method
work?
-James
=? OR idx=? ...
SELECT name, id FROM table WHERE idx IN(?,?,?)
I am also using prepared statements, obviously, and looping through my
function 100 times, to get a better idea as to speed, and using junit
for the testing.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black
the details of
each activity when one of these records is selected.
PERFORMANCE-wise, which is better? METHOD A using the UNION, or
METHOD B, with a slight database modification.
DATABASE DESIGN-wise which is better?
Thanks!
--
-James
--
MySQL General Mailing List
For list archives: http
://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
James Nobis
Web Developer
Academic Superstore
223 W. Anderson Ln. Suite A110, Austin, TX 78752
Voice: (512) 450-1199 x453 Fax: (512) 450-0263
http://www.academicsuperstore.com
--
MySQL General Mailing List
For list archives
: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
James Nobis
Web Developer
Academic Superstore
223 W. Anderson Ln. Suite A110, Austin, TX 78752
Voice: (512) 450-1199 x453 Fax: (512) 450-0263
http://www.academicsuperstore.com
--
MySQL General Mailing List
at 4pm.
Thanx for any help.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My boss and I were playing with using select statements, and we can
actually execute subqueries as an option if the result is true or false.
Is this expected behavior, or is it something that may be fixed in a
revision, before I begin to depend on it
-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCb6NkikQgpVn8xrARAhEpAJwK1Yp9gBn0bnfUJ07dbf2bVHpSiACfd8Wi
HycjEYTbpk0NAPEtEgV5BpY=
=3+gk
-END PGP
at:
com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes, line 6963
I am curious if anyone else is having a failure like this.
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG
hope this makes sense.
I am thinking I am going to be doing this in my application.
Thanx for any suggestions.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using
...and then perform my search on this NEW table?
Thanks.
--
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
`...
-James
At 1:03 PM -0400 4/26/05, [EMAIL PROTECTED] wrote:
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
Corporation - Spruce Pine
James [EMAIL PROTECTED] wrote on 04/26/2005 02:15:49 PM:
I tried that and maybe I'm doing something wrong but...
-I have to select the same number of columns...for each UNION
-And each of the records from the union fall under the same column
headings as the first SELECT...
I
AND OrderLines.product_id =9
WHERE Order.customer_id IS NULL
I would expect this to return a single row with Customer.id 2.
Is there something obvious my coworkers and I are missing?
James Nobis
Web Developer
Academic Superstore
223 W. Anderson Ln. Suite A110, Austin, TX 78752
Voice: (512) 450-1199
Thanks everyone for such quick and thorough responses!
Quoting [EMAIL PROTECTED]:
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
501 - 600 of 1078 matches
Mail list logo