sql tag

625 questions

1 answers
110 views
0

Can you set the id that you have registered in the two tables to each other's columns in one SQL session?

There are two tables.One is an item table and the other is a parts table.There is a type of entry on the item screen where item data is registered. Only when type is abcde is registered in the part ta...

mysql sql

2 years ago

2 answers
150 views
0

About MySQL AUTO INCREMENT

I set auto increment for mysql from phpmyadmin.id is Data Type: INT, Length/Value: 11, Adjust privileges: Checked, A_I: Checkedappears.I think this error means that the id is set to 11 digits, but it'...

mysql phpmyadmin

2 years ago

1 answers
143 views
0

Unable to register with mysql if selinux is enforcing (symfony3)

Thank you for your help.I am practicing the code in a Symfony introduction, but if I set selinux to enforcing, I will not be able to register a record in mysql, so could you help me?The error message ...

mysql symfony2 mariadb doctrine2 selinux

2 years ago

1 answers
64 views
0

MySQL Command Sum of Products Between Different Columns in Equal Columns

|A|B|C |1|1|100 |1|1|200 |2|1|300 |2|4|50 |2|1|100 |3|1|500Suppose you have columns A, B, and C in a table with MySQL, and the values are similar to those above.I'd like to extract the product of B an...

mysql sql

2 years ago

1 answers
123 views
0

I want to display json data on monaca

As stated in the title, I would like to display the json data on monaca.In MANP environment, I was able to successfully reflect MySQL data in html by json_encoding with php.When I tried it exactly as ...

php monaca mysql json

2 years ago

2 answers
59 views
0

View links after browsing information between tables in mysql

I make a membership bulletin board with php+mysqlEach user will see a post, but I would like to make it impossible to edit a post or delete a post except for my own post. (*Do not display links to edi...

php mysql

2 years ago

1 answers
78 views
0

I want to import tsv file into mysql

I would like to insert the data in the tsv file as a record for the table I am currently creating.It takes endless time to hand in one by one by one.The tsv file contains the same number of data as th...

mysql

2 years ago

2 answers
101 views
0

Unable to access the localhost page using PDO.

Thank you for your cooperation.Originally, XAMPP was included, and since then, I have been using PDO.For some reason, I uninstalled XAMPP and added Apache.I would like to use PDO for the database rela...

php mysql apache

2 years ago

1 answers
113 views
0

PDOException Occurs in doctorline:generate:entity

PDOException occurs when I try to create a model with symfony2The Entity shortcut name:QuartetBlogBundle:Post→ Enter results in the following error [Doctorline\DBAL\Exception\ConnectionException] An e...

php mysql symfony2

2 years ago

2 answers
92 views
0

We're going to talk about a little bit of a complex grouping method using arrays.

I would like to create a complete list based on incomplete list information in PostgreSQL. Is there a good way?The following tables are available: CREATE TABLE abscissa( a_id TEXT o_id_list TEXT[]);US...

postgresql

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