Re: Help on Debian Source building mysql 5.5.10 w/ CMake
Posted by: Noel Cruz
Date: April 02, 2011 10:58PM
Date: April 02, 2011 10:58PM
i did install mysql 5.5.10 on windows and i tested it successfully w/ the msi installer. curious about install on debian.
thanks, noel
here are my notes on windows install:
C:\Documents and Settings\yehey>cd c:\
C:\>net start MySQL
The requested service has already been started.
More help is available by typing NET HELPMSG 2182.
C:\>mysql -p -u root
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE USER 'sampadm'@'localhost' IDENTIFIED BY 'secret';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
C:\>set USER=sampadm
C:\>mysql -p -u sampadm
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT NOW();
+---------------------+
| NOW() |
+---------------------+
| 2011-04-01 18:43:42 |
+---------------------+
1 row in set (0.00 sec)
mysql> SELECT NOW(), USER(), VERSION()\G
*************************** 1. row ***************************
NOW(): 2011-04-01 18:44:49
USER(): sampadm@localhost
VERSION(): 5.5.10
1 row in set (0.00 sec)
mysql> SELECT NOW(),
-> USER(),
-> VERSION()
-> ;
+---------------------+-------------------+-----------+
| NOW() | USER() | VERSION() |
+---------------------+-------------------+-----------+
| 2011-04-01 18:46:11 | sampadm@localhost | 5.5.10 |
+---------------------+-------------------+-----------+
1 row in set (0.00 sec)
mysql> SELECT NOW(),
-> VERSION(),
-> \c
mysql> CREATE DATABASE sampdb;
Query OK, 1 row affected (0.00 sec)
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)
mysql> USE sampdb;
Database changed
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| sampdb |
+------------+
1 row in set (0.00 sec)
mysql> quit
Bye
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> quit
Bye
/***************************
manual method or create_president.sql:
# Create president table for U.S. Historical League
DROP TABLE IF EXISTS president;
#@ _CREATE_TABLE_
CREATE TABLE president
(
last_name VARCHAR(15) NOT NULL,
first_name VARCHAR(15) NOT NULL,
suffix VARCHAR(5) NULL,
city VARCHAR(20) NOT NULL,
state VARCHAR(2) NOT NULL,
birth DATE NOT NULL,
death DATE NULL
);
#@ _CREATE_TABLE_
***************************/
C:\>mysql -p -u sampadm sampdb < C:\ftp\mysql_book\sampdb\create_president.sql
Enter password: ******
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> DESCRIBE president;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| last_name | varchar(15) | NO | | NULL | |
| first_name | varchar(15) | NO | | NULL | |
| suffix | varchar(5) | YES | | NULL | |
| city | varchar(20) | NO | | NULL | |
| state | varchar(2) | NO | | NULL | |
| birth | date | NO | | NULL | |
| death | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)
mysql> DESCRIBE member;
ERROR 1146 (42S02): Table 'sampdb.member' doesn't exist
mysql> SHOW TABLES;
+------------------+
| Tables_in_sampdb |
+------------------+
| president |
+------------------+
1 row in set (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| sampdb |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> mysqlshow sampdb
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
show sampdb' at line 1
mysql> mysqlshow sampdb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
show sampdb' at line 1
mysql> quit
Bye
C:\>mysql -p -u sampadm sampdb < C:\ftp\mysql_book\sampdb\create_member.sql
Enter password: ******
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> DESCRIBE member;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| member_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| last_name | varchar(20) | NO | | NULL | |
| first_name | varchar(20) | NO | | NULL | |
| suffix | varchar(5) | YES | | NULL | |
| expiration | date | YES | | NULL | |
| email | varchar(100) | YES | | NULL | |
| street | varchar(50) | YES | | NULL | |
| city | varchar(50) | YES | | NULL | |
| state | varchar(2) | YES | | NULL | |
| zip | varchar(10) | YES | | NULL | |
| phone | varchar(20) | YES | | NULL | |
| interests | varchar(255) | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)
mysql> mysqlshow sampdb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
show sampdb' at line 1
mysql> SHOW TABLES;
+------------------+
| Tables_in_sampdb |
+------------------+
| member |
| president |
+------------------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM president;
Empty set (0.00 sec)
mysql> source c:\ftp\mysql_book\sampdb\insert_president.sql;
ERROR:
Unknown command '\f'.
ERROR:
Unknown command '\m'.
--------------
mysql Ver 14.14 Distrib 5.5.10, for Win32 (x86)
Connection id: 11
Current database: sampdb
Current user: sampadm@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.5.10 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 1 hour 51 min 22 sec
Threads: 1 Questions: 40 Slow queries: 0 Opens: 44 Flush tables: 1 Open tab
les: 2 Queries per second avg: 0.5
--------------
ERROR:
Unknown command '\i'.
ERROR:
Failed to open file 'c:\ftp\mysql_bookampdb\insert_president.sql', error: 2
mysql> quit
Bye
C:\>mysql -p -u sampadm sampdb < C:\ftp\mysql_book\sampdb\insert_president.sql
Enter password: ******
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM president;
+------------+---------------+--------+---------------------+-------+-----------
-+------------+
| last_name | first_name | suffix | city | state | birth
| death |
+------------+---------------+--------+---------------------+-------+-----------
-+------------+
| Washington | George | NULL | Wakefield | VA | 1732-02-22
| 1799-12-14 |
| Adams | John | NULL | Braintree | MA | 1735-10-30
| 1826-07-04 |
| Jefferson | Thomas | NULL | Albemarle County | VA | 1743-04-13
| 1826-07-04 |
| Madison | James | NULL | Port Conway | VA | 1751-03-16
| 1836-06-28 |
| Monroe | James | NULL | Westmoreland County | VA | 1758-04-28
| 1831-07-04 |
| Adams | John Quincy | NULL | Braintree | MA | 1767-07-11
| 1848-02-23 |
| Jackson | Andrew | NULL | Waxhaw settlement | SC | 1767-03-15
| 1845-06-08 |
| Van Buren | Martin | NULL | Kinderhook | NY | 1782-12-05
| 1862-07-24 |
| Harrison | William H. | NULL | Berkeley | VA | 1773-02-09
| 1841-04-04 |
| Tyler | John | NULL | Greenway | VA | 1790-03-29
| 1862-01-18 |
| Polk | James K. | NULL | Pineville | NC | 1795-11-02
| 1849-06-15 |
| Taylor | Zachary | NULL | Orange County | VA | 1784-11-24
| 1850-07-09 |
| Fillmore | Millard | NULL | Locke | NY | 1800-01-07
| 1874-03-08 |
| Pierce | Franklin | NULL | Hillsboro | NH | 1804-11-23
| 1869-10-08 |
| Buchanan | James | NULL | Mercersburg | PA | 1791-04-23
| 1868-06-01 |
| Lincoln | Abraham | NULL | Hodgenville | KY | 1809-02-12
| 1865-04-15 |
| Johnson | Andrew | NULL | Raleigh | NC | 1808-12-29
| 1875-07-31 |
| Grant | Ulysses S. | NULL | Point Pleasant | OH | 1822-04-27
| 1885-07-23 |
| Hayes | Rutherford B. | NULL | Delaware | OH | 1822-10-04
| 1893-01-17 |
| Garfield | James A. | NULL | Orange | OH | 1831-11-19
| 1881-09-19 |
| Arthur | Chester A. | NULL | Fairfield | VT | 1829-10-05
| 1886-11-18 |
| Cleveland | Grover | NULL | Caldwell | NJ | 1837-03-18
| 1908-06-24 |
| Harrison | Benjamin | NULL | North Bend | OH | 1833-08-20
| 1901-03-13 |
| McKinley | William | NULL | Niles | OH | 1843-01-29
| 1901-09-14 |
| Roosevelt | Theodore | NULL | New York | NY | 1858-10-27
| 1919-01-06 |
| Taft | William H. | NULL | Cincinnati | OH | 1857-09-15
| 1930-03-08 |
| Wilson | Woodrow | NULL | Staunton | VA | 1856-12-19
| 1924-02-03 |
| Harding | Warren G. | NULL | Blooming Grove | OH | 1865-11-02
| 1923-08-02 |
| Coolidge | Calvin | NULL | Plymouth Notch | VT | 1872-07-04
| 1933-01-05 |
| Hoover | Herbert C. | NULL | West Branch | IA | 1874-08-10
| 1964-10-20 |
| Roosevelt | Franklin D. | NULL | Hyde Park | NY | 1882-01-30
| 1945-04-12 |
| Truman | Harry S | NULL | Lamar | MO | 1884-05-08
| 1972-12-26 |
| Eisenhower | Dwight D. | NULL | Denison | TX | 1890-10-14
| 1969-03-28 |
| Kennedy | John F. | NULL | Brookline | MA | 1917-05-29
| 1963-11-22 |
| Johnson | Lyndon B. | NULL | Stonewall | TX | 1908-08-27
| 1973-01-22 |
| Nixon | Richard M. | NULL | Yorba Linda | CA | 1913-01-09
| 1994-04-22 |
| Ford | Gerald R. | NULL | Omaha | NE | 1913-07-14
| 2006-12-26 |
| Carter | James E. | Jr. | Plains | GA | 1924-10-01
| NULL |
| Reagan | Ronald W. | NULL | Tampico | IL | 1911-02-06
| 2004-06-05 |
| Bush | George H.W. | NULL | Milton | MA | 1924-06-12
| NULL |
| Clinton | William J. | NULL | Hope | AR | 1946-08-19
| NULL |
| Bush | George W. | NULL | New Haven | CT | 1946-07-06
| NULL |
+------------+---------------+--------+---------------------+-------+-----------
-+------------+
42 rows in set (0.00 sec)
mysql> SELECT last_name, first_name FROM president
-> WHERE last_name='roosevelt';
+-----------+-------------+
| last_name | first_name |
+-----------+-------------+
| Roosevelt | Theodore |
| Roosevelt | Franklin D. |
+-----------+-------------+
2 rows in set (0.00 sec)
mysql> quit
Bye
C:\>
thanks, noel
here are my notes on windows install:
C:\Documents and Settings\yehey>cd c:\
C:\>net start MySQL
The requested service has already been started.
More help is available by typing NET HELPMSG 2182.
C:\>mysql -p -u root
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE USER 'sampadm'@'localhost' IDENTIFIED BY 'secret';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
C:\>set USER=sampadm
C:\>mysql -p -u sampadm
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT NOW();
+---------------------+
| NOW() |
+---------------------+
| 2011-04-01 18:43:42 |
+---------------------+
1 row in set (0.00 sec)
mysql> SELECT NOW(), USER(), VERSION()\G
*************************** 1. row ***************************
NOW(): 2011-04-01 18:44:49
USER(): sampadm@localhost
VERSION(): 5.5.10
1 row in set (0.00 sec)
mysql> SELECT NOW(),
-> USER(),
-> VERSION()
-> ;
+---------------------+-------------------+-----------+
| NOW() | USER() | VERSION() |
+---------------------+-------------------+-----------+
| 2011-04-01 18:46:11 | sampadm@localhost | 5.5.10 |
+---------------------+-------------------+-----------+
1 row in set (0.00 sec)
mysql> SELECT NOW(),
-> VERSION(),
-> \c
mysql> CREATE DATABASE sampdb;
Query OK, 1 row affected (0.00 sec)
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)
mysql> USE sampdb;
Database changed
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| sampdb |
+------------+
1 row in set (0.00 sec)
mysql> quit
Bye
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> quit
Bye
/***************************
manual method or create_president.sql:
# Create president table for U.S. Historical League
DROP TABLE IF EXISTS president;
#@ _CREATE_TABLE_
CREATE TABLE president
(
last_name VARCHAR(15) NOT NULL,
first_name VARCHAR(15) NOT NULL,
suffix VARCHAR(5) NULL,
city VARCHAR(20) NOT NULL,
state VARCHAR(2) NOT NULL,
birth DATE NOT NULL,
death DATE NULL
);
#@ _CREATE_TABLE_
***************************/
C:\>mysql -p -u sampadm sampdb < C:\ftp\mysql_book\sampdb\create_president.sql
Enter password: ******
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> DESCRIBE president;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| last_name | varchar(15) | NO | | NULL | |
| first_name | varchar(15) | NO | | NULL | |
| suffix | varchar(5) | YES | | NULL | |
| city | varchar(20) | NO | | NULL | |
| state | varchar(2) | NO | | NULL | |
| birth | date | NO | | NULL | |
| death | date | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)
mysql> DESCRIBE member;
ERROR 1146 (42S02): Table 'sampdb.member' doesn't exist
mysql> SHOW TABLES;
+------------------+
| Tables_in_sampdb |
+------------------+
| president |
+------------------+
1 row in set (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| sampdb |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> mysqlshow sampdb
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
show sampdb' at line 1
mysql> mysqlshow sampdb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
show sampdb' at line 1
mysql> quit
Bye
C:\>mysql -p -u sampadm sampdb < C:\ftp\mysql_book\sampdb\create_member.sql
Enter password: ******
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> DESCRIBE member;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| member_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| last_name | varchar(20) | NO | | NULL | |
| first_name | varchar(20) | NO | | NULL | |
| suffix | varchar(5) | YES | | NULL | |
| expiration | date | YES | | NULL | |
| email | varchar(100) | YES | | NULL | |
| street | varchar(50) | YES | | NULL | |
| city | varchar(50) | YES | | NULL | |
| state | varchar(2) | YES | | NULL | |
| zip | varchar(10) | YES | | NULL | |
| phone | varchar(20) | YES | | NULL | |
| interests | varchar(255) | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)
mysql> mysqlshow sampdb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
show sampdb' at line 1
mysql> SHOW TABLES;
+------------------+
| Tables_in_sampdb |
+------------------+
| member |
| president |
+------------------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM president;
Empty set (0.00 sec)
mysql> source c:\ftp\mysql_book\sampdb\insert_president.sql;
ERROR:
Unknown command '\f'.
ERROR:
Unknown command '\m'.
--------------
mysql Ver 14.14 Distrib 5.5.10, for Win32 (x86)
Connection id: 11
Current database: sampdb
Current user: sampadm@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.5.10 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 1 hour 51 min 22 sec
Threads: 1 Questions: 40 Slow queries: 0 Opens: 44 Flush tables: 1 Open tab
les: 2 Queries per second avg: 0.5
--------------
ERROR:
Unknown command '\i'.
ERROR:
Failed to open file 'c:\ftp\mysql_bookampdb\insert_president.sql', error: 2
mysql> quit
Bye
C:\>mysql -p -u sampadm sampdb < C:\ftp\mysql_book\sampdb\insert_president.sql
Enter password: ******
C:\>mysql -p -u sampadm sampdb
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM president;
+------------+---------------+--------+---------------------+-------+-----------
-+------------+
| last_name | first_name | suffix | city | state | birth
| death |
+------------+---------------+--------+---------------------+-------+-----------
-+------------+
| Washington | George | NULL | Wakefield | VA | 1732-02-22
| 1799-12-14 |
| Adams | John | NULL | Braintree | MA | 1735-10-30
| 1826-07-04 |
| Jefferson | Thomas | NULL | Albemarle County | VA | 1743-04-13
| 1826-07-04 |
| Madison | James | NULL | Port Conway | VA | 1751-03-16
| 1836-06-28 |
| Monroe | James | NULL | Westmoreland County | VA | 1758-04-28
| 1831-07-04 |
| Adams | John Quincy | NULL | Braintree | MA | 1767-07-11
| 1848-02-23 |
| Jackson | Andrew | NULL | Waxhaw settlement | SC | 1767-03-15
| 1845-06-08 |
| Van Buren | Martin | NULL | Kinderhook | NY | 1782-12-05
| 1862-07-24 |
| Harrison | William H. | NULL | Berkeley | VA | 1773-02-09
| 1841-04-04 |
| Tyler | John | NULL | Greenway | VA | 1790-03-29
| 1862-01-18 |
| Polk | James K. | NULL | Pineville | NC | 1795-11-02
| 1849-06-15 |
| Taylor | Zachary | NULL | Orange County | VA | 1784-11-24
| 1850-07-09 |
| Fillmore | Millard | NULL | Locke | NY | 1800-01-07
| 1874-03-08 |
| Pierce | Franklin | NULL | Hillsboro | NH | 1804-11-23
| 1869-10-08 |
| Buchanan | James | NULL | Mercersburg | PA | 1791-04-23
| 1868-06-01 |
| Lincoln | Abraham | NULL | Hodgenville | KY | 1809-02-12
| 1865-04-15 |
| Johnson | Andrew | NULL | Raleigh | NC | 1808-12-29
| 1875-07-31 |
| Grant | Ulysses S. | NULL | Point Pleasant | OH | 1822-04-27
| 1885-07-23 |
| Hayes | Rutherford B. | NULL | Delaware | OH | 1822-10-04
| 1893-01-17 |
| Garfield | James A. | NULL | Orange | OH | 1831-11-19
| 1881-09-19 |
| Arthur | Chester A. | NULL | Fairfield | VT | 1829-10-05
| 1886-11-18 |
| Cleveland | Grover | NULL | Caldwell | NJ | 1837-03-18
| 1908-06-24 |
| Harrison | Benjamin | NULL | North Bend | OH | 1833-08-20
| 1901-03-13 |
| McKinley | William | NULL | Niles | OH | 1843-01-29
| 1901-09-14 |
| Roosevelt | Theodore | NULL | New York | NY | 1858-10-27
| 1919-01-06 |
| Taft | William H. | NULL | Cincinnati | OH | 1857-09-15
| 1930-03-08 |
| Wilson | Woodrow | NULL | Staunton | VA | 1856-12-19
| 1924-02-03 |
| Harding | Warren G. | NULL | Blooming Grove | OH | 1865-11-02
| 1923-08-02 |
| Coolidge | Calvin | NULL | Plymouth Notch | VT | 1872-07-04
| 1933-01-05 |
| Hoover | Herbert C. | NULL | West Branch | IA | 1874-08-10
| 1964-10-20 |
| Roosevelt | Franklin D. | NULL | Hyde Park | NY | 1882-01-30
| 1945-04-12 |
| Truman | Harry S | NULL | Lamar | MO | 1884-05-08
| 1972-12-26 |
| Eisenhower | Dwight D. | NULL | Denison | TX | 1890-10-14
| 1969-03-28 |
| Kennedy | John F. | NULL | Brookline | MA | 1917-05-29
| 1963-11-22 |
| Johnson | Lyndon B. | NULL | Stonewall | TX | 1908-08-27
| 1973-01-22 |
| Nixon | Richard M. | NULL | Yorba Linda | CA | 1913-01-09
| 1994-04-22 |
| Ford | Gerald R. | NULL | Omaha | NE | 1913-07-14
| 2006-12-26 |
| Carter | James E. | Jr. | Plains | GA | 1924-10-01
| NULL |
| Reagan | Ronald W. | NULL | Tampico | IL | 1911-02-06
| 2004-06-05 |
| Bush | George H.W. | NULL | Milton | MA | 1924-06-12
| NULL |
| Clinton | William J. | NULL | Hope | AR | 1946-08-19
| NULL |
| Bush | George W. | NULL | New Haven | CT | 1946-07-06
| NULL |
+------------+---------------+--------+---------------------+-------+-----------
-+------------+
42 rows in set (0.00 sec)
mysql> SELECT last_name, first_name FROM president
-> WHERE last_name='roosevelt';
+-----------+-------------+
| last_name | first_name |
+-----------+-------------+
| Roosevelt | Theodore |
| Roosevelt | Franklin D. |
+-----------+-------------+
2 rows in set (0.00 sec)
mysql> quit
Bye
C:\>
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.