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))