'MySQL'에 해당되는 글 7건

PHP 에서 Session 을 MySQL 로 처리시 아래와 같은 에러가 날 경우

PHP Warning: Unknown: Cannot call session save handler in a recursive manner in Unknown on line 0

1. php.ini 의 MemoryLimit 를 256M 이상으로 올린다.

2. MySQL user 의 권한을 확인한다.

user 의 권한에 insert / delete 등이 없을 경우 발생할 수 있음.

SELECT IFNULL(COUNT, 0) FROM TABLE;

COUNT 가 NULL 이면 0으로....

gem install mysql
-----------------------------------------------------------------------------
Building native extensions.  This could take a while...
ERROR:  While executing gem ... (Gem::Installer::ExtensionBuildError)
    ERROR: Failed to build gem native extension.

ruby extconf.rb install mysql
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... yes
checking for mysql_query() in -lmysqlclient... no
-----------------------------------------------------------------------------

gem install mysql -- --with-mysql-lib=/usr/local/mysql/lib/mysql/

cd /usr/local/ruby/lib/ruby/gems/1.8/gems/mysql-2.7/
ruby extconf.rb --with-mysql-config=/usr/local/mysql/bin/mysql_config
make
make install
gem install mysql -- --with-mysql-lib=/usr/local/mysql/lib/mysql/

auto_increment 값 1000부터 테이블 생성

create table 테이블 (
num int(11) unsigned not null auto_increment primary key
) type=myisam auto_increment=1000;

auto_increment 값 변경

alter table 테이블명 auto_increment=1000;

현재 auto_increment 값 알기

$SQL = "SHOW TABLE STATUS LIKE 'TableName'";

mysql> show table status like "tableName" G
*************************** 1. row ***************************
Name: tablename
Type: MyISAM
Row_format: Dynamic
Rows: 30154
Avg_row_length: 330
Data_length: 9962860
Max_data_length: 4294967295
Index_length: 1963008
Data_free: 0
Auto_increment: 104136
Create_time: 2005-05-31 11:57:59
Update_time: 2006-02-06 22:10:02
Check_time: NULL
Create_options:
Comment:
1 row in set (0.00 sec)