sql tag

625 questions


2 answers
46 views
0
SQLSTATE [HY000] [2002] No such file or directory

I am studying PHP on a local server (PHP 7.0.14) in MacOS 10.12.2.<?phpdefine('DB_DATABASE', 'test_db'); // database specification define('DB_USERNAME', 'dbuser'); // database userdefine('DB_PASSWO...

1 years ago

1 answers
135 views
0
About WildFly+MariaDB

Operating Environment: Windows 7 32-bit, Eclipse 4.7 Oxygen, Java 8, MariaDB 10.3, WildFly12 ·This is my first time using WildFly.So let me ask you a few questions.WI understand that WildFly includes ...

1 years ago

1 answers
126 views
0
How do I connect to localhost, 127.0.0.1 and ::1 respectively in mysql (MariaDB)?

Installing mysql (10.1.30-MariaDB) +------------------------------------------------------------------------------------------------------------------| host | user | password | ssl_type |+-----------+...

1 years ago

1 answers
65 views
0
How to INSERT if there is no key data in SQL and UPDATE the data in the key if there is one.

Thank you for your help.I think it's a question that has been asked many times in the past, but I couldn't find it in the past log, so Let me ask you a question.Learn how to import CSV files into an e...

1 years ago

1 answers
34 views
0
"Plug-in Table Does Not Exist" Error During MySQL Startup

My name is toshimizu, and I am a super beginner in programming.I just asked a similar question and got an answer, but I ran into another error again, so I would like to ask you a question again.Please...

1 years ago

2 answers
128 views
0
execute >> Unicode character always returns null in SQL in Rails Migration

I am currently trying to do the following:Here's the code: class ConvertNameIntoFirstAndLastName<ActiveRecord::Migration def up execute<<- SQL DO $do$ DECLARE record; BEGIN FOR u IN SELECT* ...


1 answers
33 views
0
HANDLING FIXED VALUE ARRAY AS TABLE

For example f(x)=x*x(x=1..10)When I want to make a table of , how can I make a part of 1...10?CREATE TEMPORARY TABLE x( x bigint(20));INSERT x VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);...

1 years ago

4 answers
85 views
0
About Table Design

I'm working on a table design, but I'm having a hard time with my first training, so I'd like some advice.I won't give you any specific information, so it's an example.There is a table like the one ab...

1 years ago

1 answers
81 views
0
"When implementing a search engine, I would like you to digest the results of ""Tokyo"" from the inputs ""Tou,"" ""tok,"" and ""East."""

How can I accomplish the following?I have also discussed my own ideas on how to realize it later, so I would appreciate it if you could refer to them as well.Thank you for your cooperation.Pass a stri...


3 answers
30 views
0
Deadlock in UPDATE statement without transaction in MySQL

We are investigating the cause of the deadlock at the MySQL UPDATE site.Exclusive processing is carried out with optimistic lock, no transaction is used, COMMIT is performed immediately after UPDATE i...

1 years ago
« - 29 - »

© 2024 OneMinuteCode. All rights reserved.