sql tag

625 questions


1 answers
56 views
0
About postgresql :::bpchar に

Hello, let me ask you a question.I am re-pasting the index of a table.table_name_login_idx btree(login) WHERE sex='m':bpcharWhat does this :bpchar mean?Sex is character(1).Please give me guidance.

2 years ago

1 answers
79 views
0
DIFFERENT DATABASE TABLE COUPLING METHOD USING PDO

I don't know how to combine tables of different databases in the same server using PDO class, so I would appreciate it if you could give me some advice.The development language is PHP and the database...

2 years ago

1 answers
44 views
0
Under Update MySQL

If you have the following data:If the parent id is the same and the amount is NULL, you can rewrite it to something that is not NULL.What should I do?I look forward to hearing from you.From this state...

2 years ago

1 answers
49 views
0
To run mysql 5.6 on a Docker centos:centos6 image

I would like to have my new Rails project run on DockerToolbox.The Rails version is 4.0.0.#...set up abbreviated Docker Toolbox...$ git clone path /to /repository.git project$ cd project# Install gem$...

2 years ago

1 answers
54 views
0
a method of calculating the power of a scale

What I want to do in the end is I want to make a table of normal distribution cumulative functionsIn order to do this, Error function must be calculated.There's a factorial calculation in it, but it's...

2 years ago

1 answers
105 views
0
After accessing a URL without a query parameter, I want to automatically skip it to the URL with the query parameter attached.

■ What you want to do (overview): After accessing a URL without a query parameter, I want to automatically skip it to the URL with the query parameter attached.■ What you want to do (details): 1. Curr...

2 years ago

1 answers
46 views
0
The destroy of the data with the foreign key is not successful, and even if you add the dependent option, you will get an error.

When I delete a post model record, I want to delete a comment model record associated with it, but I get the following error.Currently, if there is no comment, it can be deleted normally.If anyone und...

2 years ago

1 answers
53 views
0
Cake is stuck in query setup.(I want to display the latest date of the month.)

Hello, I'm a beginner at cake.I have a question because I am stuck with the query settings.Here's what you want to do:Displays the most recent date of the month.I am writing a custom query as follows:...

2 years ago

1 answers
117 views
0
Unable to Remotely Connect to MySQL

Unable to connect to MySQL remotely.We have two AWS lightsail instances (Ubuntu 14.04.5) and are trying to connect from one to the other.Both versions of MySQL are 5.6.35.The last thing I want to do i...

2 years ago

1 answers
54 views
0
How do I store date data in DB after aggregating it in SQL (with SQL in this part)?

RubyonRails implements the process of aggregating (by time) articles.Currently, I would like to run SQL such as the following, save the aggregated results to DB, and display them on the web screen.SQL...

2 years ago
« - 32 - »

© 2024 OneMinuteCode. All rights reserved.