[Solved] INSERT INTO with Auto increment
Posted: Tue Oct 17, 2017 11:05 pm
Hello all,
I'm trying to insert data into my table with a column that has autoincremented constraint. I've tried to research but I cannot find anything about openoffice base.
my table:
create table borrower(
Library_Card_Number integer Not Null Primary Key,
name varchar (40) Not Null ,
address varchar(40),
Postal_code varchar(20),
Phone_number varchar(20),
mebership_date date,
check(Phone_number like '^[0-9\-\+]{9,15}$')
);
ALTER TABLE "BORROWER" ALTER COLUMN "LIBRARY_CARD_NUMBER" INTEGER GENERATED BY DEFAULT AS IDENTITY;
Insert statement:
Insert into borrower(Library_Card_Number,name,address,Postal_code,Phone_number,mebership_date)
values (' ','Samil Shah','123 Home st','62989','0555121245','2008-02-01'
);
But of course is giving me an error, could you please help me?
I'm trying to insert data into my table with a column that has autoincremented constraint. I've tried to research but I cannot find anything about openoffice base.
my table:
create table borrower(
Library_Card_Number integer Not Null Primary Key,
name varchar (40) Not Null ,
address varchar(40),
Postal_code varchar(20),
Phone_number varchar(20),
mebership_date date,
check(Phone_number like '^[0-9\-\+]{9,15}$')
);
ALTER TABLE "BORROWER" ALTER COLUMN "LIBRARY_CARD_NUMBER" INTEGER GENERATED BY DEFAULT AS IDENTITY;
Insert statement:
Insert into borrower(Library_Card_Number,name,address,Postal_code,Phone_number,mebership_date)
values (' ','Samil Shah','123 Home st','62989','0555121245','2008-02-01'
);
But of course is giving me an error, could you please help me?