: [sqlite] UPDATE Help
On 15 Oct 2014, at 1:10am, Shantanu Namjoshi
<shantanu.namjo...@business.uconn.edu> wrote:
> ALTER TABLE dailydelete ADD COLUMN SMB varchar(11);
If you find yourself doing things like this your schema is messed up. SMB is
obviously data, not a column. Redesign your
of SQLite Database
Subject: Re: [sqlite] UPDATE Help
On Tue, Oct 14, 2014 at 8:10 PM, Shantanu Namjoshi <
shantanu.namjo...@business.uconn.edu> wrote:
>
> UPDATE dailydelete
> SET SMB = (SELECT dailyfactors.SMB FROM dailyfactors WHERE
> dailydelete.data = dailyfactors.Date),
On Tue, Oct 14, 2014 at 8:10 PM, Shantanu Namjoshi <
shantanu.namjo...@business.uconn.edu> wrote:
>
> UPDATE dailydelete
> SET SMB = (SELECT dailyfactors.SMB FROM dailyfactors WHERE
> dailydelete.data = dailyfactors.Date),
> SET Rf = (SELECT dailyfactors.Rf FROM dailyfactors WHERE
On 15 Oct 2014, at 1:10am, Shantanu Namjoshi
wrote:
> ALTER TABLE dailydelete ADD COLUMN SMB varchar(11);
If you find yourself doing things like this your schema is messed up. SMB is
obviously data, not a column. Redesign your table so that HML, SMB,
Hello,
I was writing for some help with a problem that has me stumped.
I have two tables in a DB. Table1 = dailydelete Table2 = dailyfactors.
dailyfactors is a list of dates and some corresponding information HML, SMB,
UMD and Rf for each of these dates
dates are NOT repeated in this table
5 matches
Mail list logo