Recent questions tagged database

0 votes

1.3k 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

813 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.3k 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

820 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

835 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

946 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

1.0k 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

737 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

733 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

834 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

799 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

826 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

725 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

825 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

800 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

909 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

737 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

823 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

760 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

811 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

766 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.2k 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

849 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

866 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

977 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

809 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

988 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