python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sqlite

Joining and combining two tables that have the same ID for different rows

In SQLite I have two tables, tab_a and tab_b. Both have some similar columns and some that differ: tab_a -> id | utc | name | data_1 | data_2 | data_3 tab_b -> id | utc | name | data_x | data_y ...
test-img

Matthias

sql

sqlite

join

Votes: 0

Answers: 1

Latest Answer

You have to use UNION, not JOIN for your purposes like this: CREATE TABLE tab_a ( id int PRIMARY KEY, utc text, name text ); CREATE TABLE tab_b ( id int PRIMARY KEY, utc text, ...
test-img

Oleksii Tambovtsev

can't take string data from dialogfragment to sql database due to unresolved string

I want to have a dialogfragment take the contact name and number from the user and save it in an sqLite database that I can use to show as a cardview in the main activity. I tried following this tutor...
test-img

udbhav shrivastava

java

android

sqlite

android-studio

syntax-error

Votes: 0

Answers: 1

Latest Answer

Variables newName and newNumber do not exist. I believe that you want:- if(etName.length()!=0 && etPhonenumber.length()!=0){ AddData(etName.getText().toString(),etPhonenumb...
test-img

MikeT

Setting up sqlcipher in an electron app using electron-forge and webpack

I am trying to open a sqlite3 database encrypted with sqlcipher. I have the password and I could open it successfully using sqlitebrowser. I started my project using this template. It is based on the ...
test-img

clementlize

sqlite

webpack

electron

sqlcipher

electron-forge

Votes: 0

Answers: 1

Latest Answer

Well, I finally figured it out. Actually, I tried so much little changes but I managed to make the app work (nearly) as expected. How I found the solution First: this doesn't have anything to do with ...
test-img

clementlize

SQLite Text Charset

I've been trying to make queries into an SQLite database using Java and can't seem to convert the string to the correct charset (if its not already in the correct one) My query string is: '%00.interes...
test-img

Ry-

java

string

sqlite

character-encoding

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs