People with insert more than a million random lines in an SQL? database can be up to integers type 1 to 1,000,000
Asked
Viewed 21 times
-4
Insert into num values(1)
example
Please edit the question to limit it to a specific problem with sufficient detail to identify an appropriate answer.
–
1
You would have to specify which SQL database you are using (Oracle, Mysql, Postgres, etc.), because to make 1 million Inserts using only SQL, without resorting to a client-side routine, you would have to use stored procedures, and each database implements a different dialect of SQL for stored procedures. Idem for random number generation will be some function called RANDOM() or RAND() but the exact name and type of number it generates will depend on the database.
Please edit the question to limit it to a specific problem with sufficient detail to identify an appropriate answer.
–
You would have to specify which SQL database you are using (Oracle, Mysql, Postgres, etc.), because to make 1 million Inserts using only SQL, without resorting to a client-side routine, you would have to use stored procedures, and each database implements a different dialect of SQL for stored procedures. Idem for random number generation will be some function called RANDOM() or RAND() but the exact name and type of number it generates will depend on the database.
– epx
And with a simple search they find diverse examples.
– Motta