Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Directly execute MySQL commands (Read 1946 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Directly execute MySQL commands
07.12.09 at 11:43:47
Directly execute MySQL commands
MySQL commands can be directly executed from SQL*XL using the exec statement.
In the SQL*XL's SQL dialog the exec command can be used to execute a server command. Examples are:
exec show tables;
exec describe [table_name];
exec show databases;
exec show columns from [table_name];
Obviously you should replace [table_name] with the name of your table.
The above was tested in SQL*XL 4.3.20 and with MySQL ODBC version 5.1
Back to top

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1