{"id":8004,"date":"2022-03-30T09:21:46","date_gmt":"2022-03-30T02:21:46","guid":{"rendered":"https:\/\/hostify.vn\/blog\/?p=8004"},"modified":"2022-03-30T09:21:46","modified_gmt":"2022-03-30T02:21:46","slug":"mysql-la-gi-kien-thuc-cho-nguoi-moi-bat-dau","status":"publish","type":"post","link":"https:\/\/www.hostify.vn\/blog\/mysql-la-gi-kien-thuc-cho-nguoi-moi-bat-dau\/","title":{"rendered":"MySQL l\u00e0 g\u00ec? Chi ti\u1ebft ki\u1ebfn th\u1ee9c MySQL cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u 2022"},"content":{"rendered":"

 <\/p>\n

Internet ng\u00e0y c\u00e0ng ph\u00e1t tri\u1ec3n, ng\u00e0y c\u00e0ng c\u00f3 nhi\u1ec1u thu\u1eadt ng\u1eef c\u00f4ng ngh\u1ec7 m\u00e0 b\u1ea1n kh\u00f3 c\u00f3 th\u1ec3 hi\u1ec3u \u00fd ngh\u0129a c\u1ee7a n\u00f3. Trong \u0111\u00f3 c\u00f3 kh\u00e1i ni\u1ec7m <\/span>MySQL l\u00e0 g\u00ec?<\/b><\/p>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c c\u00f9ng v\u1edbi database, c\u1ea7n ph\u1ea3i c\u00f3 m\u1ed9t ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 v\u1ec1 qu\u1ea3n l\u00fd. V\u00e0 MySQL l\u00e0 ph\u1ea7n m\u1ec1m qu\u1ea3n tr\u1ecb database m\u1ea1nh m\u1ebd v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay.\u00a0<\/span><\/p>\n

\u0110\u1ec3 hi\u1ec3u r\u00f5 MySQL l\u00e0 g\u00ec<\/em>? MySQL ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o<\/em>?, th\u00ec h\u00e3y c\u00f9ng Hostify.vn t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft sau \u0111\u00e2y nh\u00e9!<\/span><\/p>\n

1. MySQL l\u00e0 g\u00ec?<\/b><\/h2>\n

MySQL<\/b><\/a> l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf (Relational Database Management System \u2013 \u0111\u01b0\u1ee3c g\u1ecdi t\u1eaft l\u00e0 RDBMS), \u0111\u01b0\u1ee3c <\/b>T\u1eadp \u0111o\u00e0n Oracle ph\u00e1t tri\u1ec3n d\u1ef1a tr\u00ean ng\u00f4n ng\u1eef truy v\u1ea5n c\u00f3 c\u1ea5u tr\u00fac (SQL).<\/b><\/p>\n

T\u00ean c\u1ee7a MySQL l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a \u201cMy\u201d, t\u00ean c\u1ee7a con g\u00e1i Michael Widenius, ng\u01b0\u1eddi t\u1ea1o ra MySQL v\u00e0 \u201cSQL\u201d.<\/span><\/p>\n

MySQL ban \u0111\u1ea7u \u0111\u01b0\u1ee3c ra m\u1eaft v\u00e0o n\u0103m 1995. K\u1ec3 t\u1eeb \u0111\u00f3, n\u00f3 \u0111\u00e3 tr\u1ea3i qua m\u1ed9t v\u00e0i thay \u0111\u1ed5i v\u1ec1 quy\u1ec1n s\u1edf h\u1eefu\/qu\u1ea3n l\u00fd, tr\u01b0\u1edbc khi k\u1ebft th\u00fac t\u1ea1i Oracle Corporation v\u00e0o n\u0103m 2010. <\/span><\/p>\n

M\u1eb7c d\u00f9 Oracle hi\u1ec7n \u0111ang n\u1eafm quy\u1ec1n \u0111i\u1ec1u h\u00e0nh, nh\u01b0ng MySQL v\u1eabn l\u00e0 ph\u1ea7n m\u1ec1m m\u00e3 ngu\u1ed3n m\u1edf, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng v\u00e0 ch\u1ec9nh s\u1eeda n\u00f3.<\/span><\/p>\n

\"mysql

MySQL l\u00e0 g\u00ec? \u0110\u00e2y l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf, \u0111\u01b0\u1ee3c T\u1eadp \u0111o\u00e0n Oracle ph\u00e1t tri\u1ec3n d\u1ef1a tr\u00ean ng\u00f4n ng\u1eef truy v\u1ea5n c\u00f3 c\u1ea5u tr\u00fac (SQL).<\/p><\/div>\n

MySQL<\/b> \u0111\u01b0\u1ee3c xem l\u00e0 h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 t\u1ed1c \u0111\u1ed9 cao, \u1ed5n \u0111\u1ecbnh, d\u1ec5 s\u1eed d\u1ee5ng, c\u00f3 kh\u1ea3 n\u0103ng t\u00f9y ch\u1ec9nh cao.<\/span><\/p>\n

MySQL ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c tr\u00ean nhi\u1ec1u h\u1ec7 \u0111i\u1ec1u h\u00e0nh Linux, Unix, Windows,\u2026N\u00f3 cung c\u1ea5p m\u1ed9t h\u1ec7 th\u1ed1ng \u0111a d\u1ea1ng c\u00e1c h\u00e0m ti\u1ec7n \u00edch m\u1ea1nh m\u1ebd.\u00a0<\/span><\/p>\n

B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ea3i mi\u1ec5n ph\u00ed MySQL t\u1eeb trang ch\u1ee7 c\u1ee7a h\u00e3ng v\u1edbi c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c nhau cho nh\u1eefng h\u1ec7 \u0111i\u1ec1u h\u00e0nh kh\u00e1c nhau.<\/span><\/p>\n

2. C\u00e1c thu\u1eadt ng\u1eef li\u00ean quan \u0111\u1ebfn MySQL<\/b><\/h2>\n
\"mysql

C\u00f3 r\u1ea5t nhi\u1ec1u thu\u1eadt ng\u1eef li\u00ean quan \u0111\u1ebfn MySQL, c\u00f9ng Hostify.vn t\u00ecm hi\u1ec3u nh\u00e9!<\/p><\/div>\n

2.1 Database l\u00e0 g\u00ec?<\/b><\/h3>\n

Database<\/span><\/a> (C\u01a1 s\u1edf d\u1eef li\u1ec7u) l\u00e0 t\u1eadp h\u1ee3p d\u1eef li\u1ec7u theo c\u00f9ng m\u1ed9t c\u1ea5u tr\u00fac, \u0111\u01b0\u1ee3c t\u1ed5 ch\u1ee9c b\u00e0y b\u1ea3n v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c truy c\u1eadp t\u1eeb h\u1ec7 th\u1ed1ng m\u00e1y t\u00ednh ho\u1eb7c t\u1ed3n t\u1ea1i d\u01b0\u1edbi d\u1ea1ng t\u1eadp tin trong h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u.\u00a0<\/span><\/p>\n

C\u01a1 s\u1edf d\u1eef li\u1ec7u hay Database c\u00f3 c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef tr\u00ean thi\u1ebft b\u1ecb c\u00f3 ch\u1ee9c n\u0103ng ghi nh\u1edb nh\u01b0: th\u1ebb nh\u1edb, \u0111\u0129a c\u1ee9ng, CD\u2026<\/span><\/p>\n

2.2 Open source l\u00e0 g\u00ec?<\/b><\/h3>\n

Open source<\/span><\/a> hay m\u00e3 ngu\u1ed3n m\u1edf l\u00e0 ph\u1ea7n m\u1ec1m c\u00f3 b\u1ed9 source code m\u00e0 b\u1ea5t c\u1ee9 ai c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng v\u00e0 ch\u1ec9nh s\u1eeda. B\u1ea5t c\u1ee9 ai c\u0169ng c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 s\u1eed d\u1ee5ng, s\u1eeda \u0111\u1ed5i ho\u1eb7c, th\u00eam b\u1edbt m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a m\u00ecnh.<\/span><\/p>\n

Th\u00f4ng th\u01b0\u1eddng m\u00e3 ngu\u1ed3n m\u1edf – Open Source s\u1ebd \u0111\u01b0\u1ee3c ph\u00e1t h\u00e0nh mi\u1ec5n ph\u00ed b\u1edfi c\u00e1c \u0111\u01a1n v\u1ecb CNTT uy t\u00edn v\u00e0 \u0111\u01b0\u1ee3c.\u00a0<\/span><\/p>\n

Tuy nhi\u00ean n\u00f3 v\u1eabn ph\u1ea3i ch\u1ecbu s\u1ef1 qu\u1ea3n l\u00fd b\u1edfi gi\u1ea5y ph\u00e9p GPL (GNU Public License), gi\u1ea5y ph\u00e9p n\u00e0y s\u1ebd quy \u0111\u1ecbnh vi\u1ec7c b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh g\u00ec v\u1edbi b\u1ed9 m\u00e3 ngu\u1ed3n \u0111\u00f3.<\/span><\/p>\n

2.3 Mysql_fetch_array l\u00e0 g\u00ec?<\/b><\/h3>\n

H\u00e0m <\/span>mysql_fetch_array<\/b> l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 m\u1ed9t h\u00e0ng t\u1eeb m\u1ed9t t\u1eadp b\u1ea3n ghi d\u01b0\u1edbi d\u1ea1ng m\u1ed9t m\u1ea3ng k\u1ebft h\u1ee3p v\u00e0 m\u1ed9t m\u1ea3ng s\u1ed1 ho\u1eb7c c\u1ea3 hai. <\/span><\/p>\n

H\u00e0m l\u1ea5y m\u1ed9t h\u00e0ng t\u1eeb h\u00e0m mysql_query () v\u00e0 n\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng n\u1ebfu n\u00f3 l\u00e0 TRUE V\u00e0 khi c\u00f3 l\u1ed7i ho\u1eb7c khi kh\u00f4ng c\u00f3 h\u00e0ng n\u00e0o n\u1eefa th\u00ec tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 FALSE.<\/span><\/p>\n

Y\u00eau c\u1ea7u d\u1eef li\u1ec7u ch\u1ec9 \u0111\u1ecbnh con tr\u1ecf d\u1eef li\u1ec7u \u0111\u1ec3 s\u1eed d\u1ee5ng v\u00e0 con tr\u1ecf d\u1eef li\u1ec7u l\u00e0 k\u1ebft qu\u1ea3 t\u1eeb h\u00e0m mysql_query ()<\/span><\/p>\n

C\u00fa ph\u00e1p th\u01b0\u1eddng g\u1eb7p:<\/span><\/p>\n\n\n\n
\n

mysql_fetch_array(data,array_type)<\/span><\/i><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2.4 Mysql workbench l\u00e0 g\u00ec?<\/b><\/h3>\n

MySQL Workbench<\/b><\/a> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 tr\u1ef1c quan truy c\u1eadp thi\u1ebft k\u1ebf v\u00e0 m\u00f4 h\u00ecnh h\u00f3a c\u01a1 s\u1edf d\u1eef li\u1ec7u cho c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e1y ch\u1ee7 MySQL.\u00a0<\/span><\/p>\n

M\u1ee5c \u0111\u00edch c\u1ee7a MySQL workbench l\u00e0 cung c\u1ea5p giao di\u1ec7n \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n v\u00e0 c\u00f3 c\u1ea5u tr\u00fac h\u01a1n.<\/span><\/p>\n

MySQL Workbench c\u00f3 s\u1eb5n tr\u00ean Windows, Linux v\u00e0 Mac OS X.<\/span><\/p>\n

2.5 Mysql_fetch_assoc l\u00e0 g\u00ec?<\/b><\/h3>\n

H\u00e0m <\/span>mysql_fetch_assoc<\/b> tr\u1ea3 v\u1ec1 m\u1ed9t h\u00e0ng t\u1eeb m\u1ed9t t\u1eadp b\u1ea3n ghi d\u01b0\u1edbi d\u1ea1ng m\u1ed9t m\u1ea3ng k\u1ebft h\u1ee3p.<\/span><\/p>\n

H\u00e0m n\u00e0y l\u1ea5y m\u1ed9t h\u00e0ng t\u1eeb h\u00e0m mysql_query () v\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng khi th\u00e0nh c\u00f4ng ho\u1eb7c FALSE n\u1ebfu kh\u00f4ng th\u00e0nh c\u00f4ng ho\u1eb7c khi kh\u00f4ng c\u00f2n h\u00e0ng n\u00e0o n\u1eefa.<\/span>
\n<\/span><\/p>\n\n\n\n
mysql_fetch_assoc(data)<\/span><\/i><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2.6 Mysql_num_rows l\u00e0 g\u00ec?<\/b><\/h3>\n

H\u00e0m <\/span>mysql_num_rows <\/b>tr\u1ea3 v\u1ec1 s\u1ed1 h\u00e0ng trong m\u1ed9t t\u1eadp b\u1ea3n ghi.<\/span><\/p>\n

H\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 FALSE khi kh\u00f4ng th\u00e0nh c\u00f4ng.<\/span><\/p>\n\n\n\n
mysql_num_rows(resource $result): int|false<\/span><\/i><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2.7 M\u00f4 h\u00ecnh Client-server l\u00e0 g\u00ec?<\/b><\/h3>\n

M\u00f4 h\u00ecnh <\/span>Client Server<\/b> l\u00e0 m\u00f4 h\u00ecnh m\u1ea1ng m\u00e1y t\u00ednh, trong \u0111\u00f3 c\u00e1c m\u00e1y t\u00ednh c\u00e0i \u0111\u1eb7t v\u00e0 ch\u1ea1y ph\u1ea7n m\u1ec1m RDBMS \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 client (m\u00e1y kh\u00e1ch). Ch\u00fang l\u00e0m nhi\u1ec7m v\u1ee5 g\u1eedi y\u00eau c\u1ea7u \u0111\u1ebfn c\u00e1c m\u00e1y ch\u1ee7 \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3.<\/span><\/p>\n

C\u00e1ch th\u1ee9c n\u00e0y ch\u00ednh l\u00e0 m\u00f4 h\u00ecnh \u201cclient-server\u201d.<\/span><\/p>\n

3. SQL l\u00e0 g\u00ec?<\/b><\/h2>\n

R\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi nh\u1ea7m l\u1eabn 2 kh\u00e1i ni\u1ec7m n\u00e0y, th\u1ef1c ch\u1ea5t MySQL v\u00e0 SQL kh\u00e1c nhau.<\/span><\/p>\n

SQL<\/span><\/a> l\u00e0 <\/span>Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/b> \u0111\u01b0\u1ee3c hi\u1ec3u \u0111\u01a1n gi\u1ea3n l\u00e0 m\u1ed9t \u201cb\u1ed9 l\u1ecdc\u201d c\u00f3 kh\u1ea3 n\u0103ng thu th\u1eadp th\u00f4ng tin t\u1eeb nhi\u1ec1u b\u1ea3ng trong m\u1ed9t h\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u (Mysql) sau \u0111\u00f3 thi\u1ebft l\u1eadp c\u00e1c c\u00e1c ti\u00eau ch\u00ed \u0111\u1ec3 h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u00edch h\u1ee3p.<\/span><\/p>\n

SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Structured Query Language l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u. SQL l\u00e0 ng\u00f4n ng\u1eef chung m\u00e0 b\u1ea5t c\u1ee9 m\u1ed9t h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 n\u00e0o (RDBMS) c\u0169ng ph\u1ea3i \u0111\u00e1p \u1ee9ng.<\/span><\/p>\n

Th\u00f4ng th\u01b0\u1eddng b\u1ea1n c\u00f3 th\u1ec3 th\u1ed1ng k\u00ea v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u c\u1ee7a ban b\u1eb1ng Microsoft Excel, nh\u01b0ng SQL c\u00f3 th\u1ec3 truy v\u1ea5n v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u1edbi kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn h\u01a1n nhi\u1ec1u. C\u01a1 s\u1edf d\u1eef li\u1ec7u SQL c\u00f3 th\u1ec3 x\u1eed l\u00fd h\u00e0ng tri\u1ec7u, th\u1eadm ch\u00ed h\u00e0ng t\u1ef7 \u00f4 d\u1eef li\u1ec7u.<\/span><\/p>\n

Hi\u1ec3u \u0111\u01a1n gi\u1ea3n: N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng SQL, khi h\u1ec7 th\u1ed1ng database kh\u00e1ch h\u00e0ng c\u1ee7a b\u1ea1n qua nhi\u1ec1u n\u0103m ho\u1ea1t \u0111\u1ed9ng bao g\u1ed3m: chi ti\u1ebft t\u00ean doanh nghi\u1ec7p, th\u00f4ng tin li\u00ean h\u1ec7, \u0111\u1ecba ch\u1ec9, th\u00f4ng tin chi ti\u1ebft \u0111\u01a1n h\u00e0ng s\u1ebd d\u1ec5 d\u00e0ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef v\u00e0 truy xu\u1ea5t th\u00f4ng tin m\u1ed9t c\u00e1ch nhanh nh\u1ea5t.<\/span><\/p>\n

4. C\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u1ee7a MySQL<\/b><\/h2>\n
\"mysql

Gi\u1ed1ng v\u1edbi ph\u1ea7n l\u1edbn h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c, MySQL ho\u1ea1t \u0111\u1ed9ng tr\u00ean m\u00f4 h\u00ecnh client-server model (c\u1ea5u \u200b\u200btr\u00fac m\u00e1y kh\u00e1ch-m\u00e1y ch\u1ee7).<\/p><\/div>\n

Gi\u1ed1ng \u0111a ph\u1ea7n v\u1edbi c\u00e1c h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u ng\u00e0y nay, MySQL ho\u1ea1t \u0111\u1ed9ng tr\u00ean m\u00f4 h\u00ecnh client-server model (c\u1ea5u \u200b\u200btr\u00fac m\u00e1y kh\u00e1ch-m\u00e1y ch\u1ee7).\u00a0<\/span><\/p>\n

M\u1ed7i client (m\u00e1y kh\u00e1ch) s\u1ebd g\u1eedi m\u1ed9t request t\u1eeb giao di\u1ec7n ng\u01b0\u1eddi d\u00f9ng tr\u00ean m\u00e0n h\u00ecnh sau \u0111\u00f3 server (m\u00e1y ch\u1ee7) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n.<\/span><\/p>\n

C\u00e1ch v\u1eadn h\u00e0nh ch\u00ednh c\u1ee7a MySQL:<\/span><\/p>\n