sql tag

625 questions

2 answers
73 views
0

What is the difference between the psql and sql commands?

It's a beginner who started studying databases.I'm very sorry for the sudden question, but are the psql and sql commands the same? Or is it something else?I used this site as a reference.PostgreSQL Co...

linux sql postgresql

1 years ago

1 answers
107 views
0

How to manage associated data in combination

Suppose you have a table with about 30 columns, and you have a huge number of records every day.We initially fix 30 columns, but we may increase them to 35.AAA,BBB,FFFAAA, CCC, DDDBBB, CCC, EEE If you...

sql database

1 years ago

3 answers
35 views
0

MySQL cannot condition the case statement column with where

I have a question about case and where in MySQL.The following tables are available: project_id | item_id | value----------+-------+-----1 |67 |51 |68 |52 |67 |62 |68 |6I'm having trouble with ...

sql

1 years ago

1 answers
51 views
0

About mysql subqueries | I want to use multiple tables to extract records that match mysql criteria

I'm studying subqueries.■What you want to doI want to extract the names of employees who achieved above average sales.■What I don't understand (what I'm hesitating about)// Calculation of sales averag...

php mysql

1 years ago

1 answers
150 views
0

Configuring the EC2 Rails+unicorn Launch Script

Configuring Amazon Linux+unicorn+nginx+posgtresql (RDS) environment for Rails app production.When writing unicorn startup scripts, I tried various information, but the startup failed.Environmentruby 2...

ruby-on-rails nginx postgresql unicorn

1 years ago

1 answers
48 views
0

About session

We are currently creating a simple voting system with dot installation.http://dotinstall.com/lessons/poll_php_v2/9710Maybe because the if statement below doesn't work well, Even if you vote normally, ...

php mysql

1 years ago

1 answers
88 views
0

MySQL for RDS in AWS

I recently made my debut with Amazon web service RDS.So I tried MySQL, but I couldn't insert it into a table with a foreign key because it was a constraint violation.I changed the version, but it didn...

mysql sql aws

1 years ago

2 answers
84 views
0

Server Stops at pg_dump

I am currently using apache 2.2, postgresql 8.3.3, and PHP 5.3.The symptoms are as described in the heading, but the following actions are listed:·Pg_dump has been issued to back up the database in or...

php apache postgresql

1 years ago

1 answers
60 views
0

How to Compare MySQL|date Types

From the form submission of html, we try to compare the value of type = date with the column of type date in SQL, but we cannot extract it.The source code is as follows:Is there something wrong with t...

php html mysql sql

1 years ago

2 answers
59 views
0

a method of processing something after a specific time

Thank you for your help.I'm sorry that I haven't spent much time since the last question.When creating simulation games with PHP+Mysql (same as last time), This time, it's like when you attack the oth...

php mysql sql

1 years ago

- 11 -

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