MySQL Commands Cheat Sheet: The Essential List

This cheat sheet gives you the most essential MySQL commands in one place—covering database and table operations, data manipulation, queries, and user management—so you can work faster without digging through the full manual. Each command includes a short example you can adapt immediately. The list focuses on the commands that appear in nearly every real-world project, from simple SELECTs to joins and indexing.

Formula

The calculator computes average pace and speed using the standard formulas:

• Pace (min/km) = Finish time (min) ÷ Distance (km)
• Speed (km/h) = Distance (km) ÷ (Finish time (min) ÷ 60)

Where Finish time is in minutes, Distance is in kilometers, Pace is in minutes per kilometer, and Speed is in kilometers per hour. The same formulas work for miles if you use miles for distance and keep the time in minutes—pace becomes min/mile and speed becomes mph.

Worked Example

Using the default values from the calculator (finish time = 50 minutes, distance = 10 km):

1. Pace = 50 ÷ 10 = 5.00 min/km
2. Speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333 = 12.00 km/h

The calculator shows an average pace of 5.00 min/km and an average speed of 12.00 km/h.

When to Use This Calculator

Use it to plan training runs, estimate race finish times, or compare your performance across different distances. For example, if you want to run a 10K in under 50 minutes, you need a pace faster than 5:00 per km. If you’re training for a marathon, you can enter your target finish time and the distance to see the required pace—then adjust the distance to see how pace changes for a half marathon or 5K.

How to Read the Results

The first output, pace, is the most useful for runners: it tells you how many minutes (and decimals) you need to run each kilometer or mile. A pace of 5.00 min/km means exactly 5 minutes per kilometer. The speed output converts that to a more familiar “kilometers per hour� number, which is handy when comparing with treadmill settings or cycling speeds. Remember that pace and speed are inversely related: a lower pace (faster) corresponds to a higher speed.

Common Mistakes

• Mixing units: If you enter distance in miles but time in minutes, your pace will be in min/mile—that’s fine, but don’t compare it to a min/km pace without converting. 1 mile = 1.60934 km.
• Using seconds instead of minutes: The calculator expects time in minutes. If you have 1 hour 20 minutes, enter 80, not 1.20. Convert seconds to minutes by dividing by 60 (e.g., 30 seconds = 0.5 minutes).
• Rounding too early: Keep full precision during the calculation; only round the final answer. The calculator does this automatically.
• Assuming pace is always min/km: The unit depends on what you entered for distance. If you use miles, the pace unit is min/mile.

Limitations of the Formula

This is a simple average calculation. It does not account for elevation gain, terrain, weather, or pacing strategy. A hilly course will have a slower actual pace than the average suggests, and even a flat course will have natural variation. For interval training or track workouts, you need per-lap splits, not just the overall average. Also, the formula assumes you finish the entire distance—if you stop or walk, the average pace will be lower (slower) than your running pace.

Frequently Asked Questions

How do I convert pace from min/km to min/mile?

Multiply the pace in min/km by 1.60934 to get min/mile. For example, 5 min/km × 1.60934 = 8.05 min/mile. To convert speed, divide km/h by 1.60934 to get mph.

What is a good running pace for a beginner?

A comfortable conversational pace for a beginner might be 7–9 min/km (11–14 min/mile). This varies greatly with age, fitness, and other factors. The calculator helps you find your current average pace, not what it “should� be.

Can I use this for walking or cycling?

Yes. The math works for any activity where you cover a distance in a certain time. For cycling, you might prefer speed over pace, but both outputs are provided.

How do I calculate pace for a half marathon?

Enter the half marathon distance (21.0975 km or 13.1094 miles) and your target finish time in minutes. The calculator will give you the required average pace and speed.

Why does the speed output show 12.00 km/h for a 50-minute 10K?

Because 10 km divided by (50/60) hours equals 10 divided by 0.8333, which is 12.0 km/h. This is the average speed, not the peak speed.

Related

• Best Moto E4 Screen Protectors: Top Picks
• Best ThinkPad X1 Carbon Gen 14 Alternatives for Business Travel
• Crontab Syntax Explained: Schedule Cron Jobs on a Linux VPS

in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2