(GRANT) and remove (REVOKE) privileges, but there is not a SQL command
to query current privileges.
At least on MySQL 4.0.16, SHOW GRANTS FOR [EMAIL PROTECTED]; shows me the
relevent info.
I don't know if that's MySQL specific, or not present in 3.x or
something.
--
Jim Richardson http
to allow that in MySQL?
As an aside, a recommendation on good beginner and intermediate level
MySQL books would be appreciated. I want to RTFM, but I want to make
sure it *is* the Fine manual :)
Oh, and seasons greetings to all, yes I'm working on Christmas, it's a
startup, what can I say...
--
Jim
.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 8:44 AM
To: Knepley, Jim
Cc: [EMAIL PROTECTED]
Subject: RE: Null-safe equal help, please
Please reply to the list so that others can follow this discussion.
Thanks.
At 8:26 -0700 12/17/03, Knepley, Jim
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe equal help, please
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
The manual, and my testing, shows that NULL = NULL evaluates to 1, so
my now-fevered mind sees no reason the two above statements are not
company has bought 4 licenses. I know that the source code is available for me to fix
it myself, but I'm not a database programmer, or even a C programmer, so that isn't a
reasonable option. I don't have any kind of C development environment set up.
-Jim Gallagher
--
MySQL General Mailing List
into the DB.
Any ideas on why this is happening? Any suggestions for alternatives?
Storing the files on the filesystem is not an option for me.
Thanks
I'm using 3.23.36 (linux RedHat) with MyISAM tables.
-jim kutter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- is
MySQL just not the right RDB to be using for tables this size?
-Jim Gallagher
Hello,
I am following the advice of the manual when bulk loading a large table by turning
off index builds before LOAD DATA INFILE. The load ends normally (73 GB). The
mysamchk build of the indices fails:
myisamchk
-O key_buffer_size=768M -O read_buffer_size=512M -O
write_buffer_size=512M -rq d:\mysql\data\mydb\mytable
I have 4GB of memory on the machine.
I searched for this problem with Google and found several others with the same
problem, but didn't find a solution.
Thanks,
Jim Gallagher
--
MySQL
-O key_buffer_size=768M -O read_buffer_size=512M -O
write_buffer_size=512M -rq d:\mysql\data\mydb\mytable
I have 4GB of memory on the machine.
I searched for this problem with Google and found several others with the same
problem, but didn't find a solution.
Thanks,
Jim Gallagher
--
MySQL
Looks like there's a bug in SQLyog -- when I restarted my machine this
morning, the query worked.
Thanks,
-Jim
Nitin wrote:
query seems perfect, what error is this giving?
Nitin
- Original Message -
From: Jim Bartram [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04
I've got the following select statement that is defeating me!
select title_id, ytd_sales from titles
where ytd_sales between 4095 and 12000;
The WHERE clause is not working... How should this be done in MySQL?
Thanks for any help,
-Jim
--
MySQL General Mailing List
For list archives: http
Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause, even when the matching
field is indexed.
Is this something that buffer
, and such, but nothing has worked so far. either it can't
be done (doubtful) or my brain can't figure it out (probable). short of
doing something rediculous like invividual selects for each unique
non_unique_id; is there a way i am missing?
I hope?
Thanks,
--jim
--
MySQL General Mailing List
For list archives
http://www.mysql.com/doc/en/MyISAM_table_formats.html
In the future you will be able to compress/decompress tables by
specifying ROW_FORMAT=compressed | default to ALTER TABLE.
Anyone know when this future is?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Thanks to you both for your assistance!
--- [EMAIL PROTECTED] wrote:
Hi
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Jim Mathews [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 10:18 PM
Subject: Re: Pronunciation of ISAM table name
Hi Jim
at people that call a SCSI drive
an es-cee-es-eye drive ;)
Thanks in advance.
Jim
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
,
timestamp fields?)
Thanks for the help; I hope it isn't a trivial question.
I'm new at this; I didn't find anything on moving records in the list
archives.
Jim Cant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The docs explicitly say that wildcards are allowed when specifying
database names in GRANT commands, but don't say anything about wildcards
being allowed in table names.
For example, in one large database I have table names that are grouped
by function:
security.ids_events
newtest2.Name,newtest2.Item
FROM newtest2,newtest
WHERE newtest2.Name != newtest.Name
GROUP BY Name;
This query returns only the 4 common records when I use = but returns all
6 records when I use or !=. I want only the last 2 items from Table
newtest2.
What am I doing wrong?
Thanks,
Jim
--
MySQL
http://www.serverlogistics.com/mysql.php has a link to a Preference Pane
item that can be used to start and stop MySQL. You will need to modify the
/Library/StartupItems/MySQL/MySQL file to point to the correct location.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing
execute the SQL commands in
mysql_install_db
Could somebody please help me get started with this?
-
Jim Gronquist
Gainty
- Original Message -
From: Doug Poland [EMAIL PROTECTED]
To: Jim Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith
:
data directory doesn't exist
What is the most likely cause of this?
-
Jim Gronquist
Computer Network and Programming Analyst
Office of the Bursar
Indiana University
812.856.3026 x6-3026
[EMAIL PROTECTED]
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
When I execute the following query I get duplicate
product_id's as shown
below:
SELECT * FROM product, product_category_xref, category WHERE
product_parent_id=''
AND product.product_id=product_category_xref.product_id
AND category.category_id=product_category_xref.category_id
AND
We're running MyODBC 3.51 on Windows 2000 Ssrver with IIS5 and ColdFusion 5
applications and don't see any memory leaks. In a very hight traffic
application, you'll want to keep connections open as long as possible anyway.
There's also a MyODBC list that you might try.
- Original Message
[EMAIL PROTECTED] wrote:
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It
offers
no performance benefit, and actually the computer might have to work
harder
to make sure the drives are in sync.
I do not think it is
Then you need to be even more explicit
INSERT INTO nye_opskrifter (foo,bar) SELECT foo, bar FROM opskrifter where
id
in($numbers)
-Original Message-
From: Lars Rasmussen [mailto:[EMAIL PROTECTED]
Sent: 13 August 2003 19:22
To: 'Jay Blanchard'; [EMAIL PROTECTED]
Subject: INSERT
* FROM Bar);
DROP DATABASE Foobar;
-- Cut Here --
Using MacOS so please forgive any errors due to case-sensitivity.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Adtrack - holds data about an ads status (but NOT page number)
Dummy - holds data about ad position, geometry and page number
Stories - holds data about stories and their page number
Pages - holds data about pages and their status
I want to be able to display a page and all its associated
Hi Mike,
What I was referring to was a library of user built functions, similar to
the ColdFusion libarary at www.cflib.org.
Is there such a beast?
James
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2003 8:47 AM
To: [EMAIL PROTECTED]
At 09:47 am 14/08/03, Jim Smith wrote:
But why do you need the parentheses?
This was a simplified query for example purposes.
The real query looks more like
(SELECT ...) UNION (SELECT ...) ORDER BY ...
I repeat. Why do you need the parentheses? Union queries don't require them.
I
Sorry, missed this.
They do need them if you want to use ORDER BY on the result
of the UNION.
Only if you are also ordering the component parts of the union.
This works
create table y
select * from x
union
select * from x
order by 1 desc
but this doesn't
create table y
select *
-Original Message-
From: Tomasz Korycki [mailto:[EMAIL PROTECTED]
Sent: 11 August 2003 05:26
To: [EMAIL PROTECTED]
Subject: OT: Re: MySQL field data type for ISBN numbers
At 21:08 2003-08-10, you wrote:
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
I
what ever happend to a unique primary key like userID ?
User is not the primary key. This is a logging table so the primary key is
likely to be a timestamp of some sort.
Read the question.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
address bound to NIC #1. I'd like to change this
to use an IP address bound to NIC #2, on a different subnet. Will this require
any configuration changes to the MySQL server? It's been quite a while since I
first configured the server.
Thanks,
Jim
--
MySQL General Mailing List
For list
- Original Message -
From: Pascal Délisle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 03, 2003 1:02 PM
Subject: Re: Nested SELECT statements problem
Finally, I solved my problem by creating a temporary table that holds
the result of the subquery. So, it looks like
Hello list,
is there a common naming system for db objects ?
Thousands.
Like:
1) Tables: mytable, tblmytable, tbl_mytable
2) Indices: idx_anindex
3) Columns: int_somenumber, date_lastupdate
4) id for the numerical primary key e.g. table customers.id
and then for referencing
[mailto:[EMAIL PROTECTED]
Sent: 01 August 2003 15:24
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: standardized naming system ?
Jim,
Great question!
I use the ol'Reddick VBA naming conventions.
tbl - table
idx - index
fld - field
You can search them in google, but I'd like
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: 30 July 2003 16:42
To: [EMAIL PROTECTED]
Subject: Advice wanted on Data Structure
I have a question that I hope I can explain well enough:
I am trying to figure out a data structure for an inventory
system.
If this is the case, is there a crude workaround method of
attempting to
perform the following until such a time as it is?
SELECT COUNT(*) FROM messages WHERE forum_id IN (SELECT forum_id FROM
forums WHERE team_no = 400)
select count(message_id) -- assuming you have a non-null id
SQL
and Access to use MySQL Server and this has been a big headache so far - even
just in migrating the data from one to the other.
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why does the client doing the importing need to run on Linux? Don't you have
access to a Windows machine anywhere on the network? It shouldn't matter where
the target MySQL server is or what OS it's running on.
- Original Message -
From: Robert Morgan [EMAIL PROTECTED]
To: mysqllist
Either do two queries or suppress the display of customer information within
your application code. I'd probably do two queries, especially if asking for a
lot of customer info or there were potentially a large number of orders for a
given customer. Doing a join in either case gives you a lot of
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:15 AM
Subject: Re: Huge Server configuration
I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
Unless you've designated one drive as a spare,
Just a quick question on whether I need both fields to
be indexed.
The table is as below.. I'm wondering if I need to have these
2 fields -
fa_id serial_no
fa_id would be a 7 character int like 001, 002
serial_no would be like WMACK001, WMACM121
most of the time,
We have a very large MySQL database, and the designer of the database no
longer works for us. I need to re-create the same table structure, but
without the content, on a separate machine.
I know I can do a show tables on the existing db, and also a describe on
those tables, so I know what
the name of the
'CREATE TABLE' column that is returned?
SHOW CREATE TABLE mytable
- Original Message -
From: Jackson Miller [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:42 PM
Subject: Re: How to export db or table
)) |
+--+
|0 |
+--+
1 row in set (1.07 sec)
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
From: Hubbard, Dan [EMAIL PROTECTED]
Date: Wed, 23 Jul 2003 08:39:01 -0700
To: [EMAIL PROTECTED
Does MySQL automatically handle deleted row cleanup, or is it necessary to
periodically do this manually for tables with a lot of deletions? If it's
manual, what are the SQL commands to do this?
Also, what happens when changes are made to a field definition? From, say, int
to smallint, or
the nagging feeling that it's more
complex than the example query is able to manage.
There could be a solution I haven't considered, as well... I'd love to
learn about it.
__
Jim Knepley
Network Security Engineering
x88321
--
MySQL General Mailing List
For list
Since I received no responses, maybe someone can take a moment to explain why
this is such a stupid question.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:28 PM
Subject: Is it necessary to compress tables?
Does MySQL
Since I received no responses, maybe someone can take a moment to
explain why this is such a stupid question.
Maybe not stupid, but definitely please see the manual questions.
Answers to Question 1:
http://www.mysql.com/doc/en/DELETE.html
http://www.mysql.com/doc/en/Optimisation.html
What tools are available for importing delimted text files into MySQL tables?
I've got several very large, but simple (just seven columns of integer and
varchar) text files to import into a table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Michael Satterwhite wrote:
So I can add the column, and I can set it to have an auto_increment, but
will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it will start at 1 and propagate
throughout: e.g.
Are you saying that it
Michael Satterwhite wrote:
Are you saying that it will propogate through the _existing_ rows, or only
on rows added later?
It will number all existing rows and continue with rows added later.
Interesting. In the case where you want to begin numbering existing rows at 1,
is it necessary
I'm fairly new to mysql myself, but I'll have a go.
The mysql manual is at http://www.mysql.com/doc/.
I've only dipped into it, but it seems to be pretty good.
Questions:
1. is mysql simular organized as oracle: instance/users/tables,
so that I have to connect to chossen instance and
1. No, especially not MyISAM. In MyISAM, a database (you can compare
that to instance) is just a directory on disk. Every table in this DB
(instance) again is file (well actually 3 files, one for data, one for
metadata, one for index information).
Actually the server is equivalent to an
I don't Mysql very well, but I would be very surprised if that was
supported, based on my experience with Oracle. You need to distinguish
between data and database object names. You can use derived_tables to return
data, but niot names.
You can't do select * from 'table', because 'table' is a
I've read through the archives and spent hours on Google but I still can't
figure this out. I must extract the data from a SQL Server *.DB file.
Viewing
the raw text, I can see that there views, grants, etc. at the top of the
file,
but this is a process that could not possible be done by hand.
If maximum speed is critical.
It's easy to lose sight of the fact that speed is not the
only criterion
in choosing a DBMS. Features, stability, security, and so on can be
just as important or more so. No single DBMS is going to win all the
prizes; the trick is to find the one with
I agree with your opinion in 100%, but in my case I need DBMS with
features like subselectes/utf-8/stored procedures but the
speed is also
very important issue.
You might have to spend money!
You are saying that there is DBMS with all this features and it is as
fast as MySQL ?
I don't
You're describing an adjacency list model, which is the most obvious
structure but arguably not the best.
Another data structure for this kind of thing is described at:
http://groups.google.com/groups?selm=%230%23O0OiFBHA.1932%40tkmsftngp04;
oe=UTF-8output=gplain
Cheers,
Jim
-Original
if you want to reply directly.
This is covered in the FAQ for the mailing lists:
http://lists.mysql.com/faq.php#replyto
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ON h.serverid = s.serverid
WHERE h.employeeid = 9
ORDER BY h.historyid DESC
Works fine once I remove the TOP 20 from the query. If this isn't supported,
is there an equivalent?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
If storage space is really a big motivator, you can roll your own by using
something like unsigned integers, each of which will accomodate 32 bit fields.
Then use bitmasks to read/write the values. Probably makes writing WHERE
clauses a bit tedious, and doing joins on the bit fields may not be
See http://www.mysql.com/doc/en/TODO_future.html
Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical)
structures.
Whatever their definition of The Near Future is... I'd guess v5
J
- Original Message -
From: Bernhard Schmidt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
[EMAIL PROTECTED] Is this redundant, or is there a reason for this? The original
MySQL
install was done by an application we're running, but we've since added
additional databases.
thanks,
Jim
--
MySQL
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: Greg Donald [EMAIL PROTECTED]
To: wael fareed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
my coulmn (id) is
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
That depends on what your
Jim McAtee wrote:
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL
What would be the ideal RAID configuration for a dedicated MySQL db server
running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What about
the best configuration for a dedicated W2k server running MySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list
..
Be sure to use a good raid controller, multiple channels for the disks if
possible..
On Sat, 5 Jul 2003, Jim McAtee wrote:
What would be the ideal RAID configuration for a dedicated MySQL db server
running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
I have had similar performance concerns, but on a much smaller scale.
The data was well indexed, but took far too long to query (particularly
with aggregate queries).
Check the individual row size of your table. In my case, I had a TEXT
field that would frequently be fairly long. Moving that
that wouldn't work?
Yes, you need to be doing a boolean full-text search to use the
operators like '*'. Your query would look like:
SELECT ID FROM emails
WHERE MATCH(h_subject, body) AGAINST ('V000*' IN BOOLEAN MODE);
Note that this requires MySQL 4.0.1 or later.
Jim Winstead
MySQL AB
] (including the complete headers), and we will
unsubscribe the address causing the messages.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
searching for.
'desc' is a reserved word. you need to surround it in backquotes when
using it as a field or table name.
SELECT * FROM products WHERE MATCH (`desc`) AGAINST ('usb')
There's more information about reserved words at:
http://www.mysql.com/doc/en/Reserved_words.html
Jim Winstead
MySQL
]
(BSent: Thursday, June 12, 2003 9:16 AM
(BTo: Adam Nelson; Knepley, Jim; 'Rodolphe Toots'; [EMAIL PROTECTED]
(BSubject: Re: mySQL GUIs
(B
(B
(BHi Jim Mysql List members,
(B
(Bsad to hear that there are still people around not using a propper OS ;-) -
(Blike a Linux, BSD or Unix based OS
I'm a big fan of Scibit's Mascon
-Original Message-
From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 5:17 AM
To: [EMAIL PROTECTED]
Subject: mySQL GUIs
hi!
i am looking for a good mySQL gui for windows
i have used mySQL front, which was an excellent free
On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote:
SELECT item_name AS name, item_desc AS desc FROM food;
'desc' is a reserved word.
Try:
SELECT item_name AS name, item_desc AS `desc` FROM food;
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http
to as '127.0.0.1', and not 'localhost'. When
using 'localhost', MySQL generally tries to connect using a local Unix
socket, and ignores the port you specify.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Go to the /usr/local/mysql directory and rename (mv) data to var.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporation
http://www.cfmc.com/
From: gerald jones - Sun Microsystems - Broomfield United States
[EMAIL PROTECTED]
Reply-To: gerald jones - Sun Microsystems
was consistent with the SQL-92 standard, but that has been relaxed in
SQL-99, and we are currently working towards SQL-99 compliance.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tried this I setup a test
between two computers here in the office and managed to get it to work.
Replication over SSL connections is not currently supported.
The current plan is that it will be supported in 4.1.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http
|
|1 | Test data | 2004-12-12 |
+--+++
Here's an article from SQL-Guru.com that explains the basic join types:
http://www.sql-guru.com/sql101/basicjoins.html
I hope that helps.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list
http://www.mysql.com/doc/en/String_comparison_functions.html
You could replace all CRLF sequences with spaces in a particular field
with a query like:
UPDATE mytable SET mytext=REPLACE(mytext, 0x0D0A, ' ');
Hope that helps.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list
On Thu, May 29, 2003 at 12:59:35PM -0700, 2Hosts.com wrote:
sorry for being a thikky, but how do i open a .ezm file?
This is answered in the FAQ for the mailing lists at
http://lists.mysql.com/faq.php#digest-oe
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http
That does it! Thanks much.
Jim
On Saturday, March 29, 2003, at 06:14 PM, Bruce Feist wrote:
Jim Miller wrote:
I want to do a join and select of these tables that will give me all
the Entrants who did NOT enter contest 1 (i.e., Mary and Bill).
Try:
select entrant.name
from entrant
looking for a 3.23-compatible solution
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.html#Linux_x86_RPM
(This is the second group of downloads on the page.)
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for the oversight.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
versions I was not able to get any table with a float to update.
Now, before my change, I could not even get a table with any numeric data to
update. How are others able to use software that prevents them from updating
a table that has numeric data?
--
Jim Dickenson
mailto:[EMAIL PROTECTED
); using any database
Fix:
None known. Floating point values representing time to fractions of a
second cannot be properly interpreted across replicated servers in multiple
timezones.
Submitter-Id:
Originator:Jim Heedles
Organization:
Spaceflight Systems Corporation
MySQL support: none
I have tried multiple times to build a version of 3.23.55 with support for
innodb under Solaris 2.6. I can not upgrade the version of the OS.
Here is the error:
source='mysql.cc' object='mysql.o' libtool=no \
depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \
depmode=gcc3 /bin/ksh
Dear Sir or Madam,
I have been having problems downloading myodbc from your website.
I went to web page http://www.mysql.com/downloads/api-myodbc-2.50.html.
I then selected the option MyODBC 2.50.39NT/2000/XP full setup
(1.5M)Download
As a result of a number of attempts one of two things
/workinout/search.html
It should be up most of the time, and over time, I will add improvements.
Its fast, and simple to use, and its 100% MySQL related. Comments welcome anytime.
Thansk
Jim Danforth
-
Before posting, please check
a list of useful links, parsed from the emails
b. produce a dynamic FAQ page
c. summarize problems into a dynamic top ten list
d. other useful sorts, filters and regex output, as i think of it.
Comments welcome anytime.
Thanks
Jim Danforth
, or
something else?
Jim
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
FYI:
Setting up a lab environment for this database answered my question.
I moved the big field to a dedicated table, and queries on data_static got
much faster. Instead of 60 seconds, the query is done in less than 1.
Thanks for all the ideas people sent me privately.
Cheers,
Jim
401 - 500 of 685 matches
Mail list logo