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.
282 questions
0
votes
1 answer

What is wrong with my Sybase CREATE TABLE syntax?

What's wrong with my syntax here? I'm adhering strictly to the rules in the Sybase Reference CREATE TABLE dashlogactions ( action_id SMALLINT NOT NULL DEFAULT IDENTITY PRIMARY KEY, action_name VARCHAR(64) NOT NULL UNIQUE ) SQuirrel SQL…
Jeremy Goodell
  • 16,559
  • 4
  • 33
  • 51
0
votes
1 answer

Creating External Table takes long time

I have a table called table B that as 28 million records that is in Netezza and I want to export it to a text file so that I can export the text file to the mysql server. When I run the command below, the SQL client hangs. I am using SquirrelSQL.…
cool_cs
  • 1,451
  • 6
  • 18
  • 24
0
votes
1 answer

Syntax for importing table

What is the syntax for importing an external table into a created table? Whenever I right click on a table in squirrelsql, and click import file, I always get the error message "A database error has occurred. I suspect that Netzilla does not support…
user1408672
-1
votes
2 answers

Informix - Cant find syntax error

This may be a stupid mistake but I'm new to Informix and I can't seem to figure out why none of my CREATE TABLE statements won't run. I keep getting a syntax error on all of my CREATE TABLE statements. CREATE TABLE customer( store_num INTEGER NOT…
ScottyDooZA
  • 45
  • 7
-1
votes
1 answer

MariaDB SQL Syntax error from SquirelL SQL Client

I am using SQuirelL client to connect to MariaDB. My OS is Ubuntu. I have downloaded the Mariadb driver (mariadb-java-client-1.5.2.jar) to the proper location and linked it in the SQuirelL client. I have setup a database, and am able to create…
A. Jose
  • 1
  • 1
-1
votes
1 answer

Squirrel sql client 3.7 on Mac OSX 10.11 and Ubuntu 15.10 has no drivers installed

Here is my problem. I am installing Squirrel SQL Client 3.7 on a Mac and an Ubuntu computers. After executing java -jar squirrel-sql-3.7-MACOSX-install.jar All drivers are marked with and "x" on a red circle. Even when I am specifically requesting…
L.D
  • 1,169
  • 3
  • 13
  • 28
-1
votes
2 answers

Squirrel SQL using old path of Java.exe

My Squirrel SQL doesn't open when I double click the .bat file. (cmd prompt appears and then disappears) I figured, I had just re installed latest Java version and removed older versions this morning. How do I change the path to new Java.exe in…
Shreyas NV
  • 1
  • 1
  • 1
-1
votes
1 answer

Error: Incorrect syntax near the keyword 'RETURN'.SQLState: S0001ErrorCode: 156 when working with Squirrel client

Iam trying to write a PL/SQL function in Squirrel client. when Iam tryin to excute a script in squirrel getting this error. Please help me as Im new to this squirrel client. Script: CREATE FUNCTION totalHoliday RETURN int IS total int:=…
sridhar
  • 11
  • 3
-1
votes
2 answers

To retrieve records having only two specific values

Have the following Data in the table Example Table ID Value 1 a 1 b 1 c 2 a 2 b 2 c 3 a 3 b I need to retrieve records having ID with only two values a and b. So i am expecting only the Record with ID 3 . Can anyone help me with…
user2994034
  • 1
-1
votes
1 answer

Squirrel SQL Error with Oracle Reserved Words

Been scratching my head for a while with what should be a simple Update Statement using the Java Based Squirrel SQL Client, version 3.4.0 (Note: This works fine in TOAD for Oracle, but long term I am expected to use Squirrel. The query is: UPDATE…
DavidBirkin
  • 3
  • 2
-2
votes
1 answer

SQL I have to display the digits 123.34 as 123.3400000000000 ie., 13 digit after the decimal point without loosing any values

Running query from Java code no chance to change the global preferences. I have to print 123.34 as 123.3400000000000 ie. with 13 digits after the decimal point without losing any values CAST(SUM(F.TOTAL_DOCUMENT_CHARS) AS DECIMAL(18,0))/1000 AS…
Kamalakshi M
  • 1
-5
votes
1 answer

I can't identify the database name on DB2 using Squirrel

I want to create a connection from Talend but i coudn't identify the databse name and the schema name , I am using Squierrel client. I changed the database name like on squierrel but I still have the same problem. I think this because the…
HardStacker
  • 1
  • 1
1 2 3
…
18
19