create a database with/for python to generate following numbers2019 Community Moderator ElectionHow can I represent an 'Enum' in Python?How do I use raw_input in Python 3Should I put #! (shebang) in Python scripts, and what form should it take?Best way to convert string to bytes in Python 3?Way to create multiline comments in Python?What is the Python 3 equivalent of “python -m SimpleHTTPServer”Relative imports in Python 3Using Python 3 in virtualenvWhy is “1000000000000000 in range(1000000000000001)” so fast in Python 3?Check for some attribute value in multiple instances and print another attribute from same instance in python
Russian cases: A few examples, I'm really confused
Counting certain elements in lists
Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?
Does the statement `int val = (++i > ++j) ? ++i : ++j;` invoke undefined behavior?
How do anti-virus programs start at Windows boot?
Why must traveling waves have the same amplitude to form a standing wave?
How to generate globally unique ids for different tables of the same database?
Identifying the interval from A♭ to D♯
What options are left, if Britain cannot decide?
Old race car problem/puzzle
Is it normal that my co-workers at a fitness company criticize my food choices?
Is a lawful good "antagonist" effective?
Can elves maintain concentration in a trance?
What are some nice/clever ways to introduce the tonic's dominant seventh chord?
Rules about breaking the rules. How do I do it well?
Did CPM support custom hardware using device drivers?
Will a pinhole camera work with instant film?
Making a sword in the stone, in a medieval world without magic
Am I not good enough for you?
Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?
How is the Swiss post e-voting system supposed to work, and how was it wrong?
How can I change step-down my variable input voltage? [Microcontroller]
Using "wallow" verb with object
What is IP squat space
create a database with/for python to generate following numbers
2019 Community Moderator ElectionHow can I represent an 'Enum' in Python?How do I use raw_input in Python 3Should I put #! (shebang) in Python scripts, and what form should it take?Best way to convert string to bytes in Python 3?Way to create multiline comments in Python?What is the Python 3 equivalent of “python -m SimpleHTTPServer”Relative imports in Python 3Using Python 3 in virtualenvWhy is “1000000000000000 in range(1000000000000001)” so fast in Python 3?Check for some attribute value in multiple instances and print another attribute from same instance in python
little new with python,JSON, XML and SQL.
i want to create the following:
- a user-database
- a number-database
user can fill in its name.. this will be stacked/append etc. (?) in the userdatabase.. before append, it will check if user already exists.
than the programm generates a number (following the previous number) thats appended tot the numberdatabase (or list?)
another feature could be that after a while the user can search for its numbers that belong to his name..
cannot find any kind of this anywhere.. anyone .. ? help.... :)
with regards..
python-3.x
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
|
show 1 more comment
little new with python,JSON, XML and SQL.
i want to create the following:
- a user-database
- a number-database
user can fill in its name.. this will be stacked/append etc. (?) in the userdatabase.. before append, it will check if user already exists.
than the programm generates a number (following the previous number) thats appended tot the numberdatabase (or list?)
another feature could be that after a while the user can search for its numbers that belong to his name..
cannot find any kind of this anywhere.. anyone .. ? help.... :)
with regards..
python-3.x
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
1
What have you tried and where is the problem?
– UnholySheep
Mar 6 at 18:55
1
SO is not a code writing service. "Here's a thing I want" is not an appropriate post for this forum.
– mypetlion
Mar 6 at 19:51
import sqlite3 conn=sqlite3.connect("probeer.db") c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS Probeer(naam TEXT, afdeling TEXT, nummer INTEGER)") create_table() def invoer_data(): invoer1=input("voer naam in:") invoer2=input("voer afdeling in:") invoer3=str(input("voer nummer in:")) naam = invoer1 afdeling = invoer2 nummer = invoer3 c.execute("INSERT INTO Probeer (naam, afdeling, nummer) VALUES (?, ?, ?)", (naam, afdeling, nummer )) conn.commit()
– DigiBoudy
Mar 7 at 15:40
weird.. a day later a get a error in the code at the connect from the sqlite3 ???
– DigiBoudy
Mar 7 at 15:43
error: conn=sqlite3.connect .... module 'sqlite3' has no attribute 'connect' ?????
– DigiBoudy
Mar 7 at 15:44
|
show 1 more comment
little new with python,JSON, XML and SQL.
i want to create the following:
- a user-database
- a number-database
user can fill in its name.. this will be stacked/append etc. (?) in the userdatabase.. before append, it will check if user already exists.
than the programm generates a number (following the previous number) thats appended tot the numberdatabase (or list?)
another feature could be that after a while the user can search for its numbers that belong to his name..
cannot find any kind of this anywhere.. anyone .. ? help.... :)
with regards..
python-3.x
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
little new with python,JSON, XML and SQL.
i want to create the following:
- a user-database
- a number-database
user can fill in its name.. this will be stacked/append etc. (?) in the userdatabase.. before append, it will check if user already exists.
than the programm generates a number (following the previous number) thats appended tot the numberdatabase (or list?)
another feature could be that after a while the user can search for its numbers that belong to his name..
cannot find any kind of this anywhere.. anyone .. ? help.... :)
with regards..
python-3.x
python-3.x
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
asked Mar 6 at 18:53
DigiBoudyDigiBoudy
12
12
1
What have you tried and where is the problem?
– UnholySheep
Mar 6 at 18:55
1
SO is not a code writing service. "Here's a thing I want" is not an appropriate post for this forum.
– mypetlion
Mar 6 at 19:51
import sqlite3 conn=sqlite3.connect("probeer.db") c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS Probeer(naam TEXT, afdeling TEXT, nummer INTEGER)") create_table() def invoer_data(): invoer1=input("voer naam in:") invoer2=input("voer afdeling in:") invoer3=str(input("voer nummer in:")) naam = invoer1 afdeling = invoer2 nummer = invoer3 c.execute("INSERT INTO Probeer (naam, afdeling, nummer) VALUES (?, ?, ?)", (naam, afdeling, nummer )) conn.commit()
– DigiBoudy
Mar 7 at 15:40
weird.. a day later a get a error in the code at the connect from the sqlite3 ???
– DigiBoudy
Mar 7 at 15:43
error: conn=sqlite3.connect .... module 'sqlite3' has no attribute 'connect' ?????
– DigiBoudy
Mar 7 at 15:44
|
show 1 more comment
1
What have you tried and where is the problem?
– UnholySheep
Mar 6 at 18:55
1
SO is not a code writing service. "Here's a thing I want" is not an appropriate post for this forum.
– mypetlion
Mar 6 at 19:51
import sqlite3 conn=sqlite3.connect("probeer.db") c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS Probeer(naam TEXT, afdeling TEXT, nummer INTEGER)") create_table() def invoer_data(): invoer1=input("voer naam in:") invoer2=input("voer afdeling in:") invoer3=str(input("voer nummer in:")) naam = invoer1 afdeling = invoer2 nummer = invoer3 c.execute("INSERT INTO Probeer (naam, afdeling, nummer) VALUES (?, ?, ?)", (naam, afdeling, nummer )) conn.commit()
– DigiBoudy
Mar 7 at 15:40
weird.. a day later a get a error in the code at the connect from the sqlite3 ???
– DigiBoudy
Mar 7 at 15:43
error: conn=sqlite3.connect .... module 'sqlite3' has no attribute 'connect' ?????
– DigiBoudy
Mar 7 at 15:44
1
1
What have you tried and where is the problem?
– UnholySheep
Mar 6 at 18:55
What have you tried and where is the problem?
– UnholySheep
Mar 6 at 18:55
1
1
SO is not a code writing service. "Here's a thing I want" is not an appropriate post for this forum.
– mypetlion
Mar 6 at 19:51
SO is not a code writing service. "Here's a thing I want" is not an appropriate post for this forum.
– mypetlion
Mar 6 at 19:51
import sqlite3 conn=sqlite3.connect("probeer.db") c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS Probeer(naam TEXT, afdeling TEXT, nummer INTEGER)") create_table() def invoer_data(): invoer1=input("voer naam in:") invoer2=input("voer afdeling in:") invoer3=str(input("voer nummer in:")) naam = invoer1 afdeling = invoer2 nummer = invoer3 c.execute("INSERT INTO Probeer (naam, afdeling, nummer) VALUES (?, ?, ?)", (naam, afdeling, nummer )) conn.commit()
– DigiBoudy
Mar 7 at 15:40
import sqlite3 conn=sqlite3.connect("probeer.db") c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS Probeer(naam TEXT, afdeling TEXT, nummer INTEGER)") create_table() def invoer_data(): invoer1=input("voer naam in:") invoer2=input("voer afdeling in:") invoer3=str(input("voer nummer in:")) naam = invoer1 afdeling = invoer2 nummer = invoer3 c.execute("INSERT INTO Probeer (naam, afdeling, nummer) VALUES (?, ?, ?)", (naam, afdeling, nummer )) conn.commit()
– DigiBoudy
Mar 7 at 15:40
weird.. a day later a get a error in the code at the connect from the sqlite3 ???
– DigiBoudy
Mar 7 at 15:43
weird.. a day later a get a error in the code at the connect from the sqlite3 ???
– DigiBoudy
Mar 7 at 15:43
error: conn=sqlite3.connect .... module 'sqlite3' has no attribute 'connect' ?????
– DigiBoudy
Mar 7 at 15:44
error: conn=sqlite3.connect .... module 'sqlite3' has no attribute 'connect' ?????
– DigiBoudy
Mar 7 at 15:44
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55030283%2fcreate-a-database-with-for-python-to-generate-following-numbers%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55030283%2fcreate-a-database-with-for-python-to-generate-following-numbers%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What have you tried and where is the problem?
– UnholySheep
Mar 6 at 18:55
1
SO is not a code writing service. "Here's a thing I want" is not an appropriate post for this forum.
– mypetlion
Mar 6 at 19:51
import sqlite3 conn=sqlite3.connect("probeer.db") c = conn.cursor() def create_table(): c.execute("CREATE TABLE IF NOT EXISTS Probeer(naam TEXT, afdeling TEXT, nummer INTEGER)") create_table() def invoer_data(): invoer1=input("voer naam in:") invoer2=input("voer afdeling in:") invoer3=str(input("voer nummer in:")) naam = invoer1 afdeling = invoer2 nummer = invoer3 c.execute("INSERT INTO Probeer (naam, afdeling, nummer) VALUES (?, ?, ?)", (naam, afdeling, nummer )) conn.commit()
– DigiBoudy
Mar 7 at 15:40
weird.. a day later a get a error in the code at the connect from the sqlite3 ???
– DigiBoudy
Mar 7 at 15:43
error: conn=sqlite3.connect .... module 'sqlite3' has no attribute 'connect' ?????
– DigiBoudy
Mar 7 at 15:44