[EMAIL PROTECTED] (Daren Cotter) wrote:
I am having major troubles creating this query...ok here's some
background info:
I have three tables: members, which contains info about the member, such
as city, state, zip, marital status, etc; interests, which stores just
an interest_id and name; and
On Fri, May 31, 2002 at 01:56:12PM -0500, Dan Nelson wrote:
In the last episode (May 31), Mark said:
Cesar, you really should consider using placeholders and bind_param
(if available). Without using placeholders, the insert statement will
contain the literal values to be inserted and has
Hi All
Is there anything Equivalent in MYSQL for Union in Oracle..
As per my understanding mysql doesnt support unions ...so any suggestions
what could be done..
-Arul
-
Before posting, please check:
mysql database quota solution for help!!
-
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
Hi all,
I have a table including two colums: names and apartment numbers:
apt #| name
--
1 | Smith Joe
1 | Smith Anne
2 | Doe Richard
3 | Svensen Mike
3 | Brant Liza
I need to get a list in alphabetical order, but with people in the same
apt keept together:
Brant,
Patrik,
Friday, May 31, 2002, 2:22:10 AM, you wrote:
PB I suspect that there might be a bug in the LOAD DATA and SOURCE statements
PB of MySQL-4.0.1-2 (alpha), but since I'm not 100% sure, I am sending this
PB to the list and maybe someone else migt be able to reproduce...
PB My configuration:
Christopher,
Friday, May 31, 2002, 4:19:38 PM, you wrote:
CLW im missing the mysql and mysqladmin binaries after my admin guy installed
CLW the most recent stable mysql rpm on a (linux) machine. are these included in
CLW the client rpm that he may have missed or is there something new that i
CLW
Arul,
Saturday, June 01, 2002, 9:26:48 AM, you wrote:
A Is there anything Equivalent in MYSQL for Union in Oracle..
A As per my understanding mysql doesnt support unions ...so any suggestions
A what could be done..
MySQL supports UNION since 4.0.0. Look at:
marc,
Friday, May 31, 2002, 6:39:54 PM, you wrote:
mm I can¹t seem to make any of the describe or show queries work when I apply a
mm search statement:
mm Query=show table status from demo;
mm Works fine. Now I¹m trying to get info from only one table:
mm Query=show table status from demo where
They are bugged in 4.0.1 (apparently fixed in 4.0.2) so I wouldn't rely on
them too much.
Richard
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 01, 2002 11:33 AM
Subject: Re: Unions
Arul,
Saturday, June 01, 2002, 9:26:48
Hi All
I have created a table parent and also another table child where parentid
column in child is a foreign key to the id column in parent table
Is it possible that i have no entries in parent table , and i am inserting
null values for parentid in child table..
sql,query
Regards,
Hello,
I'm using MyODBC 3.5 on Solaris.
From time to time I get segmentation/bus error when using in a
multithreaded environment.
Looks always in the same place '_db_return_'.
Each of my threads has its own connection.
To be more accurate I'm using OTL
12 matches
Mail list logo