Stack Overflow
Stack Overflow

Questions tagged [table-plus]

TablePlus is a GUI tool for managing relational databases, such as MySQL (as well as some NoSQL databases such as MongoDB). Use this tag for questions regarding the TablePlus tool.

TablePlus is a commercial GUI tool for managing relational databases including, among others, SQLite, MySQL and PostgreSQL as well as some NoSQL databases such as mongoDB and CASSANDRA. It can be used to perform nearly all database management tasks, including manipulating data, migrating databases, managing users and performing backups.

37 questions
0
votes
0 answers

PostgreSQL database should require user password to access, but does not

I created a user with a password for a database and granted SELECT/INSERT/etc. rights for that user on that db. However, when I connect to the database with the particular user, e.g. with TablePlus, the password is not required to connect to it. I…
Maxeezy
  • 39
  • 1
  • 6
0
votes
1 answer

how to create a function or a procedure in tableplus

I am trying to create a simple oracle function in table plus an I always get the following error in "Query 1 ERROR: ORA-24344: success with compilation error" Following is the function I am using to execute. CREATE OR REPLACE EDITIONABLE…
Varma
  • 47
  • 4
0
votes
0 answers

Laravel Forge DB Mysql Connection via Desktop Client Issue

I have an issue with connecting to my databases via desktop client. I use ssh key to connect to my server via console and I am able to connect to my live server. But no luck for my database connection. I use TablePlus as my desktop client and I…
eleven0
  • 263
  • 6
  • 13
0
votes
0 answers

MySQL said: There was a problem with your SQL connection - Access denied for user ''@'%' to database

I am using the wpDataTables plugin on WordPress. I am trying to connect to a MySQL database on my local machine. It asks for server, port, database name, user, and password. No matter what I try, I get one of two errors: wpDataTables could not…
Storm Falcon
  • 1
  • 2
0
votes
0 answers

How to disable one query in Postgres for specified (partioned) table

SELECT COUNT(*) as count FROM "public"."views"; This query executes every time by TablePlus client when I open a partitioned table with many partitions and processed too long time. How I can disable the execution of this query on this table?
Jan aka uptech
  • 1,097
  • 9
  • 12
-1
votes
1 answer

Error when using AUTO_INCREMENT in TablePlus

I was following a tutorial for Laravel and this course required me to use TablePlus. I had to create a table with a given query, but it's not working and I am not completely sure as to why it's not working. Here is the query I am using CREATE TABLE…
jop frenken
  • 50
  • 9
-2
votes
2 answers

Is there a way to get CURRENT_TIMESTAMP to only store date, hours and minutes in a database?

I'm storing data in PostgreSQL with one column set to a default CURRENT_TIMESTAMP. I'm trying to get this default to only store: date, hours and minutes. Does anyone know how I can do it? I need to be able to manipulate the data using Ruby to then…
GabrielG
  • 21
  • 4
1 2
3