ื ืคืชืจื”: ืขืจืš ื—ื•ืชืžืช ื”ื–ืžืŸ ื”ืžื•ื’ื“ืจ ื›ื‘ืจื™ืจืช ืžื—ื“ืœ ืœื”ื™ื•ืช ื—ื•ืชืžืช ื”ื–ืžืŸ ื”ื ื•ื›ื—ื™ืช

ื‘ืขื•ืœื ืฉืœ ืžืกื“ื™ ื ืชื•ื ื™ื ื•ืžื ื™ืคื•ืœืฆื™ื” ืฉืœ ื ืชื•ื ื™ื, ื—ื•ืชืžื•ืช ื–ืžืŸ ื”ืŸ ื”ื›ืจื—ื™ื•ืช. ื”ื ืžืกืคืงื™ื ืชื™ืขื•ื“ ืžื“ื•ื™ืง ืฉืœ ื™ืฆื™ืจืช ื”ื ืชื•ื ื™ื ืื• ื”ืฉื™ื ื•ื™ ื‘ืžืกื“ ื”ื ืชื•ื ื™ื. ื‘-SQL, ืœืขืชื™ื ืงืจื•ื‘ื•ืช ื™ืฉ ืฆื•ืจืš ืœื”ื’ื“ื™ืจ ืขืจืš ื—ื•ืชืžืช ื–ืžืŸ ื‘ืจื™ืจืช ืžื—ื“ืœ ืœื”ื™ื•ืช ื—ื•ืชืžืช ื”ื–ืžืŸ ื”ื ื•ื›ื—ื™ืช. ื–ื” ื”ื•ืคืš ืœื”ื™ื•ืช ืฉื™ืžื•ืฉื™ ื‘ืžื™ื•ื—ื“ ื‘ืžืงืจื™ื ืฉื‘ื”ื ืื ื—ื ื• ืฆืจื™ื›ื™ื ืœืขืงื•ื‘ ืื—ืจ ื”ื–ืžืŸ ืฉื‘ื• ื”ืชืจื—ืฉ ืื™ืจื•ืข ืžืกื•ื™ื ืื• ื‘ื›ืœ ืžืงืจื”, ืฉื‘ื”ื ื ื“ืจืฉ ื–ืžืŸ ื‘ืจื™ืจืช ืžื—ื“ืœ. ืžืืžืจ ื–ื” ื™ืฉืคื•ืš ืื•ืจ ืขืœ ื”ื™ื‘ื˜ ื–ื” ืฉืœ ืชื›ื ื•ืช SQL.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: group_concat ื ื‘ื“ืœ

Group_concat ื ื‘ื“ืœ ื”ื™ื ืคื•ื ืงืฆื™ื” ืจื‘ืช ืขื•ืฆืžื” ื‘-SQL, ื”ืžืืคืฉืจืช ืœืš ืœืฉืœื‘ ืžืกืคืจ ืขืจื›ื™ื ืžืงื‘ื•ืฆืช ืฉื•ืจื•ืช ืœืžื—ืจื•ื–ืช ืื—ืช ื•ืžื•ืคืจื“ืช. ืฉืื™ืœืชื•ืช ื‘ืžืกื“ื™ ื ืชื•ื ื™ื ื“ื•ืจืฉื•ืช ืžืžืš ืœืขืชื™ื ืงืจื•ื‘ื•ืช ืœืงื‘ืœ ืชื•ืฆืื•ืช ื‘ืจื•ืจื•ืช, ื•-group_concat distinct ืขื•ื–ืจ ืœืš ืœื”ืฉื™ื’ ื–ืืช ื‘ืฆื•ืจื” ืžืขื•ืฆื‘ืช ื‘ืฆื•ืจื” ืžืกื•ื“ืจืช. ื”ื‘ืขื™ื” ื”ืื•ืคื™ื™ื ื™ืช ืฉืจื•ื‘ ื”ืžืคืชื—ื™ื ื ืชืงืœื™ื ื‘ื” ื”ื™ื ืงื‘ืœืช ืขืจืš ื‘ื•ื“ื“ ืžืงื‘ื•ืฆืช ืขืจื›ื™ื ืื• ืฉื™ืœื•ื‘ ื›ืœ ื”ืขืจื›ื™ื ื”ื™ื™ื—ื•ื“ื™ื™ื ื‘ืขืžื•ื“ื” ืื—ืช ืœื”ืคื ื™ื” ืงืœื” ื™ื•ืชืจ.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: ื”ืชืงืŸ mysql raspberry pi

ื”ืชืงื ืช MySQL ื‘-Raspberry Pi ื”ื•ื ืชื”ืœื™ืš ื—ื™ื•ื ื™, ื‘ืžื™ื•ื—ื“ ืื ืืชื” ืžืงื•ื•ื” ืœื”ืฉืชืžืฉ ื‘-Pi ืฉืœืš ื›ืฉืจืช ืื• ืœื ื”ืœ ื ืชื•ื ื™ื ื•ืžืกื“ื™ ื ืชื•ื ื™ื. ื–ื” ืื•ืœื™ ื ืฉืžืข ื›ืžื• ื—ื‘ืœ ืžื•ืจื›ื‘ ืœืœื›ืช ื‘ื”ืชื—ืœื”, ืื‘ืœ ืขื ื‘ื™ืฆื•ืข ื–ื”ื™ืจ ืฆืขื“ ืื—ืจ ืฆืขื“, ื–ื” ื™ื›ื•ืœ ืœื”ืชื‘ืฆืข ื“ื™ ื‘ืงืœื•ืช. ืžืืžืจ ื–ื” ื™ื“ืจื™ืš ืื•ืชืš ื‘ืชื”ืœื™ืš ื”ื”ืชืงื ื” ืฉืœ SQL ื‘-Raspberry Pi ื•ื™ืกื‘ื™ืจ ืืช ื”ืคื•ื ืงืฆื™ื•ื ืœื™ื•ืช ืฉืœ ื”ืกืคืจื™ื•ืช ื•ื”ืงื•ื“ื™ื ื”ื“ืจื•ืฉื™ื ืœื—ื•ื•ื™ื™ืช ื”ืชืงื ื” ื—ืœืงื”.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: ื”ืคืกืงืช ืžื“ื™ื ื™ื•ืช ืกื™ืกืžืื•ืช

ืžื“ื™ื ื™ื•ืช ืกื™ืกืžืื•ืช ืžืฉื—ืงืช ืชืคืงื™ื“ ืžืจื›ื–ื™ ื‘ื”ื‘ื˜ื—ืช ืื‘ื˜ื—ืช ื ืชื•ื ื™ ื”ืžืฉืชืžืฉ, ื›ื•ืœืœ ืžื ื™ืขืช ื’ื™ืฉื” ื‘ืœืชื™ ืžื•ืจืฉื™ืช ื•ื”ื’ื ื” ืขืœ ืžื™ื“ืข ืจื’ื™ืฉ. ืื›ื™ืคืช ืžื“ื™ื ื™ื•ืช ืกื™ืกืžืื•ืช ื—ื–ืงื” ื”ื™ื ืื™ื ื˜ื’ืจืœื™ืช ืœืฉืžื™ืจื” ืขืœ ืฉืœืžื•ืช, ืกื•ื“ื™ื•ืช ื•ื–ืžื™ื ื•ืช ื”ื ืชื•ื ื™ื ื”ืžืื•ื—ืกื ื™ื ื‘ืžืขืจื›ืช ืžื™ื“ืข. ืขื ื–ืืช, ื ื™ื”ื•ืœ ื•ืื›ื™ืคืช ืžื“ื™ื ื™ื•ืช ืกื™ืกืžืื•ืช ืขืฉื•ื™ื” ืœืคืขืžื™ื ืœื”ื•ื•ืช ืืชื’ืจ. ืžืืžืจ ื–ื” ืžืฆื™ื’ ืคืชืจื•ืŸ ืœื‘ืขื™ื” ืžื ืงื•ื“ืช ืžื‘ื˜ ืฉืœ ืคื™ืชื•ื— SQL, ื•ืžืกืคืง ืžื“ืจื™ืš ืฉืœื‘ ืื—ืจ ืฉืœื‘ ื›ื™ืฆื“ ืœื ื”ืœ ื•ืœืื›ื•ืฃ ืžื“ื™ื ื™ื•ืช ืกื™ืกืžืื•ืช ื•ืงื•ื“ ื”-SQL ื”ื“ืจื•ืฉ ื”ืžืขื•ืจื‘ ื‘ื•. ื‘ื ื•ืกืฃ, ื ืฆืœื•ืœ ืขืžื•ืง ืœืชื•ืš ืคื•ื ืงืฆื™ื•ืช ื•ืกืคืจื™ื•ืช SQL ื—ืฉื•ื‘ื•ืช ื”ืงืฉื•ืจื•ืช ืœื ื™ื”ื•ืœ ืžื“ื™ื ื™ื•ืช ืกื™ืกืžืื•ืช.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: ืฉื™ื ื•ื™ ืกื™ืกืžืช ืžืฉืชืžืฉ

ื‘ื˜ื—, ืื ื ืžืฆื ืืช ื”ืžืืžืจ ื”ืžืชื•ืืจ ืœื”ืœืŸ:

ืฉื™ื ื•ื™ ืกื™ืกืžืช ืžืฉืชืžืฉ ื‘-SQL ื”ื™ื ืžืฉื™ืžื” ืจื•ื•ื—ืช ืขื‘ื•ืจ ืžื ื”ืœื™ ืžืขืจื›ืช ื•ืžืคืชื—ื™ื ื›ืื—ื“. ื—ื™ื•ื ื™ ืœืขื“ื›ืŸ ื•ืœื—ื–ืง ื‘ืื•ืคืŸ ืฉื•ื˜ืฃ ืืžืฆืขื™ ืื‘ื˜ื—ื” ื”ืžื’ื ื™ื ืขืœ ื ืชื•ื ื™ ื”ืžืฉืชืžืฉ, ืฉืื—ื“ ืžื”ื ื›ื•ืœืœ ืขื“ื›ื•ืŸ ืชื›ื•ืฃ ืฉืœ ืกื™ืกืžืื•ืช. ืกืงืจื™ืคื˜ื™ื ืฉืœ SQL ืžืกืคืงื™ื ื™ื›ื•ืœืช ืœื”ืชืžื•ื“ื“ ืขื ืžืฉื™ืžื•ืช ืืœื” ื‘ื™ืขื™ืœื•ืช.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: brew install mysql workbench

ื‘ื˜ื—, ืื ื™ ืืกืคืง ืกืงื™ืจื” ื›ืœืœื™ืช ืฉืœ ื”ื ื•ืฉื.

MySQL Workbench ื”ื•ื ื›ืœื™ ื—ื–ื•ืชื™ ืžืื•ื—ื“ ืœืืจื›ื™ื˜ืงื˜ื™ื ืฉืœ ืžืกื“ื™ ื ืชื•ื ื™ื, ืžืคืชื—ื™ื ื•-DBAs. ื”ื•ื ืžืกืคืง ืžื•ื“ืœื™ื ืฉืœ ื ืชื•ื ื™ื, ืคื™ืชื•ื— SQL ื•ื›ืœื™ ื ื™ื”ื•ืœ ืžืงื™ืคื™ื ืขื‘ื•ืจ ืชืฆื•ืจืช ืฉืจืช, ื ื™ื”ื•ืœ ืžืฉืชืžืฉื™ื, ื’ื™ื‘ื•ื™ ื•ืขื•ื“ ื”ืจื‘ื” ื™ื•ืชืจ.

ื”ืชืงื ืช MySQL Workbench ื‘ืžืขืจื›ืช ืฉืœืš ื™ื›ื•ืœื” ืœืคืขืžื™ื ืœื”ื™ื•ืช ืืชื’ืจ, ื‘ืžื™ื•ื—ื“ ืื ืื™ื ืš ืžืชื•ืจื’ืœ ื”ื™ื˜ื‘ ื‘ืฉื™ืžื•ืฉ ื‘ืฉื•ืจืช ื”ืคืงื•ื“ื” ืื• ื‘ืžืกื•ืฃ. ืื‘ืœ, ื‘ืขื–ืจืช Homebrew - ืžืขืจื›ืช ื ื™ื”ื•ืœ ื—ื‘ื™ืœื•ืช ืชื•ื›ื ื” ื‘ืงื•ื“ ืคืชื•ื— - ื”ืชื”ืœื™ืš ื”ื•ืคืš ืœื”ืจื‘ื” ื™ื•ืชืจ ืงืœ.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: ื”ืกืจ ืืช ื”ื”ืชืงื ื” ืฉืœ mysql ื‘-ubuntu

ื”ืกืจืช ื”ื”ืชืงื ื” ืฉืœ MySQL ื‘ืื•ื‘ื•ื ื˜ื• ื™ื›ื•ืœื” ืœื”ื™ื•ืช ืžืฉื™ืžื” ืžื›ืจืขืช ื›ืืฉืจ ืืชื” ืžื—ืคืฉ ืœื”ืชืงื™ืŸ ื’ืจืกื” ื—ื“ืฉื”, ืœื”ืกื™ืจ ื”ืชืงื ืช MySQL ืคื’ื•ืžื”, ืื• ืคืฉื•ื˜ ืœืคื ื•ืช ื›ืžื” ืžืฉืื‘ื™ ืžืขืจื›ืช. ื”ื™ื“ื™ืขื” ื›ื™ืฆื“ ืœืขืฉื•ืช ื–ืืช ื‘ืฆื•ืจื” ืžื“ื•ื™ืงืช ื•ื™ืขื™ืœื” ื—ื•ืกื›ืช ืœืš ืขื•ื’ืžืช ื ืคืฉ ืจื‘ื” ื•ืžื‘ื˜ื™ื—ื” ืฉืœื ื™ื™ืฉืืจื• ืฉืืจื™ื•ืช ืฉืœ ืงื‘ืฆื™ื ืฉืขืœื•ืœื™ื ืœื”ืคืจื™ืข ืœื”ืชืงื ื•ืช ืขืชื™ื“ื™ื•ืช.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: mysql_secure_installation

MySQL ืขื•ืžื“ืช ื›ืื—ืช ืžืžืขืจื›ื•ืช ื ื™ื”ื•ืœ ืžืกื“ื™ ื”ื ืชื•ื ื™ื ื”ื—ื–ืงื•ืช ื•ื”ืคื•ืคื•ืœืจื™ื•ืช ื‘ื™ื•ืชืจ. ื”ื•ื ืžืฉืžืฉ ื›ืื‘ืŸ ื™ืกื•ื“ ืœืฉืคืข ืฉืœ ื™ื™ืฉื•ืžื™ื ืžื‘ื•ืกืกื™ ืื™ื ื˜ืจื ื˜, ื‘ืฉืœ ืื•ืคื™ ื”ืงื•ื“ ื”ืคืชื•ื— ื•ืชืื™ืžื•ืชื• ืœืฉืคื•ืช ืชื›ื ื•ืช ืฉื•ื ื•ืช. ื”ื™ื‘ื˜ ืžืจื›ื–ื™ ื‘ืขื‘ื•ื“ื” ืขื MySQL ื›ืจื•ืš ื‘ื”ืชืงื ื” ื”ืžืื•ื‘ื˜ื—ืช ืฉืœื•, ืฉื›ื•ืชืจืชื” 'mysql_secure_installation'. ืกืงืจื™ืคื˜ ื–ื” ืžืืคืฉืจ ืฉื›ื‘ืช ืื‘ื˜ื—ื” ื’ื‘ื•ื”ื” ื™ื•ืชืจ, ื•ืžืกืคืง ืฉื“ืจื” ืœื”ืกืจื” ืฉืœ ืžืฉืชืžืฉื™ื ืื ื•ื ื™ืžื™ื™ื, ื›ื ื™ืกื•ืช ืฉื•ืจืฉ ื•ืžืกื“ื™ ื ืชื•ื ื™ื ืฉืœ ื‘ื“ื™ืงื•ืช, ื•ืžืคื—ื™ืช ื ื™ืฆื•ืœ ืคื•ื˜ื ืฆื™ืืœื™ ืžืžืฉืชืžืฉื™ื ืžืจื•ืฉืขื™ื.

ืœืžื™ื“ืข ื ื•ืกืฃ

ื ืคืชืจื”: ื”ืฆื’ ืžืฉืชื ื™ื

ื—ืฉื•ื‘ ืœื”ื‘ื™ืŸ ื›ื™ืฆื“ ืœื”ืฉืชืžืฉ ื‘ืคืงื•ื“ื” "SHOW VARIABLES" ื‘-SQL ืžื›ื™ื•ื•ืŸ ืฉื”ื™ื ื™ื›ื•ืœื” ืœืกืคืง ืœื ื• ืฉืคืข ืฉืœ ืžื™ื“ืข ืขืœ ื”ืชืฆื•ืจื•ืช ืฉืœ ืฉืจืช MySQL ืฉืœื ื•. ืคืงื•ื“ื” ืจื‘-ืชื›ืœื™ืชื™ืช ื–ื• ืžืฆื™ืขื” ืœื ื• ื“ืจืš ืจื‘ืช ืขื•ืฆืžื” ืœืืžืช ื•ืœื”ืชืื™ื ืžืฉืชื ื™ื ืฉื™ื›ื•ืœื™ื ืœื”ืฉืคื™ืข ืขืœ ื”ื‘ื™ืฆื•ืขื™ื ื•ื”ืชืคืงื•ื“ ืฉืœ ื”ืคืขื•ืœื•ืช ืฉืœื ื•.

ื ื™ื”ื•ืœ ืžืฉืชื ื™ื ื‘ื™ืขื™ืœื•ืช ื™ื›ื•ืœ ืœืฉืคืจ ืžืื•ื“ ืืช ื”ื™ืขื™ืœื•ืช ืฉืœ ื”ื˜ื™ืคื•ืœ ื‘ื ืชื•ื ื™ื ืฉืœื ื•, ื•ื‘ืกื•ืคื• ืฉืœ ื“ื‘ืจ ืœื”ื•ื‘ื™ืœ ืœืชืคื•ืงื” ื˜ื•ื‘ื” ื™ื•ืชืจ ื•ืœืฉืœื™ื˜ื” ื—ื–ืงื” ื™ื•ืชืจ ืขืœ ืฉืจืช ื”-SQL ืฉืœื ื•.

ืœืžื™ื“ืข ื ื•ืกืฃ