mysql tag

409 questions


1 answers
45 views
0
Error creating Rails database and cannot create db:

I am building an environment to develop the rails application, but when db:create, an error occurred and I cannot create a database.I searched for the error statement, but I don't know how to solve it...

2 years ago

1 answers
40 views
0
Understanding MySQL Text Field Limits

Mysql2::Error:Data too long for column 'hoge' at row1I'm in trouble because I got this kind of error.hoge is text type, so I thought there was no limit...By the way, the data that failed this time was...

2 years ago

1 answers
53 views
0
DB connection via cakephp localhost

Now, I would like to read the data I put in mysql with cakephp in localhost.If the controller is not found for some reason, an error will appear and we cannot proceed. File Name: UsersControllerBy the...

2 years ago

1 answers
43 views
0
Replacing NOT EXISTS in MySQL, trial and error using acceleration method

After several days of trial and error, As I can't solve this problem, I thought it might be rude to ask questions here because I'm a beginner and the content is rudimentary.I would appreciate it if yo...

2 years ago

2 answers
44 views
0
MySQL nested set model, how to output parent from child perspective

The MySQL nested set model is used to print parent from child but it doesn't workBelow is the table containing the category.Table containing the Below is a query that prints the parent from the child'...

2 years ago

1 answers
47 views
0
US>To upload the results of a MySQL-created stored procedure to an existing table

The already created stored procedure, ranking_long, is a newly created stored procedure that only calls it, and by describing it as CALL ranking_long() within its definition:product_id plg_countrank11...

2 years ago

1 answers
73 views
0
About MySQL API Run Errors

When I run the source code below in Dev C++, I get the following error:How do I resolve this error message?2711 C:\Users\patch\Documents\main.cpp [Error] cannot convert 'char**(MYSQL_RES*) {aka char**...

2 years ago

1 answers
133 views
0
garbled characters in PHP+MySQL are not fixed

BackgroundWe have decided to transfer the original system from one server to another.Exportmysqldump-u root-p DBNAME --default-character-set=binary>~/DBNAME.sql importI imported it using phpMyAdmin...


1 answers
41 views
0
mysql Summarize multiple select statements

Would it be possible to combine the following two select statements into one?select name, img, price from items where id=:requestselect item_title from categories where id=:requestPlease let me know i...

2 years ago

1 answers
96 views
0
I want to put multiple unique constraints on a single column in Gorm

I'd like to place multiple unique constraints on a single column in Gorm.typeObject structure{ Z string `gorm: unique_index:unique_a;unique_index:unique_b` A string `gorm: unique_index:unique_a` B str...

2 years ago
« - 21 - »

© 2024 OneMinuteCode. All rights reserved.