Recent questions tagged database

0 votes

1.0k views

1 answer

database - How to add sequence number for each element in a group using a SQL query without temp tables

My question is quite similar to the one posted in this link - How to add sequence number for groups in a SQL ... done in Oracle SQL. Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

database polling using Java

I am stuck at some point wherein I need to get database changes in a Java code. Request is to get any ... has been added/deleted or updated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

database - Row numbers for a query in informix

I am using informix database, I want a query which you could also generate a row number along with the query ... is generated in a query. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

816 views

1 answer

database - Native primary key or auto generated one?

As a rule is it better to use native primary keys (ie existing columns or combination of columns) or ... and/or application dependent? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

database - How to recover data from a deleted Docker container? How to reconnect it to the data?

Let's say, I delete a PostgreSQL docker container which had its data only here: $ docker inspect postgres1 . ... of restoring the whole system)? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

972 views

1 answer

database - List of PHP native_type's for PDO getColumnMeta()

I am using the PDO Database Abstraction library to make sure my code is portable. However, I now find ... comes to switching around databases. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

954 views

1 answer

database - SQL not a single group group function error

I am having a hard time getting my oracle developer query to output correctly. When I have the avg ... LGBRAND.BRAND_ID ORDER BY BRAND_NAME; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

901 views

1 answer

database - Are long-living transactions acceptable?

I am thinking about using transactions in 2-tier WPF (or windows forms) applications in following way: We can ... and disadvantages of this one. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

database - Pre- and Post-migration scripts for Flyway

I am looking for a way to execute a hook script before and after migration. I have a bunch of views and ... . Is this possible in Flyway? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

database - Doctrine Query Builder not working with UPDATE and INNER JOIN

In my repository I have this query: $qb = $this->getEntityManager()->createQueryBuilder(); $qb ->update(' ... using join in query update? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

910 views

1 answer

database - Oracle: LONG or CLOB?

From these two threads, Why is LONG an issue with Oracle? Is it possible to read a CLOB from a remote ... a better solution than these two? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

805 views

1 answer

database normalization - DB Design: 1st Normal Form and Repeating Groups

To adhere to 1st normal form, one of the things you must avoid is repeating groups. As in instead of: ... have different meanings in Design 5. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

database design - MySQL table with a varchar column as foreign key

I am trying to create a table with a varchar column as foreign key but MySql gives me an error while creating ... rewrite my query to fix it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

945 views

1 answer

database - Upload image directly through mySQL Command Line

I have a certain table in mySQL which has a field called "image" with a datatype of "BLOB". I was wondering ... should I place my image files? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

937 views

1 answer

database - How many fields is 'too many' in a table?

I have a coworker who is planning a database for a new app that will have several tables with over 30 fields ... better way of doing this?? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

database - DB2 can't connect to the server

I am tring to set up a db2 server on a Windows 7 machine and I cant connect to database from remote, only from ... to fix it. Thank you for help See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

879 views

1 answer

database - Hosting an Access DB

So I'm inexperienced in hosting DB's and I've always had the luxury of someone else getting the db ... restrictions. Thanks for the responses. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

790 views

1 answer

database - Options for cloud based MS Access backend

Our company has used Access for its database needs. It wants to stick with the current database frontend, but ... cloud based backend. Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

database - $unset on multiple fields in mongodb

Suppose I have a collection in mongoDB like given below - { name : "Abhishek", Roll_no : null, hobby : ... a single command. Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

958 views

1 answer

database - Is there a way to make this SQL more efficient?

Consider the following tables: department deptid (type:INT) deptname (type: TEXT) hours (type:INT) active (type: ... would you improve on this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

960 views

1 answer

database - Specify and use multiple libraries in ODBC connection string

My odbc connection string for connecting to DB2i looks like this: Driver={Client Access ODBC Driver (32-bit) ... workaround for this situation. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

database - How can I change the temp folder where sqlite creates etilqs files?

(This question is a spin-off of How to avoid httpd.exe from creating etilqs in CWINDOWSTEMP?) I have Apache ... one to avoid the warnings. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

905 views

1 answer

database - java jdbc accessing multiple resultsets

I have the following structure: List -->List_Participant -->Participant so a list may contain several participants.I ... have the same name? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

database - How can I change the temp folder where sqlite creates etilqs files?

(This question is a spin-off of How to avoid httpd.exe from creating etilqs in CWINDOWSTEMP?) I have Apache ... one to avoid the warnings. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

database - Postgres COUNT number of column values with INNER JOIN

I am creating a report in Postgres 9.3. This is my SQL Fiddle. Basically I have two tables, responses and ... 07-17' GROUP BY a.question_id; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

903 views

1 answer

database - Prepending an * (asterisk) to a Fulltext Search in MySQL

I understand that the asterisk is a wildcard that can be appended to the end of fulltext search words, but what ... the size of my database. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

database - How to insert images in blob in mysql table using only sql syntax (without PHP)?

Hi,I am new to SQL and I wanted to store images in the database.I already created a column with blob ... address will be stored in database. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

987 views

1 answer

database - how to prefix a string before sequence generated by postgresql?

This is a sequence CREATE SEQUENCE technician_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ... much new to postgresql. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags