KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a test SQLite table: CREATE TABLE test ( id INTEGER PRIMARY KEY NOT NULL, x REAL NOT NULL DEFAULT (RANDOM()), y REAL NOT NULL DEFAULT (RANDOM()), z REAL NOT NULL DEFAULT (RANDOM()) ) and I want to create over thousands of rows of random data, and how can I do it using a SQL query? I can't use a SQL FOR loop because loops are not supported in SQLite, and I'm thinking of SELECT ing all the data from the table then INSERT for each row, so the number of rows double each time I execute the query. I think that requires a nested query, which I don't understand.
Tags (comma-separated)
Save Edits
Cancel