How to clear my log file?

[shinysherbina]

Hi,

I am new to MySQL scripting. I used tee command to append my logs.
But I wanted the log file to be cleared every time i execute the script.
Is there any command to do that?

Thanks
Shiny

[smantscheff]

Use tee without the append option.

[shinysherbina]

Hi,

Thanks for the response. But I used

tee C:/table_creation.txt;

I didnt use any append option. Is there any option to make it not append?

Thanks
Shiny

[smantscheff]

The tees I know all have an -a option for appending and overwrite otherwise. Enter tee --help to get an option list.

[shinysherbina]

Hi,

Thanks for the response again. Other than tee command is there any other command to create a log file fresh everytime in MySQL scripting? (Just like oracle's SPOOL)

Thanks
Shiny