spieleprogrammierer.de - Forum und Wiki zur Spieleprogrammierung und Spieleentwicklung

Quellcode

mysql> CREATE TABLE TEST_TB (
    ->  ID INTEGER AUTO_INCREMENT PRIMARY KEY,
    ->  BALANCE INTEGER NOT NULL,
    ->  SALARY INTEGER NOT NULL
    -> );
Query OK, 0 rows affected (0.37 sec)

mysql> DESC TEST_TB;
+---------+---------+------+-----+---------+----------------+
| Field   | Type    | Null | Key | Default | Extra          |
+---------+---------+------+-----+---------+----------------+
| ID      | int(11) | NO   | PRI | NULL    | auto_increment |
| BALANCE | int(11) | NO   |     | NULL    |                |
| SALARY  | int(11) | NO   |     | NULL    |                |
+---------+---------+------+-----+---------+----------------+
3 rows in set (0.06 sec)

mysql> INSERT INTO TEST_TB (BALANCE) VALUES (1000);
Query OK, 1 row affected, 1 warning (0.08 sec)

mysql> SHOW WARNINGS;
+---------+------+---------------------------------------------+
| Level   | Code | Message                                     |
+---------+------+---------------------------------------------+
| Warning | 1364 | Field 'SALARY' doesn't have a default value |
+---------+------+---------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM TEST_TB;
+----+---------+--------+
| ID | BALANCE | SALARY |
+----+---------+--------+
|  1 |    1000 |      0 |
+----+---------+--------+
1 row in set (0.00 sec)

Quellcode

mysql> CREATE TABLE IF NOT EXISTS TEST_TB (
    ->  BOOLS BOOLEAN NOT NULL
    -> );
Query OK, 0 rows affected (4.02 sec)

mysql> DESC TEST_TB;
+-------+------------+------+-----+---------+-------+
| Field | Type       | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| BOOLS | tinyint(1) | NO   |     | NULL    |       |
+-------+------------+------+-----+---------+-------+
1 row in set (0.01 sec)

Quellcode

mysql> INSERT INTO TEST_TB VALUES (TRUE), (FALSE), (1), (0), (42), (-42);
Query OK, 6 rows affected (0.09 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM TEST_TB;
+-------+
| BOOLS |
+-------+
|     1 |
|     0 |
|     1 |
|     0 |
|    42 |
|   -42 |
+-------+
6 rows in set (0.00 sec)

Quellcode

mysql> SELECT
    ->  BOOLS,
    ->  IF(BOOLS = TRUE, "TRUE!", "FALSE!") TEST
    -> FROM TEST_TB;
+-------+--------+
| BOOLS | TEST   |
+-------+--------+
|     1 | TRUE!  |
|     0 | FALSE! |
|     1 | TRUE!  |
|     0 | FALSE! |
|    42 | FALSE! |
|   -42 | FALSE! |
+-------+--------+
6 rows in set (0.00 sec)

Quellcode

mysql> CREATE TABLE TEST_TB (
    ->  ID INTEGER AUTO_INCREMENT PRIMARY KEY,
    ->  VALUE INTEGER NOT NULL
    -> );
Query OK, 0 rows affected (0.30 sec)

mysql> INSERT INTO TEST_TB (VALUE) VALUES (0), (1), (42);
Query OK, 3 rows affected (0.08 sec)
Records: 3  Duplicates: 0  Warnings: 0

Quellcode

mysql> SELECT * FROM TEST_TB WHERE VALUE = "APFELKUCHEN";
+----+-------+
| ID | VALUE |
+----+-------+
|  1 |     0 |
+----+-------+
1 row in set, 1 warning (0.03 sec)

Quellcode

mysql> SHOW WARNINGS;
+---------+------+-------------------------------------------------+
| Level   | Code | Message                                         |
+---------+------+-------------------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'APFELKUCHEN' |
+---------+------+-------------------------------------------------+
1 row in set (0.00 sec)

Quellcode

public function doesUserExist($username) {
    $stmt = $this->pdo->prepare('SELECT COUNT(*) FROM USERS_TB WHERE NAME = ?');
    if($stmt->execute(array($username))) {
        return $stmt->fetchColumn() > 0;
    }
    else {
        // Handle Errors...
    }
}