Blue Breeze

mysql multi count() in one query DISTINCT 를 이용한 COUNT SELECT u.user_id, u.user_name COUNT(DISTINCT l.logined) AS login_cnt, COUNT(DISTINCT i.items) AS item_cnt FROM user AS u LEFT JOIN logged AS l ON u.user_id=l.user_id LEFT JOIN items AS i ON u.user_id=i.user_id GROUP BY u.user_id

http://sequelpro.com/ sequelpro Download : http://www.sequelpro.com/download

nodejs mysql Error: Connection lost The server closed the connection var db_config = { host: 'localhost', user: 'root', password: '', database: 'example' }; var connection; function handleDisconnect() { connection = mysql.createConnection(db_config); // Recreate the connection, since // the old one cannot be reused. connection.connect(function(err) { // The server is either down if(err) { // or ..

MySQLのユーザー作成でハマったこと解決策メモ。(MySQL 사용자 생성에 빠진 것을 해결 과정 참고.) 에러 확인 08S01 설정확인 Check GLOBAL VARIABLES init_connect SHOW GLOBAL VARIABLES LIKE "init%" 설정변경 reset GLOBAL VARIABLES init_connect SET GLOBAL init_connect=''; SHOW GLOBAL VARIABLES LIKE "init%" 문제 해결 MySQL 설정(my.ini)에서 init-connect 부분을 수정한 뒤 MySQL을 재시작하면 된다. # my.ini init-connect=\'SET NAMES utf8\' # 설정이 잘못된 부분 init-connect=SET NAMES utf8 # ..

8 Good PHP Programming Video Tutorials For Beginners Introduction To PHP - A Complete PHP Tutorial for Absolute Beginners Learn PHP in 15 minutes Understanding PHP, MySQL, HTML and CSS PHP, HTML, and CSS: What's the difference? PHP Tutorials - Dynamic HTML Web pages using PHP Object Oriented Programming Tutorial PHP Class File Creation Learn OOP MySQL PHP Database Tutorial For Beginners 20 Commo..

xplicitly specify sort order for mysql query? select * from TABLE order by field(ID, id4, id2, id5, id3, id1) * MySQL index 에서 DESC는 현재로는 지원되지 않고 있다. 특정 컬럼(필드)에서 역 정렬이 가능한 필드를 사용하는것이 더 빠르다. field의 특정값(문자)으로 정렬하는것은 비 효율적이다. 필요하다면 tinyint 로 정렬하는것을 제안한다.

/etc/init.d/mysql stop # 또는 kill 명령어를 이용하여 서비스 중지 /usr/bin/mysqld_safe --skip-grant-tables # 또는 /usr/local/mysql/bin/mysqld_safe --skip-grant-tables mysql -uroot mysql UPDATE user SET password=PASSWORD('변경할패스워드') WHERE user = 'root'; flush privileges; /etc/init.d/mysql stop # 또는 kill 명령어를 이용하여 서비스 중지 /etc/init.d/mysql start # 새로운 사용자 추가 insert into user values ('%','root', password('비밀번호'),'Y','..

MySQL에 원격 접속 허용 insert into user (host,user,password) values('%','root',password('-password-')); grant all privileges on *.* to 'root'@'%' identified by '-password-' with grant option; -- grant select, insert, update, create, drop, reload, shutdown, alter, super, lock tables, replication client on *.* to 'backup-user'@'localhost' identified by '-password-'; -- grant select, insert, update, creat..

에러 : invoke-rc.d: initscript mysql, action "start" failed. 참고 : dpkg: invoke-rc.d: initscript mysql, action “start” failed sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean

참고 php-handlersocket/ handlerSocket plugin for MySQL HandlerSocket-Library-for-CodeIgniter Installing MySql Handlersocket in Ubuntu Natty for Ruby MySQL HandlerSocket under Ubuntu Ubuntu11.10 installation mysql + handlersocket add 2013.03.10 sudo apt-get install mysql-server -y; sudo apt-get install handlersocket-doc -y; sudo apt-get install handlersocket-mysql-5.1 -y; sudo apt-get install libhs..