SQL in python jupyter. Can't drop a column
I am learning SQL. I know basically nothing about it.
This in my code in the Jupyter notebook.
%load_ext sql
%sql sqlite://
%%sql
CREATE TABLE Store (Store_ID, Store Location, Opening_Year)
* sqlite://
Done.
%%sql
ALTER TABLE Store DROP Store Location
* sqlite://
(sqlite3.OperationalError) near "DROP": syntax error [SQL: 'ALTER TABLE Store DROP Store Location'] (Background on this error at: http://sqlalche.me/e/e3q8)
python sql jupyter-notebook
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
add a comment |
I am learning SQL. I know basically nothing about it.
This in my code in the Jupyter notebook.
%load_ext sql
%sql sqlite://
%%sql
CREATE TABLE Store (Store_ID, Store Location, Opening_Year)
* sqlite://
Done.
%%sql
ALTER TABLE Store DROP Store Location
* sqlite://
(sqlite3.OperationalError) near "DROP": syntax error [SQL: 'ALTER TABLE Store DROP Store Location'] (Background on this error at: http://sqlalche.me/e/e3q8)
python sql jupyter-notebook
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
add a comment |
I am learning SQL. I know basically nothing about it.
This in my code in the Jupyter notebook.
%load_ext sql
%sql sqlite://
%%sql
CREATE TABLE Store (Store_ID, Store Location, Opening_Year)
* sqlite://
Done.
%%sql
ALTER TABLE Store DROP Store Location
* sqlite://
(sqlite3.OperationalError) near "DROP": syntax error [SQL: 'ALTER TABLE Store DROP Store Location'] (Background on this error at: http://sqlalche.me/e/e3q8)
python sql jupyter-notebook
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
I am learning SQL. I know basically nothing about it.
This in my code in the Jupyter notebook.
%load_ext sql
%sql sqlite://
%%sql
CREATE TABLE Store (Store_ID, Store Location, Opening_Year)
* sqlite://
Done.
%%sql
ALTER TABLE Store DROP Store Location
* sqlite://
(sqlite3.OperationalError) near "DROP": syntax error [SQL: 'ALTER TABLE Store DROP Store Location'] (Background on this error at: http://sqlalche.me/e/e3q8)
python sql jupyter-notebook
python sql jupyter-notebook
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
asked Nov 12 '18 at 19:48
qwerty asdfqwerty asdf
184
184
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You forgot COLUMN:
ALTER TABLE Store DROP COLUMN Store Location
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
add a comment |
I recommend to use underscores for your column names. Then, you do not need to use quotes or brackets so that SQLite recognises the column name as an identifier:
CREATE TABLE Store (Store_ID, Store_Location, Opening_Year);
However, if you must have a space in the column name, use quotes. The SQLite Documentation says that you can use single quotes, double quotes or square brackets. But I recommend using double quotes for identifiers, so that your code is more portable:
CREATE TABLE Store (Store_ID, "Store Location", Opening_Year);
Also, SQLite doesn't support ALTER TABLE DROP COLUMN syntax. To achieve the same result, use the same method as described in the SQLite Tutorial:
BEGIN TRANSACTION;
ALTER TABLE Store RENAME TO temp_Store;
CREATE TABLE Store (Store_ID, Opening_Year);
INSERT INTO Store
SELECT Store_ID, Opening_Year
FROM temp_Store;
DROP TABLE temp_Store;
COMMIT;
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
add a comment |
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%2f53269113%2fsql-in-python-jupyter-cant-drop-a-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You forgot COLUMN:
ALTER TABLE Store DROP COLUMN Store Location
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
add a comment |
You forgot COLUMN:
ALTER TABLE Store DROP COLUMN Store Location
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
add a comment |
You forgot COLUMN:
ALTER TABLE Store DROP COLUMN Store Location
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
You forgot COLUMN:
ALTER TABLE Store DROP COLUMN Store Location
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
answered Nov 12 '18 at 19:54
JacobIRRJacobIRR
3,34821128
3,34821128
add a comment |
add a comment |
I recommend to use underscores for your column names. Then, you do not need to use quotes or brackets so that SQLite recognises the column name as an identifier:
CREATE TABLE Store (Store_ID, Store_Location, Opening_Year);
However, if you must have a space in the column name, use quotes. The SQLite Documentation says that you can use single quotes, double quotes or square brackets. But I recommend using double quotes for identifiers, so that your code is more portable:
CREATE TABLE Store (Store_ID, "Store Location", Opening_Year);
Also, SQLite doesn't support ALTER TABLE DROP COLUMN syntax. To achieve the same result, use the same method as described in the SQLite Tutorial:
BEGIN TRANSACTION;
ALTER TABLE Store RENAME TO temp_Store;
CREATE TABLE Store (Store_ID, Opening_Year);
INSERT INTO Store
SELECT Store_ID, Opening_Year
FROM temp_Store;
DROP TABLE temp_Store;
COMMIT;
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
add a comment |
I recommend to use underscores for your column names. Then, you do not need to use quotes or brackets so that SQLite recognises the column name as an identifier:
CREATE TABLE Store (Store_ID, Store_Location, Opening_Year);
However, if you must have a space in the column name, use quotes. The SQLite Documentation says that you can use single quotes, double quotes or square brackets. But I recommend using double quotes for identifiers, so that your code is more portable:
CREATE TABLE Store (Store_ID, "Store Location", Opening_Year);
Also, SQLite doesn't support ALTER TABLE DROP COLUMN syntax. To achieve the same result, use the same method as described in the SQLite Tutorial:
BEGIN TRANSACTION;
ALTER TABLE Store RENAME TO temp_Store;
CREATE TABLE Store (Store_ID, Opening_Year);
INSERT INTO Store
SELECT Store_ID, Opening_Year
FROM temp_Store;
DROP TABLE temp_Store;
COMMIT;
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
add a comment |
I recommend to use underscores for your column names. Then, you do not need to use quotes or brackets so that SQLite recognises the column name as an identifier:
CREATE TABLE Store (Store_ID, Store_Location, Opening_Year);
However, if you must have a space in the column name, use quotes. The SQLite Documentation says that you can use single quotes, double quotes or square brackets. But I recommend using double quotes for identifiers, so that your code is more portable:
CREATE TABLE Store (Store_ID, "Store Location", Opening_Year);
Also, SQLite doesn't support ALTER TABLE DROP COLUMN syntax. To achieve the same result, use the same method as described in the SQLite Tutorial:
BEGIN TRANSACTION;
ALTER TABLE Store RENAME TO temp_Store;
CREATE TABLE Store (Store_ID, Opening_Year);
INSERT INTO Store
SELECT Store_ID, Opening_Year
FROM temp_Store;
DROP TABLE temp_Store;
COMMIT;
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
I recommend to use underscores for your column names. Then, you do not need to use quotes or brackets so that SQLite recognises the column name as an identifier:
CREATE TABLE Store (Store_ID, Store_Location, Opening_Year);
However, if you must have a space in the column name, use quotes. The SQLite Documentation says that you can use single quotes, double quotes or square brackets. But I recommend using double quotes for identifiers, so that your code is more portable:
CREATE TABLE Store (Store_ID, "Store Location", Opening_Year);
Also, SQLite doesn't support ALTER TABLE DROP COLUMN syntax. To achieve the same result, use the same method as described in the SQLite Tutorial:
BEGIN TRANSACTION;
ALTER TABLE Store RENAME TO temp_Store;
CREATE TABLE Store (Store_ID, Opening_Year);
INSERT INTO Store
SELECT Store_ID, Opening_Year
FROM temp_Store;
DROP TABLE temp_Store;
COMMIT;
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
answered Nov 12 '18 at 22:27
bruceskyausbruceskyaus
316210
316210
add a comment |
add a comment |
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%2f53269113%2fsql-in-python-jupyter-cant-drop-a-column%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
