sql tag

625 questions


1 answers
49 views
0
Even if I try mysql-u root with mysql, I get an error, so I want to solve it.

What do you want to solveI can't solve the error in mysql, so I want to solve itProblems/errors encountered#1stERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' ...

2 years ago

1 answers
76 views
0
"No module named 'MySQLdb' error when deploying Django apps to the Google App Engine"

https://github.com/priyankavergadia/Django-Dialogflow-GoogleVisionAPII'm trying to move the Django chat bot of ↑ based on the document to which I linked it.The last deployment to Google app engine is ...


1 answers
44 views
0
DELETE for MySQL is not running.

Creating a bulletin board site.I am connecting to MySQL from PHP using PDO, but the DELETE statement does not run.You can INSERT the database with the add.php file, but The delete.php file is not work...

2 years ago

2 answers
45 views
0
Resolved MariaDB fails to start

I installed MariaDB on CentOS 7.1.1503 and tried systemctl start mysql, but I couldn't start it.I used this site as a reference to work. http://love-zawa.hatenablog.com/entry/2014/07/24/CentOS_6_5%E3%...

2 years ago

2 answers
124 views
0
Learn how to manage tables that are growing in the database.

Assume a relational database using MySQL.For example, how do you manage databases like bulletin boards that users post more and more, but cannot erase?Even if I put an index on it, I'm worried that if...


1 answers
41 views
0
I would like to set up conditional branching within MySql.

Thank you for your help.Please give me some advice.Thank you for your cooperation.When you click a table in MySql, each tab is aligned, and when you click the View tab on the leftmost side, the fields...

2 years ago

1 answers
44 views
0
When storing authenticity values in MySQL, is type tinyint(1) better than type bit(1) field?

What do you want to do in the end·I want to store authenticity values in MySQL 5.7What do you want to know·Which do you prefer, boolean, bit(1) or tinyint(1)?About the Q1.boolean literal·It says that ...

2 years ago

1 answers
34 views
0
Retrieve other fields with MAX values recorded

I am using Microsoft SQL Server 2012.For example, suppose you have a table with the following records:The record is one month's worth of data every 10 minutes.(4032 Row)DateTime, Value1, Value22018-02...

sql
2 years ago

2 answers
120 views
0
SQL Injection Protection in PHP

I'd like to take measures against SQL injection into PHP.SELECT* FROM hogehoge WHERE id='$id'AND number='$data'In the place where the SQL statement is assembled, the id contains an integer as an argum...

2 years ago

1 answers
98 views
0
Unable to log in to phpMyAdmin

Unable to log in to phpMyAdmin.It may be because of the MySQL configuration, but please let me know.I downloaded phpMyAdmin 4.4.14.1 and installed it on a web server.http://pocolog.cocolog-nifty.com/m...

2 years ago
« - 39 - »

© 2024 OneMinuteCode. All rights reserved.