How to insert into different tables in single query

[rkspx]

Hi, I just discover SurrealDB a few days ago, so please give me some understandings if this isn't possible in SurrealDB.

I read the docs about INSERT where it is possible to perform a bulk insert in a single query like this:

INSERT INTO person [
   {id: "person:jaime", name: "Jaime", surname: "Morgan Hitchcock"},
   {id: "person:tobie", name: "Tobie", surname: "Morgan Hitchcock"},
]

However, is it also possible to define different table names in the data instead of just person table, for example:

INSERT INTO [
   {id: "evilperson:notjaime", name: "Not Jaime", surname: "Morgan Hitchcock"},
   {id: "badperson:nottobie", name: "Not Tobie", surname: "Morgan Hitchcock"},
]

I want to be able to insert multiple data into multiple table.

Thanks

[naisofly]

Hey @rkspx, welcome to the SurrealDB community 🎉
So you can do this with the CREATE statement, provided you're adding the same data to multiple tables.

--Note: meta::tb(id) returns just the table name portion of a record ID
CREATE townsperson, cat, dog SET
    created_at = time::now(),
    name = "Just a " + meta::tb(id);

Hope this helps!