Multiple rows in database

[merkeddd]

Okay guys, i dont know to much about sql queries, i was wondering if someone could tell me how to add multiple rows using and insert statement like how to add rows 1-3000, with the value number: being 1-3000

for example: INSERT INTO `store`.`value` (`Number:`, `Name:`, `Amount:`) VALUES ('1', '', ''); instead i want something like

INSERT INTO `store`.`value` (`Number:`, `Name:`, `Amount:`) VALUES ('1-3000', '', ''); but ik that isnt right

 

[Belthazor]

i dont get it do you want to add 3000 rows that starts from 1 and end at 3000?
but to what do you want in name or amount or number?

explain plz

 

[merkeddd]

i want it in the column number but i want the rows to include amount and name, but just be empty