Have a database and a table inside with 5 columns inside.

I want to the first column to have the site link so when i query for soma data to be able to know from where they are coming from...which site.

Thanks i will do it with the bash loop. I know how to do that. I thought that a Sql command may exist that not need a loop.

Like some kind of repeat command? I don't know of anything...

There are other methods most will use a loop or sequence of some type. You can create a file with 100 insert commands and then load that file via mysql comand. You can create a data file i.e basically using csv (comma separated variable) format of your data and load that via load data. You could "clone" a row using a select statement but that still needs a loop and a primary key of some sort.

From your various descriptions of the problem I am still in doubt that you will get the result that you want.

A more complete description of what you are trying to accomplish and the actual conditions would help others to understand the question and offer suggestions. For example, is there really just one column, or five (you have said both)? Are you expecting the 100 rows of domain names to be pre-filled and persist when you fill in the other unspecified columns? It wont work that way...

You were asked whether there were any key columns and said that there weren't. If there were any then you could UPDATE those with a range of keys specified in a simple WHERE clause... but with our confusion on the table structure...

Please review the Site FAQ for guidance in posting your questions and general forum usage. Especially, read the link in that page, How To Ask Questions The Smart Way. The more effort you put into understanding your problem and framing your questions, the better others can help!

2 members found this post helpful.