Hi Hari.
I'd suggest having a customers table like this:
CREATE TABLE customers (
customerid UUID,
name VARCHAR,
email VARCHAR,
phonenr VARCHAR,
PRIMARY KEY(name, email, phonenr)
).
This way your inserts could be INSERT INTO customers (customerid, ...)
VALUES (...) IF NOT EXISTS;
Thanks Carlos...This certainly helps..
Sent from Yahoo Mail on Android
On Fri, Feb 12, 2016 at 2:02 AM, Carlos Alonso wrote:
Hi Hari.
I'd suggest having a customers table like this:
CREATE TABLE customers ( customerid UUID, name VARCHAR, email VARCHAR,
phonenr