Search Results for '2010/01'


1 posts related to '2010/01'

  1. 2010/01/05 Dynamic table in MySQL (2)
MYSQL 테이블을 가변적으로 사용할때 쓰면 편리하다

SET
@table = 'mysql.user';
SET @host = '''%localhost%''';
SET @s = CONCAT('SELECT * FROM ', @table, ' WHERE host LIKE ', @host);
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

음..
2010/01/05 11:53 2010/01/05 11:53