[Skip Navigation]
2016-03-02
User Icon

Mar 2 Thread.

Hey Everyone, Post your code for the Mar 2 "Let's Build Something here". Remember if you precede each line of your code by at least one white space character it will be output preformatted in your post. Best, Chris
Hey Everyone, Post your code for the Mar 2 "Let's Build Something here". Remember if you precede each line of your code by at least one white space character it will be output preformatted in your post. Best, Chris
User Icon
-- Mar 2 Thread
	mysql> CREATE DATABASE PERSON;
        mysql> USE PERSON;
        mysql> CREATE TABLE PEOPLE ( first_name VARCHAR(20), last_name VARCHAR(20), age int(2), id int );

	Query OK, 1 row affected (0.01 sec)

	mysql> SHOW TABLES;
	+------------------+
	| Tables_in_person |
	+------------------+
	| PEOPLE           |
	+------------------+
	1 row in set (0.01 sec)

	mysql> INSERT INTO PEOPLE VALUES ("Henry","Spivey", 21, 1);

	Query OK, 1 row affected (0.01 sec)

	mysql> INSERT INTO PEOPLE VALUES ("William","Spivey", 17, 2);

	Query OK, 1 row affected (0.01 sec)

	mysql> INSERT INTO PEOPLE VALUES ("Ella","Spivey", 26, 3);

	Query OK, 1 row affected (0.01 sec)

	mysql> SELECT * FROM PEOPLE WHERE age<25;
	+------------+-----------+------+------+
	| first_name | last_name | age  | id   |
	+------------+-----------+------+------+
	| Henry      | Spivey    |   21 |    1 |
	| William    | Spivey    |   17 |    2 |
	+------------+-----------+------+------+
2 rows in set (0.00 sec)(Edited: 2016-03-02)
mysql> CREATE DATABASE PERSON; mysql> USE PERSON; mysql> CREATE TABLE PEOPLE ( first_name VARCHAR(20), last_name VARCHAR(20), age int(2), id int ); Query OK, 1 row affected (0.01 sec) mysql> SHOW TABLES; +------------------+ | Tables_in_person | +------------------+ | PEOPLE | +------------------+ 1 row in set (0.01 sec) mysql> INSERT INTO PEOPLE VALUES ("Henry","Spivey", 21, 1); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO PEOPLE VALUES ("William","Spivey", 17, 2); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO PEOPLE VALUES ("Ella","Spivey", 26, 3); Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM PEOPLE WHERE age<25; +------------+-----------+------+------+ | first_name | last_name | age | id | +------------+-----------+------+------+ | Henry | Spivey | 21 | 1 | | William | Spivey | 17 | 2 | +------------+-----------+------+------+ 2 rows in set (0.00 sec)
User Icon
-- Mar 2 Thread
mysql> CREATE TABLE person ( 
    ->     id int(5) NOT NULL,

    ->     first_name VARCHAR(50),

    ->     last_name VARCHAR(50),

    ->     age int(5)

    -> );
Query OK, 0 rows affected (0.07 sec)
mysql> INSERT INTO person VALUES (1, 'Kaya', 'Ota', 123);
Query OK, 1 row affected (0.02 sec)
mysql> INSERT INTO person VALUES (2, 'Keisuke', 'Ota', 12345);
Query OK, 1 row affected (0.01 sec)
mysql> INSERT INTO person VALUES (3, 'Dreamy', 'Friends', 12);
Query OK, 1 row affected (0.01 sec)
mysql> select * from person where id < 3;
+----+------------+-----------+-------+ | id | first_name | last_name | age | +----+------------+-----------+-------+ | 1 | Kaya | Ota | 123 | | 2 | Keisuke | Ota | 12345 | +----+------------+-----------+-------+ 2 rows in set (0.00 sec)
(Edited: 2016-03-02)
mysql> CREATE TABLE person ( -> id int(5) NOT NULL, -> first_name VARCHAR(50), -> last_name VARCHAR(50), -> age int(5) -> ); Query OK, 0 rows affected (0.07 sec) mysql> INSERT INTO person VALUES (1, 'Kaya', 'Ota', 123); Query OK, 1 row affected (0.02 sec) mysql> INSERT INTO person VALUES (2, 'Keisuke', 'Ota', 12345); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO person VALUES (3, 'Dreamy', 'Friends', 12); Query OK, 1 row affected (0.01 sec) mysql> select * from person where id < 3; +----+------------+-----------+-------+ | id | first_name | last_name | age | +----+------------+-----------+-------+ | 1 | Kaya | Ota | 123 | | 2 | Keisuke | Ota | 12345 | +----+------------+-----------+-------+ 2 rows in set (0.00 sec)
User Icon
-- Mar 2 Thread
 mysql> create DATABASE THE_WORLD; 
 Query OK, 1 row affected (0.03 sec) 

 mysql> use THE_WORLD; 
 Database changed 

 mysql> CREATE TABLE Person ( 
     -> id int(9) NOT NULL, 
     -> age int(2), 
     -> first_name VARCHAR(20), 
     -> last_name VARCHAR(20)); 
 Query OK, 0 rows affected (0.34 sec) 

 mysql> INSERT INTO Person VALUES (012345678, 23, 'David', 'Smith'); 
 Query OK, 1 row affected (0.11 sec) 

 mysql> INSERT INTO Person VALUES (012345698, 53, 'Jim', 'Smith'); 
 Query OK, 1 row affected (0.08 sec) 

 mysql> INSERT INTO Person VALUES (999999999, 45, 'James', 'Bond'); 
 Query OK, 1 row affected (0.06 sec) 

 mysql> SELECT * FROM Person WHERE age > 30; 
 +-----------+------+------------+-----------+ 
 | id        | age  | first_name | last_name | 
 +-----------+------+------------+-----------+ 
 |  12345698 |   53 | Jim        | Smith     | 
 | 999999999 |   45 | James      | Bond      | 
 +-----------+------+------------+-----------+ 
 2 rows in set (0.05 sec)
mysql> create DATABASE THE_WORLD; Query OK, 1 row affected (0.03 sec) mysql> use THE_WORLD; Database changed mysql> CREATE TABLE Person ( -> id int(9) NOT NULL, -> age int(2), -> first_name VARCHAR(20), -> last_name VARCHAR(20)); Query OK, 0 rows affected (0.34 sec) mysql> INSERT INTO Person VALUES (012345678, 23, 'David', 'Smith'); Query OK, 1 row affected (0.11 sec) mysql> INSERT INTO Person VALUES (012345698, 53, 'Jim', 'Smith'); Query OK, 1 row affected (0.08 sec) mysql> INSERT INTO Person VALUES (999999999, 45, 'James', 'Bond'); Query OK, 1 row affected (0.06 sec) mysql> SELECT * FROM Person WHERE age > 30; +-----------+------+------------+-----------+ | id | age | first_name | last_name | +-----------+------+------------+-----------+ | 12345698 | 53 | Jim | Smith | | 999999999 | 45 | James | Bond | +-----------+------+------------+-----------+ 2 rows in set (0.05 sec)
User Icon
-- Mar 2 Thread
 DROP DATABASE IF EXISTS THE_WORLD;
 CREATE DATABASE THE_WORLD;
 USE THE_WORLD;

 DROP TABLE IF EXISTS PERSON;
 CREATE TABLE PERSON
 (id INT AUTO_INCREMENT,
 age INT,
 first_name VARCHAR(20) NOT NULL DEFAULT 'Undefined first name',
 last_name VARCHAR(20) NOT NULL DEFAULT 'Undefined last name',
 PRIMARY KEY (id)
 );

 INSERT INTO PERSON
 VALUES(null,20,"John","Smith");

 INSERT INTO PERSON
 VALUES(null,25,"Mary","Jane");

 INSERT INTO PERSON
 VALUES(null,10,"This","Works");

 SELECT * FROM PERSON
 WHERE age > 15;

 mysql> use THE_WORLD;
 Database changed
 mysql> select * from PERSON where age > 15;
 +----+------+------------+-----------+
 | id | age  | first_name | last_name |
 +----+------+------------+-----------+
 |  1 |   20 | John       | Smith     |
 |  2 |   25 | Mary       | Jane      |
 +----+------+------------+-----------+
 2 rows in set (0.00 sec)
(Edited: 2016-03-02)
DROP DATABASE IF EXISTS THE_WORLD; CREATE DATABASE THE_WORLD; USE THE_WORLD; DROP TABLE IF EXISTS PERSON; CREATE TABLE PERSON (id INT AUTO_INCREMENT, age INT, first_name VARCHAR(20) NOT NULL DEFAULT 'Undefined first name', last_name VARCHAR(20) NOT NULL DEFAULT 'Undefined last name', PRIMARY KEY (id) ); INSERT INTO PERSON VALUES(null,20,"John","Smith"); INSERT INTO PERSON VALUES(null,25,"Mary","Jane"); INSERT INTO PERSON VALUES(null,10,"This","Works"); SELECT * FROM PERSON WHERE age > 15; mysql> use THE_WORLD; Database changed mysql> select * from PERSON where age > 15; +----+------+------------+-----------+ | id | age | first_name | last_name | +----+------+------------+-----------+ | 1 | 20 | John | Smith | | 2 | 25 | Mary | Jane | +----+------+------------+-----------+ 2 rows in set (0.00 sec)
User Icon
-- Mar 2 Thread
MariaDB [MYTEST]> create table person(id int,age int,first_name varchar(20),last_name varchar(20)); Query OK, 0 rows affected (0.02 sec)
MariaDB [MYTEST]> insert into person values(1,20,'Hari','J'); Query OK, 1 row affected (0.00 sec)
MariaDB [MYTEST]> insert into person values(2,20,'Harika','J'); Query OK, 1 row affected (0.00 sec)
MariaDB [MYTEST]> insert into person values(3,20,'Sarika','J'); Query OK, 1 row affected (0.00 sec)
select * from person where id<3; +------+------+------------+-----------+ | id | age | first_name | last_name | +------+------+------------+-----------+ | 1 | 20 | Hari | J | | 2 | 20 | Harika | J | +------+------+------------+-----------+ 2 rows in set (0.00 sec)
MariaDB [MYTEST]> create table person(id int,age int,first_name varchar(20),last_name varchar(20)); Query OK, 0 rows affected (0.02 sec) MariaDB [MYTEST]> insert into person values(1,20,'Hari','J'); Query OK, 1 row affected (0.00 sec) MariaDB [MYTEST]> insert into person values(2,20,'Harika','J'); Query OK, 1 row affected (0.00 sec) MariaDB [MYTEST]> insert into person values(3,20,'Sarika','J'); Query OK, 1 row affected (0.00 sec) select * from person where id<3; +------+------+------------+-----------+ | id | age | first_name | last_name | +------+------+------------+-----------+ | 1 | 20 | Hari | J | | 2 | 20 | Harika | J | +------+------+------------+-----------+ 2 rows in set (0.00 sec)
User Icon
-- Mar 2 Thread
MariaDB [THE_WORLD]> create table PERSON (id int, age int, first_name varchar(20), last_name varchar(20)); Query OK, 0 rows affected (0.01 sec)
MariaDB [THE_WORLD]> insert into PERSON values('01', '18', 'Roger', 'Teng'); Query OK, 1 row affected (0.01 sec)
MariaDB [THE_WORLD]> insert into PERSON values('02', '19', 'William', 'Zheng'); Query OK, 1 row affected (0.00 sec)
MariaDB [THE_WORLD]> insert into PERSON values('03', '18', 'Billy', 'Zhou'); Query OK, 1 row affected (0.00 sec)
MariaDB [THE_WORLD]> select * from PERSON where age=18; +------+------+------------+-----------+ | id | age | first_name | last_name | +------+------+------------+-----------+ | 1 | 18 | Roger | Teng | | 3 | 18 | Billy | Zhou | +------+------+------------+-----------+ 2 rows in set (0.00 sec)
MariaDB [THE_WORLD]>
(Edited: 2016-03-02)
MariaDB [THE_WORLD]> create table PERSON (id int, age int, first_name varchar(20), last_name varchar(20)); Query OK, 0 rows affected (0.01 sec) MariaDB [THE_WORLD]> insert into PERSON values('01', '18', 'Roger', 'Teng'); Query OK, 1 row affected (0.01 sec) MariaDB [THE_WORLD]> insert into PERSON values('02', '19', 'William', 'Zheng'); Query OK, 1 row affected (0.00 sec) MariaDB [THE_WORLD]> insert into PERSON values('03', '18', 'Billy', 'Zhou'); Query OK, 1 row affected (0.00 sec) MariaDB [THE_WORLD]> select * from PERSON where age=18; +------+------+------------+-----------+ | id | age | first_name | last_name | +------+------+------------+-----------+ | 1 | 18 | Roger | Teng | | 3 | 18 | Billy | Zhou | +------+------+------------+-----------+ 2 rows in set (0.00 sec) MariaDB [THE_WORLD]>
User Icon
-- Mar 2 Thread
	mysql> create database THE_WORLD;
	Query OK, 1 row affected (0.00 sec)

	mysql> select THE_WORLD;
	ERROR 1054 (42S22): Unknown column 'THE_WORLD' in 'field list'
	mysql> use THE_WORLD;
	Database changed
	mysql> create table PERSON (id int, age int, first_name varchar(20), last_name v
	archar(20));
	Query OK, 0 rows affected (0.02 sec)

	mysql> describe the_world;
	ERROR 1146 (42S02): Table 'the_world.the_world' doesn't exist
	mysql> describe person;
	+------------+-------------+------+-----+---------+-------+
	| Field      | Type        | Null | Key | Default | Extra |
	+------------+-------------+------+-----+---------+-------+
	| id         | int(11)     | YES  |     | NULL    |       |
	| age        | int(11)     | YES  |     | NULL    |       |
	| first_name | varchar(20) | YES  |     | NULL    |       |
	| last_name  | varchar(20) | YES  |     | NULL    |       |
	+------------+-------------+------+-----+---------+-------+
	4 rows in set (0.02 sec)

	mysql> insert into person values (1, 25, 'aayush', 'neupane');
	Query OK, 1 row affected (0.00 sec)

	mysql> insert into person values (2, 26, 'jacky', 'chan');
	Query OK, 1 row affected (0.00 sec)

	mysql> insert into person values (3, 27, 'aaa', 'bbb');
	Query OK, 1 row affected (0.00 sec)

	mysql> select * from person
		-> ;
	+------+------+------------+-----------+
	| id   | age  | first_name | last_name |
	+------+------+------------+-----------+
	|    1 |   25 | aayush     | neupane   |
	|    2 |   26 | jacky      | chan      |
	|    3 |   27 | aaa        | bbb       |
	+------+------+------------+-----------+
	3 rows in set (0.00 sec)

	mysql> select * from person where id < 3;
	+------+------+------------+-----------+
	| id   | age  | first_name | last_name |
	+------+------+------------+-----------+
	|    1 |   25 | aayush     | neupane   |
	|    2 |   26 | jacky      | chan      |
	+------+------+------------+-----------+
	2 rows in set (0.00 sec)

	mysql>
mysql> create database THE_WORLD; Query OK, 1 row affected (0.00 sec) mysql> select THE_WORLD; ERROR 1054 (42S22): Unknown column 'THE_WORLD' in 'field list' mysql> use THE_WORLD; Database changed mysql> create table PERSON (id int, age int, first_name varchar(20), last_name v archar(20)); Query OK, 0 rows affected (0.02 sec) mysql> describe the_world; ERROR 1146 (42S02): Table 'the_world.the_world' doesn't exist mysql> describe person; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | age | int(11) | YES | | NULL | | | first_name | varchar(20) | YES | | NULL | | | last_name | varchar(20) | YES | | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.02 sec) mysql> insert into person values (1, 25, 'aayush', 'neupane'); Query OK, 1 row affected (0.00 sec) mysql> insert into person values (2, 26, 'jacky', 'chan'); Query OK, 1 row affected (0.00 sec) mysql> insert into person values (3, 27, 'aaa', 'bbb'); Query OK, 1 row affected (0.00 sec) mysql> select * from person -> ; +------+------+------------+-----------+ | id | age | first_name | last_name | +------+------+------------+-----------+ | 1 | 25 | aayush | neupane | | 2 | 26 | jacky | chan | | 3 | 27 | aaa | bbb | +------+------+------------+-----------+ 3 rows in set (0.00 sec) mysql> select * from person where id < 3; +------+------+------------+-----------+ | id | age | first_name | last_name | +------+------+------------+-----------+ | 1 | 25 | aayush | neupane | | 2 | 26 | jacky | chan | +------+------+------------+-----------+ 2 rows in set (0.00 sec) mysql>
User Icon
-- Mar 2 Thread
 MariaDB [(none)]> CREATE DATABASE MY_WORLD;
 Query OK, 1 row affected (0.00 sec)

 
 MariaDB [(none)]> USE MY_WORLD
 Database changed
 MariaDB [MY_WORLD]> CREATE TABLE PEOPLE( id int, first_name VARCHAR(20), last_name VARCHAR(20), age int(2));
 Query OK, 0 rows affected (0.30 sec)

 MariaDB [MY_WORLD]> INSERT INTO PEOPLE VALUES (1, "Deepika", "Pathinga", 27);
 Query OK, 1 row affected (0.08 sec)

 MariaDB [MY_WORLD]> INSERT INTO PEOPLE VALUES (2, "Bala", "Achie", 33);
 Query OK, 1 row affected (0.10 sec)

 MariaDB [MY_WORLD]> INSERT INTO PEOPLE VALUES (3, "Vishnu", "Achie", 2);
 Query OK, 1 row affected (0.09 sec)

 MariaDB [MY_WORLD]> SELECT * FROM PEOPLE WHERE age<28;
 +------+------------+-----------+------+
 | id   | first_name | last_name | age  |
 +------+------------+-----------+------+
 |    1 | Deepika    | Pathinga  |   27 |
 |    3 | Vishnu     | Achie     |    2 |
 +------+------------+-----------+------+
 2 rows in set (0.00 sec)

 MariaDB [MY_WORLD]>
(Edited: 2016-03-02)
MariaDB [(none)]> CREATE DATABASE MY_WORLD; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> USE MY_WORLD Database changed MariaDB [MY_WORLD]> CREATE TABLE PEOPLE( id int, first_name VARCHAR(20), last_name VARCHAR(20), age int(2)); Query OK, 0 rows affected (0.30 sec) MariaDB [MY_WORLD]> INSERT INTO PEOPLE VALUES (1, "Deepika", "Pathinga", 27); Query OK, 1 row affected (0.08 sec) MariaDB [MY_WORLD]> INSERT INTO PEOPLE VALUES (2, "Bala", "Achie", 33); Query OK, 1 row affected (0.10 sec) MariaDB [MY_WORLD]> INSERT INTO PEOPLE VALUES (3, "Vishnu", "Achie", 2); Query OK, 1 row affected (0.09 sec) MariaDB [MY_WORLD]> SELECT * FROM PEOPLE WHERE age<28; +------+------------+-----------+------+ | id | first_name | last_name | age | +------+------------+-----------+------+ | 1 | Deepika | Pathinga | 27 | | 3 | Vishnu | Achie | 2 | +------+------------+-----------+------+ 2 rows in set (0.00 sec) MariaDB [MY_WORLD]>
User Icon
-- Mar 2 Thread
 MariaDB [(none)]> CREATE DATABASE PEOPLE;
 Query OK, 1 row affected (0.00 sec)

 MariaDB [(none)]> use PEOPLE;
 Database changed
 MariaDB [PEOPLE]> CREATE TABLE PERSON (ID INT,FIRST_NAME VARCHAR(20),LAST_NAME VARCHAR(20), AGE INT   ,PRIMARY KEY (ID))
     -> ;
 Query OK, 0 rows affected (0.11 sec)
 
 MariaDB [PEOPLE]> desc PERSON;
 +------------+-------------+------+-----+---------+-------+
 | Field      | Type        | Null | Key | Default | Extra |
 +------------+-------------+------+-----+---------+-------+
 | ID         | int(11)     | NO   | PRI | NULL    |       |
 | FIRST_NAME | varchar(20) | YES  |     | NULL    |       |
 | LAST_NAME  | varchar(20) | YES  |     | NULL    |       |
 | AGE        | int(11)     | YES  |     | NULL    |       |
 +------------+-------------+------+-----+---------+-------+
 4 rows in set (0.01 sec)
 
 MariaDB [PEOPLE]> INSERT INTO PERSON VALUES (1,'SARIKA','PADMASHALI',23);
 Query OK, 1 row affected (0.00 sec)

 MariaDB [PEOPLE]> INSERT INTO PERSON VALUES (2,'KEVIN','CHARLES',22);
 Query OK, 1 row affected (0.00 sec)
 
 MariaDB [PEOPLE]> INSERT INTO PERSON VALUES (3,'SAM','LEE',21);
 Query OK, 1 row affected (0.00 sec)
 
 MariaDB [PEOPLE]> SELECT FIRST_NAME AS F1 FROM PERSON WHERE LAST_NAME LIKE ('%H%');
 +--------+
 | F1     |
 +--------+
 | SARIKA |
 | KEVIN  |
 +--------+
 2 rows in set (0.00 sec)
MariaDB [(none)]> CREATE DATABASE PEOPLE; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use PEOPLE; Database changed MariaDB [PEOPLE]> CREATE TABLE PERSON (ID INT,FIRST_NAME VARCHAR(20),LAST_NAME VARCHAR(20), AGE INT ,PRIMARY KEY (ID)) -> ; Query OK, 0 rows affected (0.11 sec) MariaDB [PEOPLE]> desc PERSON; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | ID | int(11) | NO | PRI | NULL | | | FIRST_NAME | varchar(20) | YES | | NULL | | | LAST_NAME | varchar(20) | YES | | NULL | | | AGE | int(11) | YES | | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.01 sec) MariaDB [PEOPLE]> INSERT INTO PERSON VALUES (1,'SARIKA','PADMASHALI',23); Query OK, 1 row affected (0.00 sec) MariaDB [PEOPLE]> INSERT INTO PERSON VALUES (2,'KEVIN','CHARLES',22); Query OK, 1 row affected (0.00 sec) MariaDB [PEOPLE]> INSERT INTO PERSON VALUES (3,'SAM','LEE',21); Query OK, 1 row affected (0.00 sec) MariaDB [PEOPLE]> SELECT FIRST_NAME AS F1 FROM PERSON WHERE LAST_NAME LIKE ('%H%'); +--------+ | F1 | +--------+ | SARIKA | | KEVIN | +--------+ 2 rows in set (0.00 sec)
X

 

- Blog - Privacy - Terms - YioopBot - Developed at SeekQuarry -
(c) 2025 Yioop - PHP Search Engine
We use cookies to implement this site's user functionality, social media features, and traffic analytics. Privacy Policy Details. Allow Cookies