Recent questions tagged Database

0 votes

893 views

1 answer

database - MYSQL join comma separated query

I have searched around and came up with nothing. I have 2 tables and to not have to query the database for every ... 17 xxx xxx | 18 xxx xxx See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

database - How can I calculate the distance between latitude and longitude along rows of columns in R?

My df looks like this: bid ts latitude longitude 1 827566 1999-10-07 42.40944 -88.17822 2 827566 2013 ... displacement analysis on the data. See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

database - sqlite: multi-column primary key with an auto increment column

I basically want to convert a table from mysql to sqlite with the following scheme: create table items ( id ... just to generate unique ids. See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

database - Best way to store a many-to-many relationship in MySQL?

Let's say I have a simple database with tables 'posts' and 'tags'. Posts can have many tags and tags can ... them. Is there a better way? See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

database - How to reset stop words in MYSQL?

I want to reset stop word list in mysql for FULLTEXT search. I have installed WAMP Server in my system which have ... know ho wto use this ??? See Question&Answers more detail:os...

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

0 votes

684 views

1 answer

database - Query vs. View

I want to know what is the difference between a query and a view in terms of performance. And if a view ... could I do to improve performance? 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 bulk insert a CSV file into SQLite C#

I have seen similar questions (1, 2), but none of them discuss how to insert CSV files into SQLite. ... your help would be greatly appreciated! See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

database - Android Full Text Search

Does Android come with a way to do Full Text Search? I know is it not even possible to search contacts by the ... if there is no API for that. See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

database - How to retrieve non-matching results in mysql

I'm sure this is straight-forward, but how do I write a query in mysql that joins two tables and then returns ... t seem to make alot of sense! See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

database - SQL Injection after removing all single-quotes and dash-characters

Can anyone show an EXAMPLE of a sql statement when SQL Injection occurred even after all "single-quote" and " ... Oracle and countless others.) 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 - MySQL datetime index is not working

Table structure: +-------------+----------+------+-----+---------+---------------- ... MySQL will use the index no matter what date that I put? See Question&Answers more detail:os...

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

0 votes

784 views

1 answer

database - What happens when you hit the SQL Server Express 4GB / 10GB limit?

What kind of error occurs? What do users experience? Can you access the database using tools and what if you get ... under the 4GB / 10GB limit? See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

database - Exchange Data between two apps across PC on LAN

I have a need of implementing two apps that will exchange data with each other. Both apps will be running on ... data between apps across PCs? See Question&Answers more detail:os...

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

0 votes

820 views

1 answer

database - mysql like% query is slow with full-text index

I'm using a simple mysql LIKE query like this: SELECT * FROM myTable WHERE field LIKE 'aaa%' ORDER BY field2 I ... SCORE + 0.5*popularity. How? See Question&Answers more detail:os...

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

0 votes

749 views

1 answer

database design - Execute deferred trigger only once per row in PostgreSQL

I have a deferred AFTER UPDATE trigger on a table, set to fire when a certain column is updated. It's an integer ... id"); RETURN NEW; END;$$; See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

database - Should you make a self-referencing table column a foreign key?

For example to create a hierarchy of categories you use a column 'parent_id', which points to another category ... would the dis/advantages be? See Question&Answers more detail:os...

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

0 votes

799 views

1 answer

database design - PostgreSQL - set a default cell value according to another cell value

If i have a column say column a of any given values, and i want another column column b to have a default ... b default value = 'doctor'. See Question&Answers more detail:os...

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

0 votes

638 views

1 answer

database - Android: Using server-side when working with Parse

Me and my friend are working on an app., and we wish to use Parse.com as our data base from which we ... 'd appriciate any advice, Thank you. See Question&Answers more detail:os...

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

0 votes

799 views

1 answer

database - Good practice to open/close connections in an asp.net application?

I've been working on a web application in ASP.net. My application has several pages and all of them need to ... any better way to do 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 design - PostgreSQL accent + case insensitive search

I'm looking for a way to support with good performances case insensitive + accent insensitive search. Till ... approach for large databases? See Question&Answers more detail:os...

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

0 votes

713 views

1 answer

database - Sqlite on an embedded system

I have a database file that is generated on a PC using Sqlite. This file is then transferred to an ARM7 ... be used to access the database? See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

database - Can I use Entity Framework or Linq To SQL with Windows 8 Metro Style apps?

I'm looking for some kind of ORM that can be used with Metro Style apps. I found lots of posts ... . Thanks for your suggestions, Adrian See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

database - Am I immune to SQL injections if I use stored procedures?

Lets say on MySQL database (if it matters). See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

database - Group by multiple columns in Laravel

How to GROUP BY multiple column in Laravel? I tried this code: $routes = DB::table('route') ->groupBy(' ... ); But this is not working. See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

database - Treat NULL as '0' in Django model

I use the following bit of code in my Django app: pictures = gallery.picture_set.annotate( score=models.Sum( ' ... that the order is correct. See Question&Answers more detail:os...

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

0 votes

984 views

1 answer

database - Determining query's progress (Oracle PL/SQL)

I am a developer on a web app that uses an Oracle database. However, often the UI will trigger database ... until 6 seconds has passed? See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

database - Performance of arbitrary queries with Neo4j

I was reading a paper published by Neo4J (a while ago): http://dist.neo4j.org/neo-technology-introduction ... any empirical data regarding this? See Question&Answers more detail:os...

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

0 votes

987 views

1 answer

database - MySQL error - #1062 - Duplicate entry ' ' for key 2

I'm trying to insert a huge list of users to a MySQL database but everytime I try I get the error: #1062 - ... '[email protected]','',''); See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags