sql-challenge

CRUD SQL exercises for beginners(Base MySQL).

展示效果

✨ Features

1. Create exercise

• Create a table
• Create a table with constraints
• Create a table with indexes
• Insert data into the table
• Create Views

2. Select exercise

• Basic select
• Select with where
• Select with like
• Select with in
• Select with between
• Select with order by
• Select with group by
• Select with having
• Select with join
• Select with union
• Select with case
• Select with limit
• Select with offset
• Select with subquery
• Select with exists
• Select with any, all
• ...

3. Update exercise

• Update Table
• Update Data

4. Delete exercise

• Delete Table
• Delete Data

🏗 Development

sql-challenge is built using a modern tech stack:

• React
• Vite
• TypeScript
• Tailwind CSS
• pnpm
• alasql
• shadcn/ui
• TanStack Router
• monaco-editor
• @bytemd/react

Prerequisites

• Node.js
• pnpm

Getting Started

# Clone the repo
git clone [email protected]:learner-next/sql-challenge.git

# Install dependencies
pnpm install

# Start the dev server
pnpm dev

Then open http://localhost:5173/ to see your app.

🌸 Thanks

This project is heavily inspired by the following awesome projects.

• sql-mother
• SQL Tutorial

📝 License

MIT License © 2023-PRESENT Talljack