sql tag

625 questions

1 answers
84 views
0

I'm using DBeaver, how can I copy the database?

DBeaver is using this and that database.By the way, I want to copy the database that I use by accessing DBeaver from another remote computer.How should I do it?

database postgresql hadoop mysql mssql

2 years ago

1 answers
116 views
0

I want to group based on one column of mysql and join with another table after getting the number.

I made a GROUP based on ID in Table A.SELECT TOP 200 A.ID,COUNT(A.ID) AS CNT FROM A A LEFT join ANAME as Aname on A.ID = Aname.ID LEFT join BNAME as Bname on Aname.SEQ = Bname.SEQ where A.POI_ID > ...

mysql sql querying group-by

2 years ago

1 answers
32 views
0

Mysql's insert query statement type question

sql = insert into tb_q (q_num, title, contents, tag, user, time) values (%s,%s,%s,%s,%s,%s)We've created a query statement like thisThe q_num variable is an integer type, but even if it is %s, is i...

mysql python

2 years ago

0 answers
33 views
0

I would appreciate it if you could tell me what the problem is with the PHP query

It is related to the barcode I asked you below, but it turns out that there is a problem in the php statement, so I am going to solve this first.<?phprequire_once 'connBarcode.php';if(isset($_GET['...

php sql

2 years ago

1 answers
33 views
0

How to use php multiple query select to put into an array

Table barcode(barcode, food_code, company_code)food(food_code, food_name)company(company_code, company_name)It's like this, but it takes too much time to do it using join at first.So, I tried to use s...

php sql

2 years ago

1 answers
155 views
0

When sql select, what should I do if I want to see the general column and the column with the count function applied at the same time?

Table_1 shows the picture belowIt has a number and its corresponding name.And table_2 has numbers.select number, name from table_1Can I check the number and name of table_1 by selecting it as above an...

sql mssql select join count

2 years ago

1 answers
41 views
0

PHP question!(Crying)

I'm trying to build a system for texting...There is a part where you receive PHP API from an existing text company and enter the reception number$_POST['receiver'] = '010xxx,010xxxx,... '; //You can t...

php mysql

2 years ago

1 answers
93 views
0

When the current utc time value is inserted through spark sqlcontext, it is inserted into the current local state, not utc

After purifying the data frame through sql context in spark, Write the code below and attach it to jdbc write.df_2.createOrReplaceTempView(vms_status)q = SELECT srv_name, srv_serial, groups_id, item_i...

python mysql mssql

2 years ago

1 answers
34 views
0

I'm trying to modify the value of the column in mysql column, but it doesn't work

mysql

2 years ago

1 answers
107 views
0

Web Hosting Questions

I'm making my own homepageThe sql that I learn from the state-funded academy is Oracle dbLooking at Cafe24, I thought that only my ql is supported for dbSince I'm using it as a beggar, I can find and ...

mysql oracledb servlet jsp

2 years ago

- 61 -

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