Friday, 22 April 2016

How to take backup of a database table ?


You can create a backup of table with data using as clause, Like :
CREATE TABLE user_bkp AS
  SELECT * FROM user;

No comments:

Post a Comment

Note: only a member of this blog may post a comment.