Recent questions tagged Database

0 votes

1.2k views

1 answer

database - store strings of arbitrary length in Postgresql

I have a Spring application which uses JPA (Hibernate) initially created with Spring Roo. I need to store Strings ... length in JPA? Thanks. See Question&Answers more detail:os...

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

0 votes

958 views

1 answer

database - How to remove duplicate rows with foreign keys dependencies?

I'm sure this is common place, but Google is not helping. I am trying to write a simple stored ... END; $BODY$ LANGUAGE plpgsql VOLATILE; See Question&Answers more detail:os...

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

0 votes

893 views

1 answer

database - MySQL: Why specify display width without using zerofill

I have recently delved into the exciting world of SQL. I am still trying to wrap my head around the ... ? Am I completely misunderstanding? 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 keep foreign key relations consistent in a "diamond-shaped" system of relationships

Consider this situation: a Car is bought from a Salesperson. A Salesperson works at a Showroom (and at only ... how to enforce the constraint. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Is normalizing a person's name going too far?

You usually normalize a database to avoid data redundancy. It's easy to see in a table full of names that there is ... off the top of my head. See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

database - If conditional in SQL Script for Mysql

In a sql script that does sequential execution, is there a way one can introduce an IF THEN ELSE conditional ... halt execution. Please advise. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Removing all decimals in PHP

get this from my database: 252.587254564 Well i wanna remove the .587254564 and keep the 252, how can i do ... you show me an example? Greetings See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Should a Composite Primary Key be clustered in SQL Server?

Consider this example table (assuming SQL Server 2005): create table product_bill_of_materials ( parent_product_id int ... reads than writes. See Question&Answers more detail:os...

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

0 votes

995 views

1 answer

database - Is it possible to change the datatype of a column in a view?

Usually I run a script like this: ALTER TABLE [TABLE] ALTER COLUMN [Column] NVARCHAR(40); The result is that ... ? Or is that even possible? See Question&Answers more detail:os...

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

0 votes

973 views

1 answer

database design - Look-up vs relationship Microsoft Access

I'm developing a Microsoft Access 2013 based information system. One of the client's demands was to simplify the ... item from the combo box. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

database - Postgresql enum what are the advantages and disadvantages?

Where I work we use a postgres database (8.3 soon to migrate to 8.4). There is a small debate ... readablity) and what are the disadvatages? See Question&Answers more detail:os...

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

0 votes

948 views

1 answer

database - How do you know what a good index is?

When working with tables in Oracle, how do you know when you are setting up a good index versus a bad index? See Question&Answers more detail:os...

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

0 votes

939 views

1 answer

database - Moving Data from SQL Server to Oracle Repeatedly

What are the most reasonable ways to move table data from SQL Server to Oracle (on *nix) on a regular basis? See Question&Answers more detail:os...

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

0 votes

982 views

1 answer

database - Best practice for a mysql data versioning system

I have to store data like articles into a mysql database and if an article is modified, I have to save the old ... tables (like images, etc.)? See Question&Answers more detail:os...

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

0 votes

949 views

1 answer

database - PHP pdo instance as private static property

I'm attempting to design my website based on OOP, but I'm having trouble with how to design the database ... a difference to the response. See Question&Answers more detail:os...

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

0 votes

1.1k 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 - make primary key with 2 fields in Django?

I want to make a primary key from 2 fields in Django. Fields are below - current Time - userId How Can I ... Current Time + userid] Thank you!! See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - Getting PHP to read .doc files on Linux

I'm trying to read a .doc file into a database so that I can index it's contents. Is there an easy way ... I am not interested in .docx files. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database - Delphi ODBC Connection Dialog Component?

I am thinking about adding ODBC database connectivity to an application. The user will at runtime configure and ... connections etc. Cheers Sam 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 webview setDatabasePath deprecated

This method was deprecated in API level 19 Database paths are managed by the implementation and calling this ... managed by the implementation) 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 Rank with ties

I am new to sql and I have never used variables or conditions in mysql, but know that from other programming ... hints or some code snippet. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database - Local DB throws Byte array truncation to a length of 8000 exception

I'm trying to take a snapshot from a Map control as a WritableBitmap, convert it to a byte array and save ... ("LocationImage"); } } } See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Two foreign keys instead of primary

I was wondering, is there any possibility to create a table without a primary key, but with two foreign keys ... The database is oracle. Thanks! See Question&Answers more detail:os...

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

0 votes

929 views

1 answer

database - SQL: Try/Catch doesn't catch an error when attempting to access a table that it can't find

I've created a stored procedure that runs a number of commands to modify data. I only want to commit the ... cases? -Thanks for any help. 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 IN statement

Im using IN to select stuff... WHERE categories IN ("red", "blue", "green") This selects any item in red, ... has to be in all three categories? See Question&Answers more detail:os...

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

0 votes

952 views

1 answer

database - How to improve INSERT performance on a very large MySQL table

I am working on a large MySQL database and I need to improve INSERT performance on a specific table. This one ... ? Thanks to all in advance. 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 IN statement

Im using IN to select stuff... WHERE categories IN ("red", "blue", "green") This selects any item in red, ... has to be in all three categories? See Question&Answers more detail:os...

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

0 votes

980 views

1 answer

database - How to improve INSERT performance on a very large MySQL table

I am working on a large MySQL database and I need to improve INSERT performance on a specific table. This one ... ? Thanks to all in advance. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags