2021. már 29.

Access Create and Insert

írta: dataanalyticsdemo
Access Create and Insert

Action queries deserve more attention

Let's keep track of all my 40 cats:

insert into MyPets
values (1, "Fluffy", 8, "Brown", "")
Change the age:
update MyPets
set petAge = 9
where petID = 1

insert into subList (
values(2, "Timmy"), (3, "Fishy"), (4,"Catty"), (5,"Labrador")
)

Szólj hozzá

Access SQL