Search found 3 matches
- 27 May 2011 2:39
- Forum: Scripts
- Topic: Delete a table from command line
- Replies: 13
- Views: 33823
Let's say you need to drop all tables in a mysql database. How do you do that? You could use a gui, but that's not fun. You're a shell jockey so you want a commandline: mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | \ gawk '{print "drop table " $1 ";"}' | mysql -u uname d...
- 27 May 2011 2:36
- Forum: Scripts
- Topic: Create a new table without scheduling table manager
- Replies: 5
- Views: 16303
Use this procedure to create a schedule table tool and add it to a tool palette. You may want to create your own schedule table tools if you are placing multiple schedule tables of specific styles that have the same properties. Open the tool palette on which you want to create a tool. Create the too...
- 27 May 2011 2:29
- Forum: SQL Scripts
- Topic: Problem in sql script?
- Replies: 1
- Views: 7372