Skip to main content
Share Your Experience: Take the 2024 Developer Survey
peterm's user avatar
peterm's user avatar
peterm's user avatar
peterm
  • Member for 11 years, 3 months
  • Last seen more than 2 years ago
13 votes
Accepted

Why does MySQL allow HAVING to use SELECT aliases?

7 votes
Accepted

How to transpose/convert rows as columns in mysql

4 votes

How to get missing values in row order?

3 votes

How to select only first column dynamically on mysql

3 votes
Accepted

Order by and then Concat

3 votes

Return row in given date

2 votes
Accepted

Failing to get multiple values using join

2 votes

Column to Row and Vice Versa

2 votes

mysql trigger to insert/update date column from datetime column

2 votes

How can I set columns for an entire table in one UPDATE based on the SUM of a join table column?

2 votes

MySQL concurrent INSERTs

2 votes
Accepted

How to update a table by count from another table?

2 votes

Get time format in PostgreSQL

2 votes
Accepted

How to use GROUP BY after the Having clause Mysql

2 votes

Dynamic SQL is not allowed error for creating function in MySQL

2 votes

Pick one single row each time from either table?

1 vote
Accepted

Mysql - Load data infile query for Particular Values

1 vote
Accepted

HOW to Show Exam Wise Marks by transposing Columns as Rows in Mysql Report

1 vote

Recover Wrong encoded string values in MySQL database

1 vote
Accepted

how to make a particular field into seperate columns?

1 vote

Do SQL Server or MYSQL contain JSON supporting functions?

1 vote

prepare stmt is not working

1 vote

How write mysql query corresponding this tables

1 vote

importing database backup to phpmyadmin return #1064

1 vote
Accepted

Retrieve column info from next column

1 vote

Store equations/formula in mysql db table

1 vote
Accepted

INSERT / UPDATE to merge data, when empty data is an empty string

1 vote

Split values from field and count them according to another field

1 vote

How to update cust_id from Customer table to order table Cust_id field while inserting customer name using trigger

1 vote
Accepted

increment row value does not work properly with where condition