DB memo

Last login: Thu Oct 20 22:55:00 on console
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:~ marimo$ cd /Applications/MAMP/Library/bin/
Marimo-no-MacBook-Air:bin marimo$ /mysql -u root
-bash: /mysql: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ myswl
-bash: myswl: command not found
Marimo-no-MacBook-Air:bin marimo$ ls
2to3                mysqldbcompare
Magick++-config         mysqldbcopy
Magick-config           mysqldbexport
MagickCore-config       mysqldbimport
MagickWand-config       mysqldiff
Wand-config         mysqldiskusage
a2p             mysqldump
ab              mysqldumpslow
animate             mysqlfailover
apachectl           mysqlfrm
apxs                mysqlhotcopy
autopoint           mysqlimport
bmp2tiff            mysqlindexcheck
c2ph                mysqlmetagrep
cgi-fcgi            mysqlprocgrep
checkgid            mysqlreplicate
cjpeg               mysqlrpladmin
compare             mysqlrplcheck
composite           mysqlrplshow
config_data         mysqlserverclone
conjure             mysqlserverinfo
convert             mysqlshow
corelist            mysqlslap
cpan                mysqltest
curl                mysqluc
curl-config         mysqluserclone
dbilogstrip         ngettext
dbiprof             nginxctl
dbiproxy            pal2rgb
dbmmanage           pcre-config
derb                pcregrep
display             pcretest
djpeg               pdf2dsc
dvipdf              pdf2ps
enc2xs              perl
envsubst            perl5.20.0
envvars-std_            perlbug
envvars_            perldoc
eps2eps             perlivp
fax2ps              perlthanks
fax2tiff            perror
find2perl           pf2afm
font2c              pfbtopfa
freetype-config         phpunit
genbrk              phpunit.phar
gencfu              piconv
gencnval            pkgdata
gendict             pl2pm
genrb               png-fix-itxt
gettext             pngfix
gettext.sh          pod2html
gettextize          pod2man
gif2tiff            pod2text
gs              pod2usage
gsbj                podchecker
gsdj                podselect
gsdj500             pphs
gslj                ppm2tiff
gslp                printafm
gsnd                prove
h2ph                ps2ascii
h2xs                ps2epsi
htcacheclean            ps2pdf
htdbm               ps2pdf12
htdigest            ps2pdf13
htpasswd            ps2pdf14
httpd               ps2pdfwr
httxt2dbm           ps2ps
iconv               ps2ps2
icu-config          psed
icuinfo             pstruct
identify            ptar
idle                ptardiff
idn             ptargrep
import              pydoc
innochecksum            python
instmodsh           python-config
jpegtran            python2
json_pp             python2-config
libmcrypt-config        python2.7
libnetcfg           python2.7-config
libpng-config           ras2tiff
libpng16-config         raw2tiff
libtool             rdjpgcom
libtoolize          recode-sr-latin
logresolve          replace
lprsetup.sh         resolve_stack_dump
makeconv            resolveip
mod_python          rgb2ycbcr
mogrify             rotatelogs
montage             s2p
mp2bug              sabcmd
msgattrib           sablot-config
msgcat              shasum
msgcmp              smtpd.py
msgcomm             spawn-fcgi
msgconv             splain
msgen               stream
msgexec             thumbnail
msgfilter           tiff2bw
msgfmt              tiff2pdf
msggrep             tiff2ps
msginit             tiff2rgba
msgmerge            tiffcmp
msgunfmt            tiffcp
msguniq             tiffcrop
msql2mysql          tiffdither
my_print_defaults       tiffdump
myisam_ftdump           tiffinfo
myisamchk           tiffmedian
myisamlog           tiffset
myisampack          tiffsplit
mysql               type1afm
mysql_client_test       uconv
mysql_config            unix-lpr.sh
mysql_convert_table_format  wftopfa
mysql_find_rows         wrjpgcom
mysql_fix_extensions        xgettext
mysql_plugin            xml2-config
mysql_secure_installation   xmlcatalog
mysql_setpermission     xmllint
mysql_tzinfo_to_sql     xmlwf
mysql_upgrade           xslt-config
mysql_waitpid           xsltproc
mysql_zap           xsubpp
mysqlaccess         yaz-asncomp
mysqlaccess.conf        yaz-client
mysqladmin          yaz-config
mysqlauditadmin         yaz-iconv
mysqlauditgrep          yaz-icu
mysqlbinlog         yaz-illclient
mysqlbug            yaz-json-parse
mysqlcheck          yaz-marcdump
mysqld              yaz-ztest
mysqld_multi            zipdetails
mysqld_safe         zoomsh
Marimo-no-MacBook-Air:bin marimo$ show databases
-bash: show: command not found
Marimo-no-MacBook-Air:bin marimo$ show databases;
-bash: show: command not found
Marimo-no-MacBook-Air:bin marimo$ cd /Applications/MAMP/Library/bin/
Marimo-no-MacBook-Air:bin marimo$ /mysql -u root -p
-bash: /mysql: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 10
Server version: 5.5.38 Source distribution

Copyright (c) 2000, 2014, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| Cafe               |
| Englishwords       |
| Englishwords2      |
| mini_bbs           |
| myfavoriteshop     |
| mysql              |
| ourfavoriteshop    |
| ourfavoriteshop1   |
| performance_schema |
| slj                |
| tennis             |
| test01             |
| test01-index       |
+--------------------+
14 rows in set (0.01 sec)

mysql> use slj
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------+
| Tables_in_slj |
+---------------+
| account       |
| article       |
| color_master  |
+---------------+
3 rows in set (0.00 sec)

mysql> desc account;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| user_id   | varchar(10) | NO   | PRI | NULL    |       |
| user_name | varchar(30) | NO   |     | NULL    |       |
| user_pass | char(8)     | NO   |     | NULL    |       |
| email     | varchar(30) | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> desc article;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| article_id  | int(11)      | NO   | PRI | NULL    | auto_increment |
| create_date | datetime     | NO   |     | NULL    |                |
| name        | varchar(30)  | YES  |     | NULL    |                |
| email       | varchar(30)  | YES  |     | NULL    |                |
| title       | varchar(50)  | YES  |     | NULL    |                |
| text        | varchar(100) | NO   |     | NULL    |                |
| color_cd    | char(1)      | NO   |     | 0       |                |
| del_flg     | char(1)      | NO   |     | 0       |                |
+-------------+--------------+------+-----+---------+----------------+
8 rows in set (0.01 sec)

mysql> desc color_master;
+----------+---------+------+-----+---------+-------+
| Field    | Type    | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+-------+
| color_cd | char(1) | NO   | PRI | NULL    |       |
| color_nm | char(6) | NO   |     | NULL    |       |
+----------+---------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> use Cafe
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_cafe |
+----------------+
| Cafe_data      |
| Members        |
+----------------+
2 rows in set (0.00 sec)

mysql> desc Cafe_data
    -> desc Cafe_data;
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 'desc Cafe_data' at line 2
mysql> desc Cafe_data
    -> 
    -> desc Cafe_data;
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 'desc Cafe_data' at line 3
mysql> desc Cafe_data;
+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| CafeEnglish      | varchar(100) | NO   |     | NULL    |                |
| CafeJapanese     | varchar(100) | NO   |     | NULL    |                |
| CafeSignificance | varchar(100) | YES  |     | NULL    |                |
| ID               | int(100)     | NO   | PRI | NULL    | auto_increment |
+------------------+--------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

mysql> desc Members;
+----------+--------------+------+-----+-------------------+-----------------------------+
| Field    | Type         | Null | Key | Default           | Extra                       |
+----------+--------------+------+-----+-------------------+-----------------------------+
| id       | int(11)      | NO   | PRI | NULL              | auto_increment              |
| name     | varchar(255) | NO   |     | NULL              |                             |
| email    | varchar(255) | NO   |     | NULL              |                             |
| password | varchar(100) | NO   |     | NULL              |                             |
| picture  | varchar(255) | NO   |     | NULL              |                             |
| created  | datetime     | NO   |     | NULL              |                             |
| modified | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+----------+--------------+------+-----+-------------------+-----------------------------+
7 rows in set (0.01 sec)

mysql> 
  [復元日時 2016/10/26 23:27:18]
Last login: Wed Oct 26 23:27:02 on console
Restored session: 2016 10月21日 金曜日 00時48分17秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/10/27 23:21:21]
Last login: Thu Oct 27 23:21:10 on console
Restored session: 2016 10月27日 木曜日 00時38分28秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/10/29 0:58:02]
Last login: Sat Oct 29 00:57:50 on console
Restored session: 2016 10月27日 木曜日 23時37分14秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/01 0:15:14]
Last login: Tue Nov  1 00:14:51 on console
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/01 23:53:25]
Last login: Tue Nov  1 23:53:10 on console
Restored session: 2016 11 1 火曜日 01時02分44秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/06 23:12:57]
Last login: Sun Nov  6 23:12:43 on console
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/13 4:07:57]
Last login: Sun Nov 13 04:07:43 on console
Restored session: 2016 11 6 日曜日 23時28分51秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/15 0:00:52]
Last login: Tue Nov 15 00:00:42 on console
Restored session: 2016 11月13日 日曜日 04時08分43秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/16 23:21:59]
Last login: Wed Nov 16 23:21:49 on console
Restored session: 2016 11月15日 火曜日 00時01分07秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ heroku login
-bash: heroku: command not found
Marimo-no-MacBook-Air:bin marimo$ heroku login;
-bash: heroku: command not found
Marimo-no-MacBook-Air:bin marimo$ cd applications
-bash: cd: applications: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ ls
2to3                mysqldbcompare
Magick++-config         mysqldbcopy
Magick-config           mysqldbexport
MagickCore-config       mysqldbimport
MagickWand-config       mysqldiff
Wand-config         mysqldiskusage
a2p             mysqldump
ab              mysqldumpslow
animate             mysqlfailover
apachectl           mysqlfrm
apxs                mysqlhotcopy
autopoint           mysqlimport
bmp2tiff            mysqlindexcheck
c2ph                mysqlmetagrep
cgi-fcgi            mysqlprocgrep
checkgid            mysqlreplicate
cjpeg               mysqlrpladmin
compare             mysqlrplcheck
composite           mysqlrplshow
config_data         mysqlserverclone
conjure             mysqlserverinfo
convert             mysqlshow
corelist            mysqlslap
cpan                mysqltest
curl                mysqluc
curl-config         mysqluserclone
dbilogstrip         ngettext
dbiprof             nginxctl
dbiproxy            pal2rgb
dbmmanage           pcre-config
derb                pcregrep
display             pcretest
djpeg               pdf2dsc
dvipdf              pdf2ps
enc2xs              perl
envsubst            perl5.20.0
envvars-std_            perlbug
envvars_            perldoc
eps2eps             perlivp
fax2ps              perlthanks
fax2tiff            perror
find2perl           pf2afm
font2c              pfbtopfa
freetype-config         phpunit
genbrk              phpunit.phar
gencfu              piconv
gencnval            pkgdata
gendict             pl2pm
genrb               png-fix-itxt
gettext             pngfix
gettext.sh          pod2html
gettextize          pod2man
gif2tiff            pod2text
gs              pod2usage
gsbj                podchecker
gsdj                podselect
gsdj500             pphs
gslj                ppm2tiff
gslp                printafm
gsnd                prove
h2ph                ps2ascii
h2xs                ps2epsi
htcacheclean            ps2pdf
htdbm               ps2pdf12
htdigest            ps2pdf13
htpasswd            ps2pdf14
httpd               ps2pdfwr
httxt2dbm           ps2ps
iconv               ps2ps2
icu-config          psed
icuinfo             pstruct
identify            ptar
idle                ptardiff
idn             ptargrep
import              pydoc
innochecksum            python
instmodsh           python-config
jpegtran            python2
json_pp             python2-config
libmcrypt-config        python2.7
libnetcfg           python2.7-config
libpng-config           ras2tiff
libpng16-config         raw2tiff
libtool             rdjpgcom
libtoolize          recode-sr-latin
logresolve          replace
lprsetup.sh         resolve_stack_dump
makeconv            resolveip
mod_python          rgb2ycbcr
mogrify             rotatelogs
montage             s2p
mp2bug              sabcmd
msgattrib           sablot-config
msgcat              shasum
msgcmp              smtpd.py
msgcomm             spawn-fcgi
msgconv             splain
msgen               stream
msgexec             thumbnail
msgfilter           tiff2bw
msgfmt              tiff2pdf
msggrep             tiff2ps
msginit             tiff2rgba
msgmerge            tiffcmp
msgunfmt            tiffcp
msguniq             tiffcrop
msql2mysql          tiffdither
my_print_defaults       tiffdump
myisam_ftdump           tiffinfo
myisamchk           tiffmedian
myisamlog           tiffset
myisampack          tiffsplit
mysql               type1afm
mysql_client_test       uconv
mysql_config            unix-lpr.sh
mysql_convert_table_format  wftopfa
mysql_find_rows         wrjpgcom
mysql_fix_extensions        xgettext
mysql_plugin            xml2-config
mysql_secure_installation   xmlcatalog
mysql_setpermission     xmllint
mysql_tzinfo_to_sql     xmlwf
mysql_upgrade           xslt-config
mysql_waitpid           xsltproc
mysql_zap           xsubpp
mysqlaccess         yaz-asncomp
mysqlaccess.conf        yaz-client
mysqladmin          yaz-config
mysqlauditadmin         yaz-iconv
mysqlauditgrep          yaz-icu
mysqlbinlog         yaz-illclient
mysqlbug            yaz-json-parse
mysqlcheck          yaz-marcdump
mysqld              yaz-ztest
mysqld_multi            zipdetails
mysqld_safe         zoomsh
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/17 22:48:49]
Last login: Thu Nov 17 22:48:39 on console
Restored session: 2016 11月17日 木曜日 00時25分04秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/11/25 0:17:22]
Last login: Fri Nov 25 00:17:11 on console
Restored session: 2016 11月17日 木曜日 22時49分00秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2016/12/01 22:40:49]
Last login: Thu Dec  1 22:40:39 on console
Restored session: 2016 11月25日 金曜日 00時32分57秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2017/03/19 5:10:06]
Last login: Sun Mar 19 04:58:43 on console
Restored session: 2016 12 2 金曜日 00時50分18秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ mysql -u root -p
-bash: mysql: command not found
Marimo-no-MacBook-Air:bin marimo$ cd /Applications/MAMP/Library/bin/
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 15
Server version: 5.5.38 Source distribution

Copyright (c) 2000, 2014, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| Cafe               |
| Englishwords       |
| Englishwords2      |
| mini_bbs           |
| myfavoriteshop     |
| mysql              |
| ourfavoriteshop    |
| ourfavoriteshop1   |
| performance_schema |
| slj                |
| tennis             |
| test01             |
| test01-index       |
+--------------------+
14 rows in set (0.00 sec)

mysql> show tables from mysql;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
24 rows in set (0.00 sec)

mysql> create table words(id int auto_increment primary key,word varchar(100),se 
    -> nse varchar(250),memo varchar(250));
ERROR 1046 (3D000): No database selected
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| Cafe               |
| Englishwords       |
| Englishwords2      |
| mini_bbs           |
| myfavoriteshop     |
| mysql              |
| ourfavoriteshop    |
| ourfavoriteshop1   |
| performance_schema |
| slj                |
| tennis             |
| test01             |
| test01-index       |
+--------------------+
14 rows in set (0.00 sec)

mysql> show fields from test01;
ERROR 1146 (42S02): Table 'mysql.test01' doesn't exist
mysql> show fields from test01
    -> use test01;
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 'use test01' at line 2
mysql> show fields from test01 use test01;
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 'use test01' at line 1
mysql> use test01;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show fields from test01 use test01;
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 'use test01' at line 1
mysql> showt tables from test01;
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 'showt tables from test01' at line 1
mysql> use test01;
Database changed
mysql> show tables from test01;
+------------------+
| Tables_in_test01 |
+------------------+
| items            |
| my_items         |
+------------------+
2 rows in set (0.00 sec)

mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create database words;
Query OK, 1 row affected (0.01 sec)

mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> use words;
Database changed
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> createe table words(id int auto_increment primary key,word varchar(100),sense varchar(250),memo varchar(250));
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 'createe table words(id int auto_increment primary key,word varchar(100),sense va' at line 1
mysql> createe table words(id int auto_increment primary key,word varchar(100),sense varchar(250),memo varchar(250);
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 'createe table words(id int auto_increment primary key,word varchar(100),sense va' at line 1
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create table words (id int auto_increment primary key,word varchar(100),sense varchar(250),memo varchar(250));
Query OK, 0 rows affected (0.02 sec)

mysql> insert into words values(null,'A','B','C');
Query OK, 1 row affected (0.01 sec)

mysql> select * from word;
ERROR 1146 (42S02): Table 'words.word' doesn't exist
mysql> select * from words;
+----+------+-------+------+
| id | word | sense | memo |
+----+------+-------+------+
|  1 | A    | B     | C    |
+----+------+-------+------+
1 row in set (0.00 sec)

mysql> 
  [復元日時 2017/03/20 3:55:09]
Last login: Mon Mar 20 03:54:59 on console
Restored session: 2017 3月19日 日曜日 05時51分35秒 JST
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$ 
  [復元日時 2017/03/20 14:14:05]
Last login: Mon Mar 20 13:48:51 on console
-bash: 0_29-b11-402.jdk/Contents/Home: No such file or directory
Marimo-no-MacBook-Air:bin marimo$  version-
Could not open input file: version-
Marimo-no-MacBook-Air:bin marimo$ php -v
PHP 5.5.36 (cli) (built: May 29 2016 01:07:06) 
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies
Marimo-no-MacBook-Air:bin marimo$ mysql -u root -p
-bash: mysql: command not found
Marimo-no-MacBook-Air:bin marimo$ cd /Applications/MAMP/Library/bin/
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 7
Server version: 5.5.38 Source distribution

Copyright (c) 2000, 2014, 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> SHOW VARIABLES LIKE 'version%'
    -> SHOW VARIABLES LIKE 'version%';
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 'SHOW VARIABLES LIKE 'version%'' at line 2
mysql> SHOW VARIABLES LIKE 'version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 5.5.38              |
| version_comment         | Source distribution |
| version_compile_machine | i386                |
| version_compile_os      | osx10.6             |
+-------------------------+---------------------+
4 rows in set (0.01 sec)

mysql> ^DBye
Marimo-no-MacBook-Air:bin marimo$ mysql -h nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306  -u nono -p 
-bash: mysql: command not found
Marimo-no-MacBook-Air:bin marimo$ ./my
my_print_defaults           mysqld_safe
myisam_ftdump               mysqldbcompare
myisamchk                   mysqldbcopy
myisamlog                   mysqldbexport
myisampack                  mysqldbimport
mysql                       mysqldiff
mysql_client_test           mysqldiskusage
mysql_config                mysqldump
mysql_convert_table_format  mysqldumpslow
mysql_find_rows             mysqlfailover
mysql_fix_extensions        mysqlfrm
mysql_plugin                mysqlhotcopy
mysql_secure_installation   mysqlimport
mysql_setpermission         mysqlindexcheck
mysql_tzinfo_to_sql         mysqlmetagrep
mysql_upgrade               mysqlprocgrep
mysql_waitpid               mysqlreplicate
mysql_zap                   mysqlrpladmin
mysqlaccess                 mysqlrplcheck
mysqlaccess.conf            mysqlrplshow
mysqladmin                  mysqlserverclone
mysqlauditadmin             mysqlserverinfo
mysqlauditgrep              mysqlshow
Marimo-no-MacBook-Air:bin marimo$ ./mysql
mysql                       mysqldbcopy
mysql_client_test           mysqldbexport
mysql_config                mysqldbimport
mysql_convert_table_format  mysqldiff
mysql_find_rows             mysqldiskusage
mysql_fix_extensions        mysqldump
mysql_plugin                mysqldumpslow
mysql_secure_installation   mysqlfailover
mysql_setpermission         mysqlfrm
mysql_tzinfo_to_sql         mysqlhotcopy
mysql_upgrade               mysqlimport
mysql_waitpid               mysqlindexcheck
mysql_zap                   mysqlmetagrep
mysqlaccess                 mysqlprocgrep
mysqlaccess.conf            mysqlreplicate
mysqladmin                  mysqlrpladmin
mysqlauditadmin             mysqlrplcheck
mysqlauditgrep              mysqlrplshow
mysqlbinlog                 mysqlserverclone
mysqlbug                    mysqlserverinfo
mysqlcheck                  mysqlshow
mysqld                      mysqlslap
mysqld_multi                mysqltest
Marimo-no-MacBook-Air:bin marimo$ ./mysql -h nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306  -u nono -p
Enter password: 
ERROR 2005 (HY000): Unknown MySQL server host 'nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306' (0)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -h nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com -u nono -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'nono'@'106.171.74.98' (using password: YES)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -h nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306  -u nono -P 3306  -p 
Enter password: 
ERROR 2005 (HY000): Unknown MySQL server host 'nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306' (0)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -h nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306  -u nono  -p 
Enter password: 
ERROR 2005 (HY000): Unknown MySQL server host 'nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com:3306' (0)
Marimo-no-MacBook-Air:bin marimo$ ./mysql -h nonotest.cllelguzpkss.us-west-2.rds.amazonaws.com  -u nono -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 10
Server version: 5.5.53-log Source distribution

Copyright (c) 2000, 2014, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| innodb             |
| mysql              |
| performance_schema |
| word               |
+--------------------+
5 rows in set (0.13 sec)

mysql> use word;
Database changed
mysql> create table words(id int auto_increment primary key,word varchar(100),se 
    -> nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 2
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250));
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 'nse varchar(250),memo varchar(250))' at line 1
mysql> create table words(id int auto_increment primary key,word varchar(100),se nse varchar(250),memo varchar(250)mysql> create table words(id int auto_increment primary key,word varchar(100),se
    -> create table words(id int auto_increment primary key,word varchar(100),sense varchar(250),memo varchar(250));
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 'create table words(id int auto_increment primary key,word varchar(100),sense var' at line 2
mysql> create table words(id int auto_increment primary key,word varchar(100),sense varchar(250),memo varchar(250));
Query OK, 0 rows affected (0.15 sec)

mysql> insert into words(null,'A','B','C');
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 'null,'A','B','C')' at line 1
mysql> insert into product values(null, 'A','B','C');
ERROR 1146 (42S02): Table 'word.product' doesn't exist
mysql> insert into words values(null, 'A','B','C');
Query OK, 1 row affected (0.14 sec)

mysql> select * from words;
+----+------+-------+------+
| id | word | sense | memo |
+----+------+-------+------+
|  1 | A    | B     | C    |
+----+------+-------+------+
1 row in set (0.13 sec)

mysql> grant select,insert,update,delete on word.* to worduser@172.31.19.131 identified by 'hiwoSh1o';
Query OK, 0 rows affected (0.13 sec)

mysql> 
[紹介元] PHPタグが付けられた新着投稿 – Qiita DB memo

関連記事