String to create a full database in SQLite Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceWhat is the difference between String and string in C#?How do I read / convert an InputStream into a String in Java?Creating multiline strings in JavaScriptHow do I make the first letter of a string uppercase in JavaScript?How to replace all occurrences of a string in JavaScriptImprove INSERT-per-second performance of SQLite?How to check whether a string contains a substring in JavaScript?Does Python have a string 'contains' substring method?How do I convert a String to an int in Java?Why is char[] preferred over String for passwords?
Limit for e and 1/e
Array/tabular for long multiplication
How do I automatically answer y in bash script?
I'm having difficulty getting my players to do stuff in a sandbox campaign
Active filter with series inductor and resistor - do these exist?
Classification of bundles, Postnikov towers, obstruction theory, local coefficients
Do working physicists consider Newtonian mechanics to be "falsified"?
Biased dice probability question
Unexpected result with right shift after bitwise negation
Fishing simulator
What is the largest species of polychaete?
How does modal jazz use chord progressions?
Antler Helmet: Can it work?
What's the point in a preamp?
Single author papers against my advisor's will?
What LEGO pieces have "real-world" functionality?
Why is "Captain Marvel" translated as male in Portugal?
Passing functions in C++
How are presidential pardons supposed to be used?
Autumning in love
Cold is to Refrigerator as warm is to?
Mortgage adviser recommends a longer term than necessary combined with overpayments
Was credit for the black hole image misattributed?
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
String to create a full database in SQLite
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experienceWhat is the difference between String and string in C#?How do I read / convert an InputStream into a String in Java?Creating multiline strings in JavaScriptHow do I make the first letter of a string uppercase in JavaScript?How to replace all occurrences of a string in JavaScriptImprove INSERT-per-second performance of SQLite?How to check whether a string contains a substring in JavaScript?Does Python have a string 'contains' substring method?How do I convert a String to an int in Java?Why is char[] preferred over String for passwords?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I wrote this string to create a Database in SQLite, but I get an error CREATE unexpected right before "CREATE corso". This is the string:
static final String DATABASE_CREAZIONE =
"CREATE TABLE utente (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null, "
+ "email text not null, password text not null);"
+ "CREATE TABLE corso (id integer primary key autoincrement," +
"nome text not null);" +
"CREATE TABLE prenotazione (id_utente integer primary key autoincrement, "
+ "id_docente integer primary key autoincrement, data DATETIME not null);"+
"CREATE TABLE docenza (id integer primary key autoincrement, "
+ "nome_corso text not null, nome_prof text not null); "+
"CREATE TABLE professore (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null); ";
java
android string sqlite asked Mar 8 at 14:58
BabbaraBabbara
196
add a comment |
I wrote this string to create a Database in SQLite, but I get an error CREATE unexpected right before "CREATE corso". This is the string:
static final String DATABASE_CREAZIONE =
"CREATE TABLE utente (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null, "
+ "email text not null, password text not null);"
+ "CREATE TABLE corso (id integer primary key autoincrement," +
"nome text not null);" +
"CREATE TABLE prenotazione (id_utente integer primary key autoincrement, "
+ "id_docente integer primary key autoincrement, data DATETIME not null);"+
"CREATE TABLE docenza (id integer primary key autoincrement, "
+ "nome_corso text not null, nome_prof text not null); "+
"CREATE TABLE professore (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null); ";
java
android string sqlite asked Mar 8 at 14:58
BabbaraBabbara
196
add a comment |
I wrote this string to create a Database in SQLite, but I get an error CREATE unexpected right before "CREATE corso". This is the string:
static final String DATABASE_CREAZIONE =
"CREATE TABLE utente (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null, "
+ "email text not null, password text not null);"
+ "CREATE TABLE corso (id integer primary key autoincrement," +
"nome text not null);" +
"CREATE TABLE prenotazione (id_utente integer primary key autoincrement, "
+ "id_docente integer primary key autoincrement, data DATETIME not null);"+
"CREATE TABLE docenza (id integer primary key autoincrement, "
+ "nome_corso text not null, nome_prof text not null); "+
"CREATE TABLE professore (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null); ";
java
android string sqlite asked Mar 8 at 14:58
BabbaraBabbara
196
I wrote this string to create a Database in SQLite, but I get an error CREATE unexpected right before "CREATE corso". This is the string:
static final String DATABASE_CREAZIONE =
"CREATE TABLE utente (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null, "
+ "email text not null, password text not null);"
+ "CREATE TABLE corso (id integer primary key autoincrement," +
"nome text not null);" +
"CREATE TABLE prenotazione (id_utente integer primary key autoincrement, "
+ "id_docente integer primary key autoincrement, data DATETIME not null);"+
"CREATE TABLE docenza (id integer primary key autoincrement, "
+ "nome_corso text not null, nome_prof text not null); "+
"CREATE TABLE professore (id integer primary key autoincrement, "
+ "nome text not null, cognome text not null); ";
java
android string sqlite java
android string sqlite asked Mar 8 at 14:58
BabbaraBabbara
196
asked Mar 8 at 14:58
BabbaraBabbara
196
asked Mar 8 at 14:58
BabbaraBabbara
196
asked Mar 8 at 14:58
BabbaraBabbara
196
asked Mar 8 at 14:58
BabbaraBabbara
196
196
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It's only the Android Studio IDE giving the warning but for a valid reason.
Android SQLiteDatabase execSQL() you typically use for executing SQL like this only executes a single statement at a time. Anything after ; will be ignored.
You need to split the SQL to separate execSQL() calls. That would also get rid of the IDE warning and execute the other parts of the SQL so you can detect runtime issues like reported by Boken in his answer.
answered Mar 8 at 15:08
laaltolaalto
117k27196235
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%2f55065817%2fstring-to-create-a-full-database-in-sqlite%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It's only the Android Studio IDE giving the warning but for a valid reason.
Android SQLiteDatabase execSQL() you typically use for executing SQL like this only executes a single statement at a time. Anything after ; will be ignored.
You need to split the SQL to separate execSQL() calls. That would also get rid of the IDE warning and execute the other parts of the SQL so you can detect runtime issues like reported by Boken in his answer.
answered Mar 8 at 15:08
laaltolaalto
117k27196235
add a comment |
It's only the Android Studio IDE giving the warning but for a valid reason.
Android SQLiteDatabase execSQL() you typically use for executing SQL like this only executes a single statement at a time. Anything after ; will be ignored.
You need to split the SQL to separate execSQL() calls. That would also get rid of the IDE warning and execute the other parts of the SQL so you can detect runtime issues like reported by Boken in his answer.
answered Mar 8 at 15:08
laaltolaalto
117k27196235
add a comment |
It's only the Android Studio IDE giving the warning but for a valid reason.
Android SQLiteDatabase execSQL() you typically use for executing SQL like this only executes a single statement at a time. Anything after ; will be ignored.
You need to split the SQL to separate execSQL() calls. That would also get rid of the IDE warning and execute the other parts of the SQL so you can detect runtime issues like reported by Boken in his answer.
answered Mar 8 at 15:08
laaltolaalto
117k27196235
It's only the Android Studio IDE giving the warning but for a valid reason.
Android SQLiteDatabase execSQL() you typically use for executing SQL like this only executes a single statement at a time. Anything after ; will be ignored.
You need to split the SQL to separate execSQL() calls. That would also get rid of the IDE warning and execute the other parts of the SQL so you can detect runtime issues like reported by Boken in his answer.
answered Mar 8 at 15:08
laaltolaalto
117k27196235
answered Mar 8 at 15:08
laaltolaalto
117k27196235
answered Mar 8 at 15:08
laaltolaalto
117k27196235
answered Mar 8 at 15:08
laaltolaalto
117k27196235
117k27196235
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%2f55065817%2fstring-to-create-a-full-database-in-sqlite%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
