Recent questions tagged Database

0 votes

782 views

1 answer

database - Alternatives to Entity-Attribute-Value (EAV)?

Our database is designed based on EAV (Entity-Attribute-Value) model. Those who have worked with EAV models ... and instances? Cheers, Mosh See Question&Answers more detail:os...

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

0 votes

691 views

1 answer

database schema - How to get all columns' names for all the tables in MySQL?

Is there a fast way of getting all column names from all tables in MySQL, without having to list all the tables? See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

database - SQLiteOpenHelper onUpgrade() Confusion Android

I am doing my first app with a database and I am having a little trouble understanding the onUpgrade function ... standard as possible. Thanks See Question&Answers more detail:os...

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

0 votes

591 views

1 answer

database - Elastic search, multiple indexes vs one index and types for different data sets?

I have an application developed using the MVC pattern and I would like to index now multiple models of it, ... sample data for that purpose. See Question&Answers more detail:os...

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

0 votes

587 views

1 answer

database - SQL query that gives distinct results that match multiple columns

Sorry, I couldn't provide a better title for my problem as I am quite new to SQL. I am looking for a SQL ... best way to do that? Regards, Kai See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

database - Multivalued Fields a Good Idea?

I have recently been introduced to the new Access 2007 feature which is multivalued fields. My initial impression is ... t make me feel dirty? See Question&Answers more detail:os...

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

0 votes

711 views

1 answer

database - MySQL foreign key to allow NULL?

I'm piecing together an image website. The basic schema's pretty simple MySQL, but I'm having some trouble trying ... bonus points, I will :) See Question&Answers more detail:os...

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

0 votes

628 views

1 answer

database design - Should I have a dedicated primary key field?

I'm designing a small SQL database to be used by a web application. Let's say a particular table has a Name ... would it be a waste of time? See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

database - retrieve data from db and display it in table in php .. see this code whats wrong with it?

$db = mysql_connect("localhost", "root", ""); $er = mysql_select_db("ram"); $query = "insert into names values('$name',' ... </td> </tr>"; } ?> See Question&Answers more detail:os...

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

0 votes

610 views

1 answer

database - MySQL concatenating all columns

Why can we not concatenate in MySQL using the * keyword? SELECT concat(*) FROM table or SELECT group_concat ... using the columns name? See Question&Answers more detail:os...

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

0 votes

669 views

1 answer

database - Saving images: files or blobs?

When you save your images (supose you have lots of them) do you store then as blobs in your Database, or as files ... Images in DB - Yea or Nay? See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

database - Why doesn't MySQL's MyISAM engine support Foreign keys?

I am writing a web-app for my studies which includes fulltext search and foreign keys. I have read somewhere, ... search but InnoDB does not? See Question&Answers more detail:os...

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

0 votes

671 views

1 answer

database - In a StackOverflow clone, what relationship should a Comments table have to Questions and Answers?

In an application similar to StackOverflow that I am building, I am trying to decide what relationship my ... "updated_at" datetime ); See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

database - sql 2005 - The column was specified multiple times

I am getting the following error when trying to run this query in sql 2005: SELECT tb.* FROM ( SELECT * ... in advance for your advise. Eneo. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - How to get item count from DynamoDB?

I want to know item count with DynamoDB querying. I can querying for DynamoDB, but I only want to know 'total ... the query size. I need help. See Question&Answers more detail:os...

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

0 votes

603 views

1 answer

database - How to parse the data from Google Alerts?

Firstly, How would you get Google Alerts information into a database other than to parse the text of the email ... pieces of the email message? See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

database - Creating an Update Record Function using Python and SQLite3

I am currently working on a coursework project for school and it is a database system with a user ... Notification","Customer record updated successfully") self.ClearEntries()...

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

0 votes

813 views

1 answer

database - Data modeling : Employees and their skills

I'm building a datawarehouse model about human resources data, and can't decide myself about a fact table which will ... ? Many thanks for your advices ! Take care of yourselves...

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

Categories

Just Browsing Browsing

Most popular tags