database tag

146 questions

2 answers
105 views
0

Is there a grammar like FOR sentence in MSSQL?

If there are 10 pieces of data, we will take out data from 1st to 10th, compare it with data from other tables, and then process INSERT or UPDATE. I wonder if there is a grammar that can be compared b...

mssql sql database

2 years ago

1 answers
97 views
0

Spring Security Oracle sql Question (incompatible column index)

List<String> type =getJdbcTemplate().query( SQL , new String[] {id, id}, new RowMapper<String>() {SELECT USER_TYPEFROM ( SELECT 'user' as USER_TYPE FROM TABLE_USER WHERE USER_ID=? UNI...

oracle java database spring-security

2 years ago

1 answers
41 views
0

I want to know the difference between SELECT 1 and 0

Usually when checking the low count of a table I use SELECT 1, 0 (FROM DUAL) a lot, but is there a difference between 0 and 1?I don't think there's much difference in speed, but I'm just curious if it...

database

2 years ago

1 answers
147 views
0

ORM: Sequelize: I want to change mySQL query to Sequelize.js query.

A query is a self-joined sentence with one table as follows:SELECT cat.cat_id, cat.cat_name, sub_cat.cat_id, sub_cat.cat_nameFROM Categories AS catLEFT JOIN Categories AS sub_catON sub_cat.parent = ca...

orm sequelize.js mysql sql database

2 years ago

1 answers
69 views
0

About the native language that manages the DB from the source at the backend

I've heard this recently.For example, if you write a backend with PHP,Scratch data from linked DB, save, modify, etc. The part that manages the dataI heard that you squeeze it in with Python code.Even...

back-end database native

2 years ago

1 answers
42 views
0

I'm trying to make a table in the DB...

Company (Company Name (PK), Address, Representative, Product) Innovative companies (name of company (PK,FK), selection year, reason for selection) Excellent company (Company Name (PK,FK), Selection Y...

database

2 years ago

1 answers
67 views
0

I think the table keeps being regenerated while making the login form using sqlite.(I'm a total beginner)

sqlite database android

2 years ago

1 answers
54 views
0

I'm practicing Android db, and I'd like to take out the last data from the data list separately and show it in the form of a list view.

Help me Developers!

android java sqlite database

2 years ago

2 answers
40 views
0

I have a database design question.

I have a question about configuring the databaseex)Product Tablecode/name/specification/price---------------------------------a0001 / a / a-101 / 10000......For example, how can we organize these tabl...

database sql

2 years ago

1 answers
51 views
0

Is it the number in parentheses when creating a table in the sql door? What's the point?

It's been a month and a half since I learned Java. Please check. Have a nice day.

sql database

2 years ago

- 10 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656