SQL/MYSQL 썸네일형 리스트형 phpMyAdmin 설치 및 외부 접속(아이피) 허용 하기 phpMyAdmin 설치 phpMyAdmin 패키지를 설치 [root@localhost ~]# yum install phpMyAdmin ... 중략 ... Installed: phpMyAdmin.noarch 0:4.4.15.10-2.el7 Dependency Installed: compat-libtidy.x86_64 0:0.99.0-37.20091203.el7 dejavu-fonts-common.noarch libxslt.x86_64 0:1.1.28-5.el7 php-bcmath.x86_64 0:5.4.16- php-php-gettext.noarch 0:1.0.12-1.el7 php-process.x86_64 0:5.4.16 php-xml.x86_64 0:5.4.16-42.el7 t1lib.x86_64 .. 더보기 SQL JOIN SQL JOINA JOIN clause is used to combine rows from two or more tables, based on a related column between them. Let's look at a selection from the "Orders" table: OrderIDCustomerIDOrderDate1030821996-09-1810309371996-09-1910310771996-09-20Then, look at a selection from the "Customers" table: CustomerIDCustomerNameContactNameCountry1Alfreds FutterkisteMaria AndersGermany2Ana Trujillo Emparedados y.. 더보기 MySQL 슬로우 쿼리 로그 설정 MySQL 슬로우 쿼리 로그 설정 ●MySQL 접속하여 현재 설정 확인mysql> SHOW VARIABLES LIKE 'slow_query_%';+---------------------+---------------------------------+| Variable_name | Value |+---------------------+---------------------------------+| slow_query_log | OFF || slow_query_log_file | /var/run/mysqld/mysqld-slow.log |+---------------------+---------------------------------+2 rows in set (0.00 sec)→ 슬로우 쿼리 설정 OFF .. 더보기 이전 1 2 3 4 ··· 9 다음