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
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
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
But why do you need the parentheses?
What is wrong with
CREATE TABLE Foo2
SELECT * FROM sensei
WHERE last_name IN (SELECT last_name
FROM sensei UNION ALL
select last_name
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
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:
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
to know if MySQL has its
own established conventions too.
Regards,
A$
- Original Message -
From: Jim Smith [EMAIL PROTECTED]
Date: Friday, August 1, 2003 10:03 am
Subject: RE: standardized naming system ?
Hello list,
is there a common naming system for db objects
-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
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,
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
21 matches
Mail list logo
