B4J Question What's wrong with my MySQL query?

LWGShane · Jun 10, 2017

Hi, I'm am doing some experiments with creating a sync server to work with my upcoming release of a new version of KeyValueStore.

I'm testing the following MySQL Query on SQLFiddle (to see if it actually works before using it in B4X):

B4X:

CREATE TABLE IF NOT EXISTS
  Main (`TableName` TEXT, `KeyName` TEXT, `ValueObj` BLOB, PRIMARY KEY(`TableName`, `KeyName`))
REPLACE INTO
  Main (TableName, KeyName, ValueObj)
  VALUES("", "", "")

However, it keeps throwing an error. (See attached screenshot.)

OliverA · Jun 10, 2017

TEXT columns cannot be indexed (nor BLOB) in MySQL. Use VARCHAR(x), where x = 1 through 65,535.

imbault · Jun 10, 2017

Try

B4X:

CREATE TABLE IF NOT EXISTS
Main (TableName varchar(200), KeyName varchar(200), ValueObj BLOB,PRIMARY KEY (TableName,KeyName) );
INSERT  into Main (TableName, KeyName, ValueObj)
  VALUES('', '', '');

LWGShane · Jun 10, 2017

@imbault - Thanks! I modified INSERT INTO to REPLACE INTO and it works with SQLFiddle.

MySQL is a much better choice for cloud DB storage.

B4J Question What's wrong with my MySQL query?

LWGShane

Well-Known Member

OliverA

Expert

imbault

Well-Known Member

LWGShane

Well-Known Member

Similar Threads

B4J Question What's wrong with my MySQL query?

LWGShane

Well-Known Member

OliverA

Expert

imbault

Well-Known Member

LWGShane

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency