Questions - QStack.ai

14

views

1

answer

no

votes

2023-06-21 06:58:01 +0000 devzero

What does the error message "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'crm.email' doesn't exist (Connection: mysql, SQL: select count(*) as aggregate from 'email') mean?"

sql
mysql

12

views

1

answer

2

votes

2023-06-21 05:52:02 +0000 scrum

Can you perform a PostgreSQL stored procedure call and fetch query simultaneously?

11

views

1

answer

1

vote

2023-06-21 01:21:02 +0000 nofretete

How can we perform the liquibase migration in less time?

sql

17

views

1

answer

4

votes

2023-06-20 14:26:01 +0000 qstack

In what way can data be transferred from NodeJS to a Python script?

8

views

1

answer

3

votes

2023-06-20 10:31:01 +0000 woof

What does it imply when the record.prepareUpdate is called on ${this.table}#${this.id} but not sent to batch() instantly, indicating an error?

sql

8

views

1

answer

1

vote

2023-06-20 03:14:01 +0000 ladyg

What are the SQL transitions that can be used to retrieve precise values?

sed
sql

7

views

1

answer

2

votes

2023-06-20 00:30:02 +0000 ladyg

What is the process of combining tables in bigquery?

sed
sql

8

views

1

answer

3

votes

2023-06-19 22:22:02 +0000 bukephalos

How do you solve the error message "The connection was not closed. The connection's current state is open" in a c# winform?

11

views

1

answer

3

votes

2023-06-19 15:23:02 +0000 devzero

How can a Quarkus bean be integrated into a Flyway-based Java migration?

9

views

1

answer

3

votes

2023-06-19 14:51:02 +0000 bukephalos

How can I establish a connection with MariaDB that is running in a Docker container through dbeaver?

15

views

1

answer

4

votes

2023-06-19 14:02:01 +0000 ladyg

How can I construct a complex database query in CakePHP that involves associated tables?

php
sql

11

views

1

answer

4

votes

2023-06-19 13:50:02 +0000 qstack

How to create a SQL stored procedure for a string query?

sed
sql

13

views

1

answer

2

votes

2023-06-19 12:27:02 +0000 devzero

How can multiple SQL files be run in a batch in MySQL?

7

views

1

answer

4

votes

2023-06-19 03:37:02 +0000 lakamha

What is the method to retrieve the SUM() of a particular value from a different column in bigquery?

sql

15

views

1

answer

1

vote

2023-06-18 22:15:01 +0000 pufferfish

I am facing an error while using the `read_sql` query in python polars because it is not supporting `BINARY`. However, I have checked that there are no columns in my table which have binary type. How can I solve this issue?

10

views

1

answer

1

vote

2023-06-18 16:21:01 +0000 woof

How can XML tag names be made dynamic for the SQL output?

sql
sed

16

views

1

answer

2

votes

2023-06-18 10:25:01 +0000 scrum

Until the PHP/Laravel client connection is closed, the PostgreSQL server does not free up memory.

12

views

1

answer

2

votes

2023-06-18 05:17:02 +0000 pufferfish

How to break up multiple connections between entities in Prisma and MySQL?

mysql
sql

11

views

1

answer

no

votes

2023-06-18 05:01:02 +0000 woof

What is an alternative way to simulate a database ping that doesn't involve using sqlmock?

sql

12

views

1

answer

3

votes

2023-06-18 02:56:02 +0000 qstack

What does the sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) error message "no such table: cafe" indicate?

8

views

1

answer

1

vote

2023-06-18 00:35:02 +0000 lalupa

Is it possible that the SQLExpress instance is missing or not present?

perl
sql

7

views

1

answer

no

votes

2023-06-17 23:36:01 +0000 devzero

Why is the SQL Query with joins taking a lot of time?

sql

8

views

1

answer

1

vote

2023-06-17 22:47:01 +0000 huitzilopochtli

What steps can I take to use ML on Kafka and Spark Structured Streaming without encountering the Pyspark.sql.utils.AnalysisException error?

sql
sed

13

views

1

answer

4

votes

2023-06-17 19:34:01 +0000 bukephalos

Can Postgres use NativeQuery?

12

views

1

answer

3

votes

2023-06-17 17:20:02 +0000 pufferfish

How can I use React, a Redux Store, and SQL DBs to guarantee that one DB's foreign key matches the other DB's ID?

sql

14

views

1

answer

2

votes

2023-06-17 07:57:02 +0000 devzero

What is the method for dynamically changing the database connection in NestJS Sequelize?

10

views

1

answer

no

votes

2023-06-17 06:32:01 +0000 huitzilopochtli

If I clone an Azure SQL Database and it exceeds the SQL Pool Max Data Size, will it automatically rise?

sql

11

views

1

answer

1

vote

2023-06-16 09:52:02 +0000 pufferfish

How do I retrieve information from an already established database using Flask Sqlalchemy?

sql
python

10

views

1

answer

4

votes

2023-06-16 08:42:02 +0000 devzero

Is it possible to utilize Spring Data Pageables in combination with unprocessed JDBC queries?

sql
sed

8

views

1

answer

1

vote

2023-06-16 06:57:01 +0000 plato

In Superset SQL Labs, Trino displays different rows than those in Spark Parquet Tables.

sql
sed

1122 questions

What does the error message "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'crm.email' doesn't exist (Connection: mysql, SQL: select count(*) as aggregate from 'email') mean?"

Can you perform a PostgreSQL stored procedure call and fetch query simultaneously?

How can we perform the liquibase migration in less time?

In what way can data be transferred from NodeJS to a Python script?

What does it imply when the record.prepareUpdate is called on ${this.table}#${this.id} but not sent to batch() instantly, indicating an error?

What are the SQL transitions that can be used to retrieve precise values?

What is the process of combining tables in bigquery?

How do you solve the error message "The connection was not closed. The connection's current state is open" in a c# winform?

How can a Quarkus bean be integrated into a Flyway-based Java migration?

How can I establish a connection with MariaDB that is running in a Docker container through dbeaver?

How can I construct a complex database query in CakePHP that involves associated tables?

How to create a SQL stored procedure for a string query?

How can multiple SQL files be run in a batch in MySQL?

What is the method to retrieve the SUM() of a particular value from a different column in bigquery?

I am facing an error while using the `read_sql` query in python polars because it is not supporting `BINARY`. However, I have checked that there are no columns in my table which have binary type. How can I solve this issue?

How can XML tag names be made dynamic for the SQL output?

Until the PHP/Laravel client connection is closed, the PostgreSQL server does not free up memory.

How to break up multiple connections between entities in Prisma and MySQL?

What is an alternative way to simulate a database ping that doesn't involve using sqlmock?

What does the sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) error message "no such table: cafe" indicate?

Is it possible that the SQLExpress instance is missing or not present?

Why is the SQL Query with joins taking a lot of time?

What steps can I take to use ML on Kafka and Spark Structured Streaming without encountering the Pyspark.sql.utils.AnalysisException error?

Can Postgres use NativeQuery?

How can I use React, a Redux Store, and SQL DBs to guarantee that one DB's foreign key matches the other DB's ID?

What is the method for dynamically changing the database connection in NestJS Sequelize?

If I clone an Azure SQL Database and it exceeds the SQL Pool Max Data Size, will it automatically rise?

How do I retrieve information from an already established database using Flask Sqlalchemy?

Is it possible to utilize Spring Data Pageables in combination with unprocessed JDBC queries?

In Superset SQL Labs, Trino displays different rows than those in Spark Parquet Tables.

Contributors

Tags