Dennis Cote wrote:
Lloyd Thomas wrote:
Thanks. That is going OK but I am having a problem with updating the
new column with the info I need. It seems to update with the same
entry from my users table to all rows.
UPDATE call_data SET caller_name = (SELECT firstname || surname AS
'caller_name' FROM
new column to table
Dennis Cote wrote:
Lloyd Thomas wrote:
Thanks. That is going OK but I am having a problem with updating the
new column with the info I need. It seems to update with the same
entry from my users table to all rows.
UPDATE call_data SET caller_name = (SELECT firstname || surname
: [sqlite] add new column to table
Dennis Cote wrote:
Lloyd Thomas wrote:
Thanks. That is going OK but I am having a problem with updating
the new column with the info I need. It seems to update with the
same entry from my users table to all rows.
UPDATE call_data SET caller_name = (SELECT
Message -
From: Dennis Cote [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, January 12, 2005 5:21 PM
Subject: Re: [sqlite] add new column to table
Lloyd Thomas wrote:
Thanks Dennis.
As long as I know where I stand. I can probably use PHP or Delphi
to update each row manually
UPDATES with SUB SELECTS. What is
the URL?Lloyd- Original Message -
From: Bert Verhees [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Tuesday, January 11, 2005 7:55 AM
Subject: Re: [sqlite] add new column to table
Op maandag 10 januari 2005 23:56, schreef Lloyd Thomas:
Thanks
regarding UPDATES with SUB SELECTS. What is
the URL?
Lloyd
- Original Message -
From: Bert Verhees [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Tuesday, January 11, 2005 7:55 AM
Subject: Re: [sqlite] add new column to table
Op maandag 10 januari 2005 23:56, schreef Lloyd Thomas
I wish to create a new column in a table and add data, which is queried from
another table.What is the best way?
Lloyd
another table.
Lloyd
- Original Message -
From: Paul Dixon [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Monday, January 10, 2005 5:50 PM
Subject: Re: [sqlite] add new column to table
Lloyd Thomas wrote:
I wish to create a new column in a table and add data, which is queried
from
extn_no FROM call_data));
I have missed something?
- Original Message -
From: Lloyd Thomas [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Monday, January 10, 2005 9:08 PM
Subject: Re: [sqlite] add new column to table
Thanks Paul,
I have used that example before
: Monday, January 10, 2005 9:08 PM
Subject: Re: [sqlite] add new column to table
Thanks Paul,
I have used that example before to recreate a table. Can I
use the same thing to recreate a table and populate a new column with
data from a select query.
The table I wish to recreate
10 matches
Mail list logo