Recent questions tagged Database

0 votes

727 views

1 answer

database - "Create new table" is not visible on SSMS 2016 for SQL Server 2008

I have a shared hosting. I was happy with it. I was creating new databases on its panel and then I was managing ... ? Is this a security issue ? See Question&Answers more detail:os...

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

0 votes

664 views

1 answer

database design - When not to use surrogate primary keys?

I have several database tables that just contain a single column and very few rows, often just an ID of something ... keys shouldn't be used? See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

database - Is there a performance hit using decimal data types (MySQL / Postgres)

I understand how integer and floating point data types are stored, and I am guessing that the variable length ... and searching against them? See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

database - Storing images in DB vs in Folder Structure

I understand it is possible to store images in Databases as Binary large objects. But I used to see in some ... When to go for which approach? See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

database - Aerospike Design | Request Flow Internals | Resources

Where can I find information about the how flow of the read/write request in the cluster when fired from the ... I can configure it accordingly. See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

database - MySQL Removing duplicate columns on Left Join, 3 tables

I have three tables, each have a foreign key. When I perform a join, I get duplicate columns. Given mysql ... syntax that I should use? See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

database design - SQL: Do you need an auto-incremental primary key for Many-Many tables?

Say you have a Many-Many table between Artists and Fans. When it comes to designing the table, do you design ... ) for using the former schema? See Question&Answers more detail:os...

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

0 votes

783 views

1 answer

database - SQLite If Column Exists

I was wondering if there is a nice IF NOT EXISTS for checking columns and indexes in SQLite, or do I ... schema and validate against that? See Question&Answers more detail:os...

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

0 votes

779 views

1 answer

database - SQL ignore part of WHERE if parameter is null

I have a stored procedure that fetches info from a table based on 4 parameters. I want to get values based ... possible combination (15 IFs)? See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

database - How to mimic Eloquent relationship with comma separated ids

I have two tables, orders and layers. In my orders table i save an array in layer_id which i have set it to ... 'Layer', 'layer_id'); } } See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

database - Are there any functions in MySQL like dense_rank() and row_number() like Oracle?

Are there any functions in MySQL like dense_rank() and row_number() like those provided by Oracle and other DBMS? ... . Is there an alternative? See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

database - MySQL Docker container is not saving data to new image

I'm trying to create a MySQL Docker container that is preset with a certain schema and seed data so that I can have other ... .2 on OS X 10.9.5. See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

database - Can I configure Grails with no datasource?

I have a Grails app that loads its data from xml files and delivers rss feeds via rome. I don't have ... application doesn't need a datasource? See Question&Answers more detail:os...

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

0 votes

726 views

1 answer

database - How do I show unique constraints of a table in MySQL?

I created them, but I forgot which ones they are. I just want to show them. remove all the constraints on a table. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Format date in MySQL SELECT as ISO 8601

I'm trying to grab the date from my database in a standard timestamp and display it as ISO 8601. I'm unable ... %dT%TZ") What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

739 views

1 answer

database - How to find power of a number in SQLite

I want to update the Interest field in my database. My SQL query is like as per below Update Table_Name set ... than 3000 records at a time. See Question&Answers more detail:os...

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

0 votes

785 views

1 answer

database - How to create populated MySQL Docker Image on build time

I would like to create a MySQL Docker image with data already populated. I want to create 3 layers like this: | ... . How can this be done? See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

database - data sources derby - connection refused

I am trying to connect a database with a java project. After reading some tutorials and the course support, I have ... still it doesn't work. See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

database - SQL Query to find missing rows between two related tables

I have two tables: Table A ID ABC_ID VAL Table B ID ABC_ID VAL These two tables are directly related to each ... table B for the same ABC_ID. See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

database - Query points within a given radius in MySQL

I have created the following MySQL table to store latitude/longitude coordinates along with a name for each point ... as efficient as possible. See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

database - How to connect and use Firebird db embedded server with Visual C# 2010

I was trying to use Firebird embedded server with Microsoft Visual C# 2010. so here is what ... 2010ProjectsfbTestAppfbTestAppForm1.cs:line 25 See Question&Answers more detail:os...

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

0 votes

594 views

1 answer

database - What is the benefit of Connection and Statement Pooling?

Can someone explain what is Connection and Statement Pooling and what is the benefit over unpooled DataSources? I am ... . Thank you very much. See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

database - PHP - a DB abstraction layer use static class vs singleton object?

I don't want to create a discussion about singleton better than static or better than global, etc. I read ... specific case. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

database - Changing Table Engine in MySQL

I am using mysql and mysql workbench. I created 5 tables with innodb engine. I checked their engine and it was ... innodb but it doesn't work. See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

database design - Should I always prefer MySQL InnoDB over MyISAM?

Someone just told me that InnoDB is much better than MyISAM. So when I create a table, should I always try to ... both have it's big benefits? See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

database - How do I obfuscate the ids of my records in rails?

I'm trying to figure out how to obfuscate the ids of my records in rails. For example: a typical path might ... the best way of doing this? See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

database - How to use enums in Oracle?

How do you use enums in Oracle using SQL only? (No PSQL) In MySQL you can do: CREATE TABLE sizes ( name ... similar way to do this in Oracle? See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

database - How should I store a GUID in Oracle?

I am coming from the SQL server world where we had uniqueidentifier. Is there an equivalent in oracle? This column ... so I cannot use sequence. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags