659,206 questions
-3
votes
0
answers
50
views
Displaying results of stored procedure via PHP [closed]
I am building a search box to pull from a database. In this case, I was after results from three different columns that needed to be treated as one column.
After unsuccessfully trying numerous ...
-8
votes
0
answers
59
views
implementing a re-post or re-tweet like feature [closed]
In my dummy social network I am developing for learning the backend strategies ...I am now working on implementing a retweet like feature....user will have option to repost an existing post and write ...
- 131
-1
votes
0
answers
33
views
WSO2 ESB 5.0.0 Supported to mysql 8.4 version or not [closed]
WSO2 ESB 5.0.0, till which version of MYSQL 8.0.x or higher is compatible & supported ?especially for MYSQL 8.4
I want to know the which version of MYSQL db 8.0.X is supported for my WSO 5.0.0 ESB....
-3
votes
0
answers
168
views
Why are these simple MYSQL update statements failing
I have been coding php for years, but today I have encountered a problem I have never seen before. Some very simple update statements are failing -- or rather instead of updating, they are replacing ...
-1
votes
0
answers
19
views
Unexplained MYSQL memory allocation [migrated]
I’m running MySQL server on Linux.
I have a long-standing issue on my database server — it keeps consuming an excessive amount of memory for no clear reason. As a result, I was forced to periodically ...
- 19
-10
votes
0
answers
101
views
How to write prepared statement [closed]
What is the proper syntax to write something like:
SELECT table_id FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE name = '?/?';
in MySQL?
- 6,439
3
votes
1
answer
56
views
Is there an option to run a large query without causing it to pollute the InnoDB cache?
I want to run a bunch of large background queries where I don't want these lower priority queries to fill up the InnoDB cache with rows that will flush out cached rows needed by higher priority ...
- 538
-1
votes
1
answer
61
views
Virtual on-the-fly tables [closed]
Gembase had a feature to create a virtual table, query as many tables as I like, and store results into the virtual table on-the-fly. I could manipulate the virtual table without re-querying the ...
- 19
-2
votes
1
answer
53
views
Reshape arbitrary key/value table from long to wide format using SQL [duplicate]
If I have a table containing an ID field (not unique, but a foreign key to a unique ID in another table) and arbitrary key/value pairs, like this:
id
key
value
1
name
van
1
color
white
2
name
car
2
...
- 610
0
votes
1
answer
101
views
Using `with` to find the instructors with the highest salary
I am learning SQL and was testing the with expression syntax when I ran into this error for my SQL query. I want to get the ids and names of all instructors from a university databse with the maximum ...
- 14.9k
0
votes
1
answer
98
views
Syntax error 1064 with LOAD DATA ... FIELDS OPTIONALLY ENCLOSED BY '"'
My SQL statement in MySQL 5.7.44, Windows 10:
drop table if exists test;
create table test (col1 VARCHAR(64), col2 VARCHAR(80) );
LOAD DATA LOCAL INFILE "t.csv" INTO TABLE test FIELDS ...
- 1,183
0
votes
0
answers
91
views
Return multiple columns with aggregate functions [duplicate]
I am trying to figure out how to return multiple columns that correspond with the desired aggregate functions, max of a sum, in SQL.
Based on data from CDC's Serotypes of concern: Illnesses and ...
- 9
-4
votes
1
answer
84
views
Editing data in one table according to the data status in another table [closed]
I have two tables in my database: wp_posts and wp_postmeta.
wp_postmeta, wp_posts
I want to retrieve the "meta_value" value of a column in wp_postmeta based on the "meta_key" data....
0
votes
3
answers
49
views
MySQL: Problem with extracting first character from text field with Regular Expressions
I'm not able to get the first character of a string with the dot operator – it returns the rest of the string, not the character:
CREATE TABLE test (
name VARCHAR(10)
);
INSERT INTO test (name) ...
- 7,244
0
votes
2
answers
212
views
Why correlated scalar is 10x times slower in MySQL comparing to PG
Let's create a table with 3000 rows
create table tt(id int, txt text);
insert into tt
with recursive r(id) as
(select 1 union all select id + 1 from r where id < 3e3)
select id, concat('name', id)
...
- 653