I am fairly new at this although I have wanted to learn and tried again
and again...But I have a problem. I created a database and probably did
it wrong and I am trying to fix it. I made a database with 7 tables in
it all with a primary key and a record ID that matches the primary key.
Now when
On 7 Mar 2015, at 4:42pm, Dave wrote:
> I am fairly new at this although I have wanted to learn and tried again and
> again...But I have a problem. I created a database and probably did it wrong
> and I am trying to fix it. I made a database with 7 tables in it all with a
> primary key and a
Thanks Simon. If I can't figure that out I will just type all the data
in manually and learn from the school of hard knocks. :-) I googles it
and it seems that I am not the only one that has tried to do this and it
seems like it should be easy. I think in regular SQL it might be easier.
Oh well
Dave
I'm not sure exactly what you are trying to do from your description -
the schema of the tables you have and those that you want may help.
But as a general idea you might be able to use something along the lines of
create table newtable as select x, y, z from oldtable
More info here:
htt
On 2015-03-07 06:42 PM, Dave wrote:
> I am fairly new at this although I have wanted to learn and tried
> again and again...But I have a problem. I created a database and
> probably did it wrong and I am trying to fix it. I made a database
> with 7 tables in it all with a primary key and a rec
Hi Paul,
I got it sorted out I ended up with this using my SQLite Expert
Professional (if it matters).
update tableB set column2 = (select column2 from tableA where
tableA.rowid = tableB.rowid)
Of course I did not figure that out myself and asked for help on the
forum of the software and go
Ryan,
Thanks for your reply. As I mention in my last post:
I got it sorted out I ended up with this using my SQLite Expert
Professional (if it matters).
update tableB set column2 = (select column2 from tableA where
tableA.rowid = tableB.rowid)
Of course I did not figure that out myself and
On 2015-03-07 10:32 PM, Dave wrote:
> Ryan,
> Thanks for your reply. As I mention in my last post:
>
> I got it sorted out I ended up with this using my SQLite Expert
> Professional (if it matters).
There are a lot of great tools available for SQLite (possibly moreso
than any other DB system
On 3/7/2015 1:42 PM, R.Smith wrote:
>
> Hi Dave, you did not give us the schemata so I'm going to guess you
> have tables like this:
>
> CEATE TABLE T1("ID" INT PRIMARY KEY, "val1" TEXT);
> CEATE TABLE T2("ID" INT PRIMARY KEY, "val2" TEXT);
> CEATE TABLE T3("ID" INT PRIMARY KEY, "val3" TEXT);
>
Ryan,
I have been to the link below but was under the impression that SQL
and SQLite are two different things so I usually just look up SQLite
help. I can do simple queries as I did the Kahn Academy training. :-)
Most of the queries are straight forward but this one seemed a little
tougher.
On 2015-03-07 10:55 PM, Dave wrote:
> Ryan,
> I have been to the link below but was under the impression that SQL
> and SQLite are two different things so I usually just look up SQLite
> help. I can do simple queries as I did the Kahn Academy training. :-)
> Most of the queries are straight
Ryan,
Thanks for the added info. I will be happy to take this off-list for
any further pointers if they may be best suited there . I don't want to
be the guy that causes any trouble as a noob. :-) I will touch base with
you off -list soon but maybe in a day or so. I appreciate the help.
Thank
On 3/7/2015 11:42 AM, Dave wrote:
> Now when trying to use the database I see that I should have made 1
> table with all the related data (I think) and am trying to copy one
> column of data at a time to the "main" table. Can that be done and if so
> how? The data in all the columns has to line u
Thanks for the help Igor. :-)
Dave
On 3/7/2015 1:37 PM, Igor Tandetnik wrote:
>
>
> On 3/7/2015 11:42 AM, Dave wrote:
>> Now when trying to use the database I see that I should have made 1
>> table with all the related data (I think) and am trying to copy one
>> column of data at a time to the "ma
14 matches
Mail list logo