View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-7) was last changed on 19-Jun-2017 11:53 by BlakeMcBride

This page was created on 14-Apr-2016 14:22 by BlakeMcBride

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 changed one line
!! MySQL Database
!!! MySQL Database
At line 10 changed one line
mysql -u USER -pPASSWORD DBNAME
mysql -h <host> -u <USER> -p<PASSWORD> <DBNAME>
At line 12 changed one line
! mysql commands
!! mysql commands
At line 16 added 2 lines
source <filename>
At line 20 added 2 lines
use <database>
At line 20 changed one line
use DBNAME;
use <DBNAME>;
At line 24 changed one line
drop database ABC;
drop database <dbname>;
At line 26 changed one line
create database XYZ;
create database <dbname>;
describe <table>;
show create table <table>;
select * from <table> LIMIT N;
!!Data Types
| TINYINT | 1
| SMALLINT | 2
| MEDIUMINT | 3
| INT | 4
| BIGINT | 8
| FLOAT | 4
| DOUBLE | 8
| DATE |
| TIME |
| DATETIME |
| TIMESTAMP | UTC
| CHAR |
| VARCHAR |
| BLOB | binary
| TEXT | text
!!CSV Export
{{{mysql -h HHHHH -u UUUUU -pPPPPP -A -B \
-e "select …." DBNAME \
| sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" >file.csv}}}
Version Date Modified Size Author Changes ... Change note
7 19-Jun-2017 11:53 0.86 kB BlakeMcBride to previous
6 03-Jun-2016 14:23 0.48 kB BlakeMcBride to previous | to last
5 03-Jun-2016 14:20 0.444 kB BlakeMcBride to previous | to last
4 03-Jun-2016 14:19 0.43 kB BlakeMcBride to previous | to last
3 14-Apr-2016 17:53 0.371 kB BlakeMcBride to previous | to last
2 14-Apr-2016 14:23 0.322 kB BlakeMcBride to previous | to last
1 14-Apr-2016 14:22 0.32 kB BlakeMcBride to last
« This page (revision-7) was last changed on 19-Jun-2017 11:53 by BlakeMcBride