On 14 Jun 2009, at 6:52pm, Tim Bradshaw wrote:
> Well, it can if you are willing to be a bit devious. Something like
> this works:
>
> create table frobs (
> id integer primary key,
> frob varchar);
>
> create temporary table frobs_import (
> frob varchar);
>
> .import data frobs_import
>
> i
在 2009-06-14日的 18:33 +0100，Simon Slavin写道：
> On 14 Jun 2009, at 4:43pm, Kermit Mei wrote:
>
> > But I want to insert values from a file underlinux,
> > and I don't want write any code for it.
>
> Okay, that kind of information is important enough to appear in your /
> first/ post.
>
> > I hope
On 14 Jun 2009, at 18:33, Simon Slavin wrote:
>> I hope sqlite3 > .import FILE
>> can do it
>
> It can't.
Well, it can if you are willing to be a bit devious. Something like
this works:
create table frobs (
id integer primary key,
frob varchar);
create temporary table frobs_import (
fr
On 14 Jun 2009, at 4:43pm, Kermit Mei wrote:
> But I want to insert values from a file underlinux,
> and I don't want write any code for it.
Okay, that kind of information is important enough to appear in your /
first/ post.
> I hope sqlite3 > .import FILE
> can do it
It can't. However, if y
在 2009-06-14日的 14:50 +0100，Simon Slavin写道：
> On 14 Jun 2009, at 2:23pm, Kermit Mei wrote:
>
> > I want to create a new table, its primary key is an int 'id' column,
> > but
> > I don't want to insert the data by hand, I hope the system can
> > generate
> > it by adding id.
> >
> > For example,
On 14 Jun 2009, at 2:23pm, Kermit Mei wrote:
> I want to create a new table, its primary key is an int 'id' column,
> but
> I don't want to insert the data by hand, I hope the system can
> generate
> it by adding id.
>
> For example,
> mytable(id, name, age)
>
> When I insert name and age, th
Hello, community!
I want to create a new table, its primary key is an int 'id' column, but
I don't want to insert the data by hand, I hope the system can generate
it by adding id.
For example,
mytable(id, name, age)
When I insert name and age, the id is generated automatically.
And another que
7 matches
Mail list logo
