Create Table
Create MySQL Table
In this little course today we will be creating a table with the name "players", with 2 columns called "username", and "userid". Example:
CREATE TABLE players (
userid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL
)
Notes (source: https://www.w3schools.com/php/php_mysql_create_table.asp)
The data type specifies what type of data the column can hold. For a complete reference of all the available data types, go to our Data Types reference.
After the data type, you can specify other optional attributes for each column:
NOT NULL - Each row must contain a value for that column, null values are not allowed
DEFAULT value - Set a default value that is added when no other value is passed
UNSIGNED - Used for number types, limits the stored data to positive numbers and zero
AUTO INCREMENT - MySQL automatically increases the value of the field by 1 each time a new record is added
PRIMARY KEY - Used to uniquely identify the rows in a table. The column with the PRIMARY KEY setting is often an ID number and is often used with AUTO_INCREMENT
BLOXsql Example
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("CREATE TABLE players (userid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,username VARCHAR(30) NOT NULL)", Settings)
Last updated
Was this helpful?