Hello, I am trying to write a script that creates tables via a cronjob but I want to name these tables including the current date as a suffix -like transections_20020324- . Does anybody know the SQL statement that entegrates the table name with the current date?
I tried to do it by storing the current_date value at a variable and then renaming the table with the variable but it did not work. Any help will be appreciated Regards Okan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php