>>No only from the sqlite command line.
>
>I can only find an sqlite3 folder in my Python installation folder.
>Python\Lib\sqlite3
>
That's because you are using the default SQLite that comes with Python
which is only the library for connecting from Python.
I'll need to clarify that in the tu
I finished the tutorial and must say i am very happy. Ill probably go over it
again while writing some test dbs. The SQL command line still troubles me
>I'm not running it from Python I'm running it from the OS command line.
>You need to open a CMD shell window and cd to your SQL database folder
On 07/03/13 00:35, Lolo Lolo wrote:
Because i find following your tutorials very easy i have looked
> at the other topics you have on your site.
> i notice they are not available in Python 3
Not yet, I'm still working on them. :-)
I have been very busy at work the last 2-3 years so made littl
>I'm not running it from Python I'm running it from the OS command line.
>You need to open a CMD shell window and cd to your SQL database folder
>(E:\PROJECTS\SQL in the example above) and then run sqlite3.
thanks ill give this a try.
>We can logically split it like this
>and putting them tog
On 06/03/13 23:25, Lolo Lolo wrote:
can someone please explain this to me.
update Employee
set ManagerID = (Select EmpID
from Employee
where Name = 'John Brown')
where Name = 'Fred Smith' OR
Name = 'Anne Jones';
this is saying set the managerID of 'Fred Smith' or
On 06/03/13 18:50, Lolo Lolo wrote:
i then closed this interactive IDLE session. i reopened another session and
simply did
import sqlite3
cxn = sqlite3.connect('sqlite_test/test')
This gets you a connection to the data base
cur = cxn.cursor()
and this sets up a storage area for any resu
> You are missing cur.execute('SELECT * from users')
thanks:) this has fixed the 1st issue.
guys i still cant use the command line. but i guess i dont really mind as i
can just make a .py file...
i am having a lot of fun reading through alan's tutorial, everything is
becoming very clear bu
On 3/6/2013 1:50 PM, Lolo Lolo wrote:
im working through alan's sql tutorial. i have a few questions from there but
1st i wanted to try out an example in Core python's sql example.
import sqlite3
cxn = sqlite3.connect('sqlite_test/test')
cur = cxn.cursor()
after this i created a table called
On 03/06/2013 03:47 PM, Joel Goldstick wrote:
On Wed, Mar 6, 2013 at 1:50 PM, Lolo Lolo wrote:
im working through alan's sql tutorial. i have a few questions from there
but 1st i wanted to try out an example in Core python's sql example.
import sqlite3
cxn = sqlite3.connect('sqlite_test/test
On 03/07/2013 02:50 AM, Lolo Lolo wrote:
im working through alan's sql tutorial. i have a few questions from there but
1st i wanted to try out an example in Core python's sql example.
import sqlite3
cxn = sqlite3.connect('sqlite_test/test')
cur = cxn.cursor()
after this i created a table cal
On Wed, Mar 6, 2013 at 1:50 PM, Lolo Lolo wrote:
> im working through alan's sql tutorial. i have a few questions from there
> but 1st i wanted to try out an example in Core python's sql example.
>
> >>> import sqlite3
> >>> cxn = sqlite3.connect('sqlite_test/test')
> >>> cur = cxn.cursor()
>
> a
im working through alan's sql tutorial. i have a few questions from there but
1st i wanted to try out an example in Core python's sql example.
>>> import sqlite3
>>> cxn = sqlite3.connect('sqlite_test/test')
>>> cur = cxn.cursor()
after this i created a table called users and inserted some data.
12 matches
Mail list logo