Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

how to insert row in a .txt file from command prompt?

I am trying to export some data from sql but need to have some comment at the top of the file.

If you know a way to do it either in sql or in cmd line that would be very helpful.

Update:

The edit fonctionnality is exactly what i was looking for.

I need to create a command line to add some rows.

How can I create a return in the command line?

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Use the union all clause of select sql to insert the comment.

    SELECT 'This is my comment on top', 'This is here to match the number of columns'

    UNION ALL

    SELECT COLUMN1, COLUMN2 from TABLE

  • 1 decade ago

    in cmd you can type edit ray.txt to open the file in a dos editor

    the other way to do it is in debug

    in command type

    debug ray.txt

    w 100 "this is the first line"

    something like that anyway - edit is your best choice

Still have questions? Get your answers by asking now.