PythonLogin

an anonymous user · September 16, 2021 · SQL
-- create a table
CREATE TABLE accounts (
  'id' int(11) NOT NULL auto_increment,
  'username' varchar(50) NOT NULL,
  'password' signed(20) NOT NULL,
  'admin' boolean() NOT NULL
);
-- insert some values
INSERT INTO accounts ('id', 'username', 'password', 'admin') VALUES (1, 'testusername', '-966697084172663693', TRUE);
-- fetch some values
SELECT * FROM accounts WHERE admin = TRUE;

Comments

Please sign up or log in to contribute to the discussion.