sql tag

625 questions

1 answers
106 views
0

Error establishing connection to SQL Server

from SSMS to a previously local SQL ServerI was able to access it, but I can no longer access itPlease tell me how to deal with itA network-related or instance-specific error occurred while establishi...

sql sql-server

2 years ago

1 answers
60 views
0

I want to attach the asp.NET MVC localization multilingual switch button

Environment ASP.NETMVC C#HTML CSS jquery 3.3.1 postgres4 https://qiita.com/yuu-eguci/items/40f171dff0f8c2cb4748Based on the above article, I tried to install the multilingual switch button.The ajax in...

javascript c# jquery postgresql asp.net

2 years ago

1 answers
48 views
0

About using MySQL for phpadmin in cakephp

I'm making a simple bulletin board for my school assignment.So I have a question, how can I use the database created by phpadmin in cakephp?The development environment is eclipse.

php mysql cakephp

2 years ago

1 answers
48 views
0

SQLSTATE [3D000]: Invalid catalog name: 1046 No database selected

I'm teaching myself using the text PHP7+MariaDB/MySQL Masterbook.Coding a sample program in text results in a heading error.<?PHP// Keep users, passwords, and hosts secret.Configuring separately.$d...

php mysql

2 years ago

1 answers
90 views
0

How to determine the version of SQLServer that is booting

I am in charge of information systems that operate servers in the company.If anyone has any knowledge of the subject, please let me know.There are 3 versions of SQLServer (2008, 2012, 2014) installed ...

sql windows-server

2 years ago

3 answers
37 views
0

Eliminate redundancy when SQL has similar queries (without WITH)

I have a question about SQL statements.Suppose you have the following table:In response, I would like to submit the stock data of paint only and add the total weight of each color code.The image has t...

sql

2 years ago

2 answers
39 views
0

I want to number the group with a new number when the value of a column in SQL is 1.

If a column has a value of 1, I would like to number the group with a new number.Do you know if it can be implemented using SQL?For example, if there is data like A, I would like to create data like B...

sql

2 years ago

2 answers
50 views
0

I want to categorize and output php arrays with the same id.

Assume that the project and client tables exist in DB, and that the results of the LEFT JOIN merge are sorted in the order of client.id.mysql>SELECT p.id, p.project_name, p.client_id, c.client_name...

php mysql

2 years ago

1 answers
50 views
0

Is it possible that multiple ORDER BYs will affect the contents of the SELECT result?

environment·MySQL 5.7Question·ORDER BY is the order of arrangement, so I thought it would not affect the contents of the SELECT result itself even if I specify more than one order, but is it not?·Not ...

mysql

2 years ago

3 answers
42 views
0

I want the latest list for each specified column (SQL, SELECT statement)

Please tell me the SQL statement.How do I write a SELECT statement to get the latest bill list for each user_id?mysql>descbills;+---------------------+--------------+------+-----+---------+--------...

mysql sql

2 years ago

- 27 -

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