how to create the table daily & table name change according to the date in MYSQL

Question

2.50/5 (2 votes)

See more:

how to create the table daily & table name change according to the date in MYSQL.
i want syntax of this.
thanks in advance.

Posted 14-Jun-11 2:43am

Comments

Sandeep Mewara 14-Jun-11 11:08am

You need to provide more information on how & what are you doing?

Kschuler 14-Jun-11 11:40am

Are you asking how to automate creating a table each day? Is this for a backup? What's in the table?

1 solution

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Answer 1 · 2011-06-14T05:03:00

Start with MySql Connector/Net[^] and check out CREATE TABLE ...[^]

The get the current date and time in C# with DateTime.Now[^] and creating a table in a database is simple

SQL

CREATE TABLE tk (col1 INT, col2 CHAR(5), col3 DATE);

Where you can replace tk with the date from DateTime.Now

Posted 14-Jun-11 5:03am

Comments

vrushali katkade 15-Jun-11 0:37am

actually this task done by only MYSQL not me like daily event & i want the syntax of the event

Kim Togo 15-Jun-11 2:56am

The syntax for showing MySql Events is SHOW CREATE EVENT