| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 06:34:50 GMT
content-type: text/html; charset=utf-8
cf-ray: 964164dd893ae8e0-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=f1f72b45-886c-4de5-b8d0-8945ad8ad0ed; expires=Fri, 24 Jul 2026 06:34:50 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 0372e56e-ac58-4972-9015-912195708d13
x-worker-origin-response-time: 662000000
x-dns-prefetch-control: off
set-cookie: prov=f1f72b45-886c-4de5-b8d0-8945ad8ad0ed; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=1OrOZ6fyvEmoiI0rbO6CTNw1ii4ygrjsWkEGOBiGkhU-1753338890-1.0.1.1-EqVHaFnscLR1WWcF4goICUJjiDQqQqutUBIZKs4h7DdZDdmSdlxqKcoyIvBFretZ9La1vNAL5rRQzEc7Ngyl9GBI0X4.px.ICgEUva40DC8; path=/; expires=Thu, 24-Jul-25 07:04:50 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=V3lbr3TSIoSwmgTR3J6qGtMsL48Rr6k3b3t4wEPNWYw-1753338890538-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'mysql' Questions - Code Review Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [mysql]
MySQL is an open-source, relational database management system. If your PHP code uses MySQLi, use the MySQLi tag instead.
1,089 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
1
answer
44
views
Cmake build system for prototype planner software using boost and other previously written code
I'm prototyping/debugging some C++ code that I may turn into a longtime project. The build system is ready for review, the prototype is not.
The GitHub repository for the code listed below.
Like all ...
6
votes
2
answers
691
views
Weather Observation Station 8 query
Here's my (correct) solution to a HackerRank question:
Weather Observation Station 8
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last ...
3
votes
1
answer
74
views
A function that returns correct number of inserted, updated and skipped rows for INSERT or UPDATE query
When MySQL executes a Data Modification Query, it provides some additional info on the outcome, which is usually displayed in the console. This info is also being exposed through MySQL C API and this ...
5
votes
3
answers
1k
views
Slow SQL query with nested subquery
I have written the below query in order to identify how many events (occur over a week) in each hour.
...
4
votes
2
answers
472
views
Improving upon the Security of my Export Remote Database to Local PHP API
I am working on an in-house application, and I am working on how our application communicates with our remote server.
I have a PHP script that acts as an API to call to our MySQL DB and dump its ...
6
votes
4
answers
2k
views
Program for an employee database using python
In this program I'm defining functions to perform different tasks on a data record book for employees.
Here is a summary of the code:
Intro() to make the presentation of the home page.
create_record()...
0
votes
0
answers
67
views
Connection pool design for Boost MySQL
I had to design a connection pool that handles Boost MySQL connection to use the asynchronous functions.
Here is the code:
...
3
votes
1
answer
136
views
Faster Query to Track State changes in a Large Table
I have a table that tracks state changes of an entity with timestamps. The schema of the table is as follows:
entityid
userid
originalvalue
newvalue
changetime
255
101
Draft
Submitted
2023-11-28 12:10:...
4
votes
1
answer
132
views
Evaluating Extended Operating Hours Past Midnight Across Timezones in PHP
I am working on a project that involves tracking the operating hours of businesses across different timezones. Some of these businesses operate past midnight, and to accommodate this, operating hours ...
2
votes
1
answer
256
views
MySQL interval search query suggestions
My database structure is:
...
8
votes
3
answers
1k
views
A simple PHP login form with PDO
I wrote a simple PHP login form for a website. It has an initialization script, as well as a form to allow a user to login, plus a link to log the user out after logging in.
...
3
votes
1
answer
118
views
Consuming sharded database using node.js
I think the only big improvement that can be made is to check which shard to query based on the userIds of the followed users. One easy way is to check the last ...
user225166
3
votes
1
answer
104
views
SQL query creating tables needed by a simple PHP CMS
I have written recently the SQL query to MariaDB that I want to move into PHP code. Below is my test.sql file. What do you think about my SQL code?
...
- 531
2
votes
1
answer
96
views
delete rows based on references to other tables in a mysql database?
I have a database with the following hierarchy.
A dataset can have multiple scans (foreign key scan.id_dataset -> dataset.id)
A scan can have multiple labels (<...
1
vote
1
answer
123
views
mySQL adjacency list model : Always retrieve parent and children/siblings
I’m using mySQL to create and adjacency list model type of table. I have only one level, that is a parent with children, like this:
...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
php × 579
sql × 311
pdo × 154
performance × 125
python × 82
mysqli × 70
database × 67
object-oriented × 64
security × 64
java × 62
c# × 61
beginner × 59
javascript × 39
html × 35
optimization × 31
python-3.x × 27
sql-injection × 26
authentication × 24
join × 24
node.js × 21
php5 × 19
ajax × 17
json × 17
datetime × 15
laravel × 15
more related tags
Hot Network Questions
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?
- Why are Jewish people named Anat?
- What was the source of the image of pelican in Catholic churches?
- Is the surface of Mars or the Moon mostly (or relatively) homogeneous, unlike the Earth?
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- What is that "T" in the pattern string of the date-command?
- Why is this endgame winning for Black?
- Processing All Files [0-9]*tex
- Is it legal for businesses to give financial incentives for leaving positive reviews on review sites (e.g., Google Maps, Yelp, Facebook, Amazon)?
- OId Movie about an alien city that plays a repeating melody
- Harthshorne II 5.8
- Legolas Master Archer removed with 2nd triggered ability on stack
- Why “brew search” for “peertube” machtes with “freetube”? How does the search work?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- Huge Difference in Interaction P-values Between Linear vs. Ordinal Regression (0.991 vs. 0.001)
- How to move points in geometry nodes like a venetian blind?
- How can I delete a stubborn file on Windows Server?
- A word that describes some people
- How do mechanical gyros maintain rotational speed?
- A complex polynomial inequality
- Why is the Schrödinger wave equation totally different from the classical wave equation?
- Etymology of the word skulduggery?
- Expected Sum of Remaining Dice After Removing Complete Sets