几个测试SQL，测试SQL处理字符串

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

droptableifexistscategory;
createtableifnotexistscategory
(
  c_Id                          bigint                        notnull,
  c_name                        varchar(255)default'',
  c_type                        intdefault1,
  primarykey(c_ID)
);

droptableifexistsfiles;
createtableifnotexistsfiles
(
  f_Id                          bigint                        notnull,
  c_id                          bigint                        notnull,
  f_name                        varchar(255)default'',
  f_mids       text, 
  primarykey(f_ID)
);

droptableifexistsmembers;
createtableifnotexistsmembers
(
  m_Id                          bigint                        notnull,
  m_name                        varchar(255)default'',
  primarykey(m_ID)
);

insertintocategory(c_id,c_name,c_type)values(1,'public',1);
insertintocategory(c_id,c_name,c_type)values(2,'private',2);
insertintocategory(c_id,c_name,c_type)values(3,'upload',3);
insertintocategory(c_id,c_name,c_type)values(4,'member001',4);
insertintocategory(c_id,c_name,c_type)values(5,'member002',4);

insertintofiles(f_id,c_id,f_name,f_mids)values(1,1,'F_public','1,2');
insertintofiles(f_id,c_id,f_name,f_mids)values(2,1,'F_public','1');
insertintofiles(f_id,c_id,f_name,f_mids)values(3,1,'F_public','3,4');

insertintofiles(f_id,c_id,f_name,f_mids)values(4,2,'F_private','1,2');1<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>