Re: select from two table

Jocelyn > - Original Message - > From: "Dennis Salguero" <[EMAIL PROTECTED]> > To: "Osman Omar" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > Sent: Saturday, November 23, 2002 1:21 AM > Subject: Re: select from two table &g

select from two table

I have 2 table with same structure table 1 have name and position table 2 have name and position name in table 1 same as name in table 2 but position in table 1 may not same as position in table 2 how do I get data like this what is sql command nameposition.table1 position.table2 tha

Re: ERROR 1062

It's work thanks On Tue, 2002-08-27 at 14:24, Dan Nelson wrote: > In the last episode (Aug 27), Osman Omar said: > > below is my tables properties, > > and my last record id is 127; >

Re: ERROR 1062

query in all probability violates some referential integrity... and > this in all probability is a primary key defined in your table. > > So please check whether the query is trying to insert duplicate values in a > primary key field > > - Original Message - > From:

ERROR 1062

Hi I get this error. any idea? mysql> insert into emcs (insp_date,judge_date,model,lot_no,remark) values -> (20020816,20020816,'TA-SL5','010',''); ERROR 1062: Duplicate entry '127' for key 1 mysql> - Before posting

DISTINCT

Hi, I have a table like this model color - 135 blue 135 red 135 green 235 black 235 green How do I get how many row in each distinct model eg model 135 have 3 color model 235 have 2 color thanks. --

use LOAD DATA INFILE to update

Hi, Example, I have data inside my table id model data_in 1 str-de453 20010910 Now I have new update data inside text file eg model date_in str-de453 20010911 How can I use LOAD DATA INFILE REPLACE to update new data into my table ***I read manual but cannot file any ex

update data using LOAD DATA command

I have these data inside my tables id modelname datein 1 str-de345 20010901 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reques

always get error when check table

Hi, I use php to connect to mysql server. after that I check my table, myisamchk report that client not properly close the connection how to avoid this error? where should I check? thx. - Before posting, please check: ht

Got error 127 from table handler

I got this error messages when I try to access my table "Got error 127 from table handler" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

Fw: Aphace and MySql

- Original Message - From: "Jim Ray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 02, 2001 10:46 AM Subject: Aphace and MySql > Will MySQL work with Aphace for windows? > > Thank you > > Jim Ray > Work perfectly here. Now I'm using Apache 1.3 + MySQL 3.23 + PHP4

anonymous user can change grant table?

I use mysql win32. why I can change the grant table using anonymous (OBDC) user? how can I protect the grant table thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.