Recent questions tagged Database

0 votes

1.1k views

1 answer

I have the following data: Date Code 2014-08-01 A 2014-08-02 A 2014-08-03 A 2014-08-04 A 2014-08-05 ... this data using SQL. Any ideas? Thanks! See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

database - How to display content of one site in another using PHP?

I'm trying to show contents of two websites in one another , someone suggest me to use RSS reader but my ... didnt work / thanks in advance See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

database - How to insert multiple records into Oracle DB using Node.js

I am able to insert one record into a table, but i want to insert multiple records at once into the table- My Code is ... (null, conn); } }); }; See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database design - Cross table constraints in PostgreSQL

Using PostgreSQL 9.2.4, I have a table users with a 1:many relation to the table user_roles. The users ... they are not dynamically updated. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

database - Convert DB2 SQL Decimal to DATE

I need to convert Decimal to date. I have a decimal date field that contains data like this : 1,132, ... statement? SELECT column1 from table1 ; 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 to add 1 hour to currrent_timestamp in mysql which is the default value?

I have a database with timestamp field which takes current timestamp by default, but I have problem with the ... only in one database. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Do aggregate MySQL functions always return a single row?

I'm sorry if this is really basic, but: I feel at some point I didn't have this issue, and now I ... mistake. Any help is really appreciated. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - is it possible to have alphanumeric sequence generator in sql

I need to write a SQL query to print the following aphanumberic sequence in SQL 0001, 0002, ... , 0009 ... are UPPERCASE. Thanks in advance See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

database - How to represent Oracle Interval in Java

I'm using Java 7 with hibernate 4. Want to use oracle Interval data type (http://psoug.org/definition/ ... types such as oracle.sql.INTERVALS See Question&Answers more detail:os...

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

0 votes

926 views

1 answer

database - PHP - Query single value per iteration or fetch all at start and retrieve from array?

I have a function that looks something like this: //iteration over scales foreach ($surveyScales as $scale) { ... get the value from there? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - One big query vs. many small ones?

I'd like to know, which option is the most expensive in terms of bandwith and overall efficiency. Let's say I ... PHP and MySQL by the way. See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

database - How to solve liquibase waiting for changelog lock problem in several pods in OpenShift cluster?

We are supporting several microservices written in Java using Spring Boot and deployed in OpenShift. Some microservices ... OpenShift at all? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

database - sqlite: how to add total time hh:mm:ss where column datatype is DATETIME?

This is the snapshot of my column in sqlite db and its datatype in schema is defined has DATETIME. Now I want to ... it returns 0.0 as result. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - MYSQL TINYBLOB vs LONGBLOB

This is a follow up for my previous question: Blob and Storage Requirement I did some testing using SHOW TABLE ... other of the BLOB types? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - When does "select for update" lock and unlock?

Here is my Pseudo-code： re = [select **result** from table where **condition**=key for update] if[re satisfies ... not be blocked by this one ? See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

database schema - Break atomicity rule storing list of items when there is no reason to query about items? Verses join table that requires whole join table be scanned

This specific case is regarding lists, and items. The same item may belong to multiple lists, and each list ... rules were written by experts. See Question&Answers more detail:os...

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

0 votes

977 views

1 answer

database - How to read excel sheets in android program

I have a database of 29 excel sheets which i need to use in my code. I converted those ecxel sheets in .xml format ... 0 - 30 Days 0 - 30 Days See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - How to automatically update Google Gauge

I'm kinda rookie in this, but I need help with Google Gauge that should take latest entry in database and display it, ... </div> </body> </html> See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Opening csv-File via ADO-connection - Column Limitation to 255 / or just use another file type?

I have quite a large csv-File (about 800MB) which I need to access from an Excel File via VBA (I am using ... solution to be found on the web. See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

database - How to overcome Netezza's lack of unique constraint/referential integrity enforcement?

It appears that the lack of support for enforcing 2 basic constraints (unique and foreign key), is a ... tool for avoiding these headaches? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database table - MySQL Error 1 (HY000) Trouble creating file Errcode 2

I'm having issues creating a table for my ruby on rails app. It's driving me crazy! The following is returned when ... I'm a total newbie, btw. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - android save object in firebase

I created sign in app and I am using with firebase database. But I have a problem when I am trying to save ... find any solution to my problem. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database - "The ConnectionString property has not been initialized" error in VB.NET

Every time I tried to connect to the database it give me this error "The ConnectionString property has not been ... address") End With End Sub See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Unicode in SQL Server 2012 Express

I am inserting some unicode characters such as Chinese characters using a c# program into a SQL Server 2012 ... ExecuteNonQuery(); Thank you! See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

database - What is a PRIMARY KEY

In database code, I see references to a PRIMARY KEY. What is a PRIMARY KEY? and what difference does it make if ... don't form a PRIMARY KEY. See Question&Answers more detail:os...

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

0 votes

913 views

1 answer

database - mySQL - Table locking vs Row locking

Application Description I have a table which stores id's which represent area's on a map. Each map ... full of useless unoccupied areas. See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

database - How to raise an Exception inside a Trigger? Is there a way to do this?

There's a situation like: If the Salary column in updated with a value lesser than it's original value, print ... any other way to achieve this? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Rollback Multiple SQL update queries in MS Access

I have multiple SQL stored procedures (e.g. UPDATE, SELECT INTO statements) executed in VBA in MS Access: CurrentDb. ... . How can this be done? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags