ntsInclude column comments
> --default-precision Set to 18
> --default-scale Set to 0
> --complete-insert Includes list of column names
> in insert statements
>
> I'm not a perl guy and I'm not sure what to make of it other than the
> variabl
> 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 calle
> 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
What are you defining as a huge performance hit?
Is the result set 20K records, or the base tables? How big are the base
tables?
Are the client and server on the same machine? Pulling 20K records across
the network could take some time. Formatting 20K records into a pull -down
list in access will
>
> 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
selec
> 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 assoc
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
FROM
INTO with SELECT in parentheses
>
>
> 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.
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
> -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:
>
>
> 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:htt
> idx - index
> fld - field
>
> You can search them in google, but I'd like to know if MySQL has its
> own established conventions too.
>
> Regards,
> A$
>
> - Original Message -
> From: Jim Smith <[EMAIL PROTECTED]>
> Date: Friday, August 1, 2003
>
> 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 fo
>
> 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
> -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
>
> 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"
>
> 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'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 a
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 s
>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
>> >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
>> 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 th
22 matches
Mail list logo