> For the complete documentation index, see [llms.txt](https://bloxsql.metatable.dev/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://bloxsql.metatable.dev/101/insert.md).

# Insert Data

## Insert

We will be showing you how to do a basic INSERT with BLOXsql.

After a database and a table have been created, you are able to start creating some data into them with BLOXsql.

Here are some syntax rules to follow:

* The SQL query must be quoted in PHP
* String values inside the SQL query must be quoted
* Numeric values must not be quoted
* The word NULL must not be quoted
* * w3schools.com

The INSERT INTO is used to add new records to a MySQL table. Here's an example using BLOXsql.

```lua
local BLOXsql = require(16229654720) 
local Settings= {
	-- Ensure you whitelist "141.98.74.17" with your database host.
	Username = "rampage_admin",
	Password = "1234567890",
	Host = "localhost",
	Database = "rampage_main"
}

BLOXsql:execute("INSERT INTO example (name) VALUES('Roblox')", Settings)
```

Inserting data into a table.

```sql
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2, ...)
```