> For the complete documentation index, see [llms.txt](https://codexpress.gitbook.io/welcome-to-datagenesis/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://codexpress.gitbook.io/welcome-to-datagenesis/sql-structured-query-language/crud-operations.md).

# CRUD Operations

```sql

-- create a new table 
CREATE TABLE student(
  id INT PRIMARY KEY,
  name VARCHAR(255)
  );
  
  -- insert a data in table
  
 INSERT INTO student VALUES(1 , "Manraj");
 
-- query all the records from table 
 SELECT * FROM student;
 
 
```