src/hg/lib/jksql.c 1.140

1.140 2010/05/22 02:18:28 braney
add sqlRenameTable
Index: src/hg/lib/jksql.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/jksql.c,v
retrieving revision 1.139
retrieving revision 1.140
diff -b -B -U 4 -r1.139 -r1.140
--- src/hg/lib/jksql.c	18 Mar 2010 01:50:29 -0000	1.139
+++ src/hg/lib/jksql.c	22 May 2010 02:18:28 -0000	1.140
@@ -888,8 +888,16 @@
     monitorPrint(sc, "SQL_TIME", "%0.3fs", ((double)deltaTime)/1000.0);
 return res;
 }
 
+void sqlRenameTable(struct sqlConnection *sc, char *table1, char *table2)
+/* Rename table1 to table2 */
+{
+char query[256];
+safef(query, sizeof(query), "rename table %s to %s", table1, table2);
+sqlUpdate(sc, query);
+}
+
 void sqlDropTable(struct sqlConnection *sc, char *table)
 /* Drop table if it exists. */
 {
 if (sqlTableExists(sc, table))