Stack Overflow
Stack Overflow

Questions tagged [squirrel-sql]

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Summary

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Website

  • Project Homepage
  • Download squirrel-sql-x.x.x-optional if you want all of the plugins installed.

Features

  • Supports autocomplete when creating queries by pressing CTRL+SPACE.
  • On-the-fly generation of ERD diagrams.

Useful Keyboard Shortcuts

  • CTRL+SPACE - autocomplete database, table, and fields in queries.
  • CTRL+t - SQL Editor Tools Popup
  • CTRL+j - Display Query Bookmarks
    (Note: need to enable with CTRL+t edit bookmarks first.)
  • CTRL+SHIFT+, / CTRL+SHIFT+. - switch to prev/next results tab

Useful Plugins

  • UnityJDBC - A plugin for SQuirreL that allows queries involving multiple kinds of databases, much in the same way that MS-Access allows linked tables.
290 questions
0
votes
0 answers

SQuirrel SQL broken text issue

There is broken text issue in Squirrel SQL. Text looks like this: Á¤¾×± I have added "-Dfile.encoding=UTF-8" in squirrel-sql.bat file, and changed the local setting & font in global preference in SQuirrel SQL but none of them are solving this…
J P
  • 1
0
votes
2 answers

I am trying to use left join using few conditions, i am getting results as inner join instead of left join. Please correct my query in squirrel-sql

I want all records using left join from tab;le 1, Table 2 and Table 3 for April month and also where city = london. I am expecting 2 records in final result and with first record = london and second record null or blank. Table1 …
YZ123
  • 11
  • 2
0
votes
0 answers

Upsert SQL query throwing error with golang and squirrel. SQL error at or near where

sql err: 'pq: syntax error at or near "WHERE"', sql: 'INSERT INTO table (id,user,type) VALUES ($1,$2,$3) ON CONFLICT WHERE id = $4 AND user = $5 DO UPDATE SET type = $6', params: [3 158 up 3 158 up] Using the info on this page, I thought I could…
Gabe Spound
  • 568
  • 5
  • 28
0
votes
1 answer

Outputting PostgreSQL's bit type in SQuirreL results in ""

When I try to output something as a bitstring (PostgreSQL documentation) in SQuirreL... SELECT ('1234'::bigint)::bit(16); I get the following result: bit ------- Can this be avoided?
zb226
  • 9,586
  • 6
  • 49
  • 79
0
votes
1 answer

Squirrel-Sql client fails to connect to MySQL 8 with "Unexpected Error occurred attempting to open an SQL connection"

I have been using Squirrel SQL to query MySQL 5.7 databases from my Windows 10 laptop. We are now starting to upgrade to MySQL 8, but when I try to connect to a MySQL 8 instance I'm getting the error, "Unexpected Error occurred attempting to open an…
mojoken
  • 1,256
  • 1
  • 15
  • 27
0
votes
1 answer

SQuirrel Call Stored Procedure

I am trying to call a DB2 stored procedure from Squirrel. I can call the stored procedure successfully from the DB2 command line processor. CALL PIPPOOWN.PIPPO ('04','prov','0001','provprov') I append ;retrieveMessagesFromServerOnGetMessage=true;…
killer
  • 11
  • 6
0
votes
1 answer

How to get yesterday date starts at 00:00:00 in Vertica SQL

How to get yesterday date starts at 00:00:00 in Vertica SQL? Normally in SQL Server it will be like this SELECT DATEADD(Day, -1, DATEDIFF(Day, 0, GetDate())) 2021-01-31 00:00:00.000 How about in Vertica?
Gene
  • 17
  • 1
  • 8
0
votes
1 answer

Collation change accent sensitive column

Is there any way to make search query accent sensitive in one column of my table? the column's and table's collation are in LATIN1_GENERAL_CS and I don't want to change the table. How to change the values of my column that they are already with…
BARIK FATI
  • 29
  • 9
0
votes
1 answer

why not all tables are displayed in SQuirrel-SQL

Using Oracle DB 10 and SQuirrel 3.7.1 Not all tables are displayed in 'Objects-tab -> schemeName -> table' list. If I write in the SQL tab select * from tableName I get a result, but the table is not displayed on the list above. How can it be fixed…
gilln
  • 1
  • 3
0
votes
2 answers

Query for an exact match for a string in to a column having text fields(more then one strings)

In my data base table i have a field "description" which is a text field. it contains values like it : This bracelet is composed of round diamond surrounded by milgrain detailing. Its secure setting prevents it from twisting and ensures it will sit…
Romi
  • 4,833
  • 28
  • 81
  • 113
0
votes
1 answer

Connect Redshift through Access Keys via SQuirrel SQL

I'm trying to follow this tutorial https://www.cdata.com/kb/tech/awsmanagement-jdbc-squirrel-sql.rst in order to connect to Redshift via SQuirrel SQL. In particular I'm trying to connect via Access Key ID and Secret Access Key. When it comes to the…
Vzzarr
  • 4,600
  • 2
  • 43
  • 80
0
votes
1 answer

Delete using Union

I want to delete the output of my query:- SELECT client_id FROM dt.pref WHERE record_create_date < (SELECT current_timestamo - 45 YEARS FROM sysibm.sysdummy1) UNION SELECT client_id FROM ctt.dom WHERE …
Rio
  • 23
  • 4
0
votes
0 answers

DB query tools not running

I have to make changes to a Struts2 application with DB Oracle XE 11.2 whose last development dates back to a year ago (and also the last access to the machine on which it resides). The connection to the DB from within the app still works perfectly…
M.Marko
  • 21
  • 5
0
votes
0 answers

Apache Derby cannot delete records in database because there is no enough time

I guess that records in the table are too big and there is no time for any SQL. I want to delete records from tables and I cannot do it in any way. What to do? Error: java.sql.SQLTransactionRollbackException: A lock could not be obtained within the…
user1182625
  • 145
  • 2
  • 15
0
votes
1 answer

Java Program to execute Update Query in DB2 shows SqlSyntaxErrorException

I am trying to run a SQL query using a Java method for my Selenium project. The below method executeQuery gets sqlQuery as argument, which I plan to use for INSERT, UPDATE and DELETE. For DELETE the method works fine, but for INSERT and UPDATE…
Sangeetha
  • 31
  • 2
  • 8
1 2 3
…
19 20