Comments
it should be "create table stu_table_backup as( select * from stu_table); "
above query is wrong.. use create table stu_table_backup AS ( select * from stu_table);
can we get all the constraints along with the data back up
Post your Comment
how to take a backup of a table in sql how to take a backup of a table in sql how to take a backup of a table in sql? SQL BackUp Table example
SQL Backup Table SQL Backup Table  .... Understand with Example The Tutorial illustrate a example from SQL Backup Table... 'stu_table_backup' and copies the exact data of table 'stu_table
MySQL take backup of a table - example code needed MySQL take backup of a table - example code needed How to take backup of a table in MySQL? I have a database which contains many tables. What is the command to take the backup of one table with data from database? Thanks
SQL Backup Table SQL Backup Table  .... Understand with Example The Tutorial illustrate a example from SQL Backup Table... The Backup Query create a exact back up copy of table 'stu_table'. The create
SQL Backup Script SQL Backup Script The Tutorial illustrate an example from 'SQL Backup Script'. To understand and grasp example we create a command for backup of table
Backup Into txt File , we create a table 'Stu_Table' from which the Backup record is stored..._table' and insert its records as backup into text file 'abc.txt'. The select... Backup Into txt File  
Backup Into txt File , we create a table 'Stu_Table' from which the Backup record is stored... the records from 'stu_table' and insert its records as backup into text...:/abc.txt' from stu_table; Backup successful
Backup File With Separator ' from stu_table; Backup successful... Backup File With Separator Backup File With Separator in SQL is used to indicate line
SQL Backup query with where statement SQL Backup query with where statement SQL Backup query with where statement is used to construct a backup table using where clause. The Where Clause
Backup selected records into txt file is used as backup file, whenever there is loss of records or rows from table... query The Backup Query create a backup copy of records from table 'stu... Backup selected records into txt file  
Backup File With Separator ;\n' from stu_table; Backup successful... Backup File With Separator Backup File With Separator in SQL is used to indicate line
Backup selected records into txt file is used as backup file, whenever there is loss of records or rows from table... create a backup copy of records from table 'stu_table' where stu_class is equal... Backup selected records into txt file  
Mysqldump one table - Taking dump of only one table Use of mysqldump for taking backup of one table In this section you will see the example of mysqldump function which takes the backup of only one table... user requirement. You can specify the name of table be backup in while executing
cold backup, hot backup, warm backup recovery cold backup, hot backup, warm backup recovery What is cold backup, hot backup, warm backup recovery
Table Maintenance Statements , BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE, RESTORE... by default to the replication slave. BACKUP TABLE Syntax The general syntax of BACKUP TABLE statement is : BACKUP TABLE tbl_name [, tbl_name
Database backup Database backup I am developing c# application in which i am using Microsoft Access database (OLEdb connections). I want to take backup of database programaticaly. Or as i can tae it in sqlserver 2008 r2(.bak) file. How can i
database backup and restore database backup and restore hi i m able to take backup through java code but i m unable to restore the same file through the restore code . please provide me some suggestion
oracle data backup oracle data backup how to take oracle tables data backup and use in another system
php backup database script - PHP php backup database script please post the backup database script in PHP. Thank u very much
Copy .mdb file for backup. Copy .mdb file for backup. hi.. i am new to java... in my application , at one place for taking back up i have to copy .mdb file from one place to another ... please can anyone help me, how can i do that ....and also if possible
java program to take backup for the folders java program to take backup for the folders java program to take backup for the folders Have a look at the following link: Java Copy one folder to another
Backup MySQL Database - JSP-Servlet Backup MySQL Database Database Sir I have been reading Rose's india tutorial "Using MySQL Database with JSP/Servlet". In the Tutorial you have shown an example of backing up the database. When I tried to backup database
PHP mysql database backup script - PHP PHP mysql database backup script How can i get the database backup using PHP mysql database
database backup and restore using java - JDBC database backup and restore using java Hi... I have MS Access 2000 database.I want to backup and restore the db using jdbc.What's the procedure for that. Thanks in advance
i want to protect mysql database table which user can not view to table and can not copy my table till then us backup of database. if user and programmer want to export and import to table...i want to protect mysql database table which user can not view to table and can not copy my table till then us i want to protect mysql database
TABLE TABLE Why doesn't <TABLE WIDTH="100%"> use the full browser width
Table Table How i generate table in showMessageDialog. I want that i creat a table and run in showMessageDialogeprint("cprint("code sample");ode sample
Table Table How I generate table in showMessageDialog. E.g 3X1=3 3X2=6 3X3=9print("code sample
TestSophara November 30, 2011 at 2:04 PM
Comments
SQL BACKP TABLEShashank Shama December 21, 2011 at 4:11 AM
it should be "create table stu_table_backup as( select * from stu_table); "
wrong queryshankar March 20, 2012 at 3:55 PM
above query is wrong.. use create table stu_table_backup AS ( select * from stu_table);
Data backupAnil November 4, 2012 at 12:09 PM
can we get all the constraints along with the data back up
Post your Comment