Yioop - PHP Search Engine

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

-- 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)

-- 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)

-- 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)

-- 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)

-- 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)

-- 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]>

-- 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>

-- 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]>

-- 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)