Recent questions tagged database

0 votes

1.2k views

1 answer

database - MySQL: ignore errors when importing?

I am importing a fairly large database. The .sql file has almost 1,000,000 lines in it. Problem is ... errors when importing a MySQL database? See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

database - Securly Storing OpenID identifiers and OAuth tokens

I am creating a web app that will use OpenID logins and OAuth tokens with Youtube. I am currently storing the ... access to a user's account? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

database - How to solve SQL Server Error 1222 i.e Unlock a SQL Server table

I am working in a database where I load data in a raw table by a data loader. But today the data loader ... My SQL Server version is 2008 R2. See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

database - Is there a way to set an "expiry" time, after which a data entry is automatically deleted in PostgreSQL?

Is there any way to set some sort of "expiry" time on data entries in PostgreSQL? I'm thinking about ... such feature for future releases. See Question&Answers more detail:os...

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

0 votes

775 views

1 answer

database - What is faceted search?

What exactly is faceted search in the context of full-text search? I even read about it from Wikipedia, ... for our application requirement. See Question&Answers more detail:os...

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

0 votes

890 views

1 answer

database - Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?

In multiple courses, books, and jobs, I have seen text fields defined as VARCHAR(255) as kind of the default ... by declaring it VARCHAR(253). See Question&Answers more detail:os...

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

0 votes

983 views

1 answer

database - List all sequences in a Postgres db 8.1 with SQL

I'm converting a db from postgres to mysql. Since i cannot find a tool that does the trick itself, i'm going ... view in the 8.4 release. See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

database - Two phase commit

I believe most of people know what 2PC (two-phase commit protocol) is and how to use it in Java or most of ... 2PC stops working, does not it?) See Question&Answers more detail:os...

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

0 votes

677 views

1 answer

database - How to store 7.3 billion rows of market data (optimized to be read)?

I have a dataset of 1 minute data of 1000 stocks since 1998, that total around (2012-1998)*(365*24*60)*1000 ... RDS so I'm flexible on that See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

database - Build Data Back to ListView Builder [Flutter]

The existing code shows a list of buttons of varying interests. Users can tap to select which interests they prefer. ... it, that will be great! See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

database - ORA-01401: inserted value too large for column CHAR

I'm pretty new to SQL Oracle and my class is going over Bulk Loading at the moment. I pretty much get the ... Thank you for the help in advance See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

database - Deciding whether a relation is 3NF or 2NF

From the Database Management Systems book: given the relation SNLRWH (each letter denotes an attribute) and the following ... of a key. STUCK. See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

database - Mysql ONLY_FULL_GROUP_BY mode issue - Pick single Image URL(any) for each Album

I need help in a mysql query, here are the details: Three Tables, Album_Master , Album_Photo_Map, Photo_Details ... photos in an album. See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

database - How to rollback when an error occurs while executing sql loader command?

If while loading this file $ cat employee.txt 100,Thomas,Sales,5000 200,Jason,Technology,5500 300,Mayla,Technology, ... name, dept, salary ) See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

database - Bound combobox items refers to different field items

I got a bounded combobox to a group name in vb.net. i can view in the drop down items of the combobox ... case... any help would be appreciated See Question&Answers more detail:os...

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

0 votes

839 views

1 answer

database - calculating age in years and months in Microsoft Access (2010)

I have two fields (Date of Physical Exam and Date of Birth). I calculated the age in years((Date of Physical ... using code builder or some way. See Question&Answers more detail:os...

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

0 votes

669 views

1 answer

database - Reflect List Data Back Into UI [Flutter]

In short, users can choose their interests during onboarding, UI changes and the interests are added to a list. When ... .isChosen = false}); } See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

database - Passing column name as parameter in MySQL

Is it possible to do something like this: SELECT template_id as id FROM templates WHERE ? IN ... this with only MySQL? See Question&Answers more detail:os...

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

0 votes

699 views

1 answer

database - When to use one field as primary key instead of 2?

I often see some database design like this: Case 1: UserTable --id[auto increase] --UserName --Password -- ... the best approach in this case? See Question&Answers more detail:os...

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

0 votes

749 views

1 answer

database - How many records / rows / nodes is a lot in Firebase?

I'm creating an app where I will store users under all postalcodes/zipcodes they want to deliver to. The ... your thoughts? Kind regards, Elias See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

database - SQL Server 2016 Express Management Studio cannot design a new or existing table

In Microsoft SQL Server 2016 Express Management Studio (July 2016) cannot design a new or existing table. Image 1 ... Studio (July 2016) Thanks! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - can I access a remote mysql server/db from a stored procedure?

Is it possible to connect to a remote instance of mysql server from a stored procedure using sql statements, ... if possible, though. Thanks! See Question&Answers more detail:os...

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

0 votes

774 views

1 answer

database - Transactions not working for my MySQL DB

I'm using a MySQL DB for my site, which is hosted on a Linux shared server. I wrote a test script which I ... to the DB. Anything I've missed? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

database connection - ImportError: No localization support for language 'eng' in python

I am getting ImportError: No localization support for language 'eng' when using MySQL Connector in Python. My Traceback ... to fix this error? See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

database - .NET TransactionScope class and T-SQL TRAN COMMIT and ROLLBACK

I am current writing an application that will require multiple inserts, updates and deletes for my business entity. I ... my .NET class library? See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

database - ERROR: function addgeometrycolumn is not unique

I am trying to use the following function; SELECT Assign_vertex_id('ways', 0.00001, 'the_geom', 'gid') but for ... how can I fix it? Thanks See Question&Answers more detail:os...

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

0 votes

727 views

1 answer

database - Why use MySQL over flatfiles?

A friend and I were debating about whether he should use MySQL or a flatfile database for his website's ... advantages of MySQL over flatfiles? See Question&Answers more detail:os...

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

0 votes

911 views

1 answer

database - Querying for entities with missing properties in app engine Datastore?

I have a model which looks like this: class Example (db.Model) : row_num = db.IntegerProperty(required=True) updated ... setting the rest to 0. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags