SQuirreL SQL Client使用入门2---插件使用
Completion works on almost all SQL and DDL constructs:
-
Key words, this includes SQL standard keywords as well as those key words delivered by the JDBC driver.
-
Tables
-
Columns
-
Views
-
Stored procedures, completion generates the complete JDBC call syntax including templates for parameters.
-
Catalogs
-
Schemas
-
Copy database tables (indexes and primary/foreign keys) between database sessions (The sessions can be betweendifferent databases)
即,可以在同一个数据库或不同数据库中,直接迁移一个或多个数据表!如此,我们就可以省去了不同方言的建表语句,以及数据导出成txt,再导入到另外数据库的繁琐操作。
tips:有大量数据的数据表移动没有试过。同时,需要对迁移结果表进行正确性检查,看表的字段类型,以及是否有乱码。
There are two new menu items available by right-clicking on certain database objects in the object tree. They are "Copy Table" and "Paste Table". They are accessed as follows:
-
Open two session windows (same or different database types)
-
Select a schema/user in the object tree of one session and click on TABLE to expose the tables in that schema.
-
Select one or more tables in that object tree.
-
Right-click on the hightlighted tables and choose “Copy Table”.
- Bring the other session window into focus and select a schema/user to copy the table(s) into.
- Right-click on the selection and choose “Paste Table”
-
A Progress dialog will be displayed with two bars. The top bar indicates which records
are being copied from the current table. The bottom bar indicates which table is being copied and the overall progress of the copy operation.
SELECT * FROM citys where CITY_ID = ‘860001‘;
SELECT * FROM citys where CITY_ID = ‘860002‘; SELECT * FROM citys where CITY_ID = ‘860003‘; SELECT * FROM citys where CITY_ID = ‘860004‘; |
SELECT * FROM citys where CITY_ID = :cityId;
|
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。