home *** CD-ROM | disk | FTP | other *** search
/ Internet Pratica / IPRAT_01.iso / SQL / advanced / aqt3.CAB / mysql.cfg < prev    next >
Text File  |  2001-07-21  |  3KB  |  57 lines
  1. menu1;&Show;
  2. Tables;1;1;T;N;
  3. Users;2;2;U;N;
  4.  
  5. menu2;1;&Table List;
  6. Tables;10;
  7.  
  8. menu2;2;&User List;
  9. Tables;20;
  10.  
  11. menu3;1;Table &Info;
  12. &Columns;30;
  13. &Primary Key;31;
  14. &Access List;32;2;
  15. -;1;
  16. &Table Contents (first 30 rows);35;
  17.  
  18. menu3;2;User &Info;
  19. Access &List;34;1;
  20. Access &Grid;33;1;
  21. Full &details;36;
  22.  
  23. menu4;1;1;T;
  24. menu4;2;2;U;
  25.  
  26. queries;
  27. 1;O;Tables within Database;TABLE;Schema;1500;
  28. 2;U;Users within Database;Select distinct user from user where user <> '';User;1800;
  29. 10;O;Tables within Database;TABLE;Table;1800;Type;1000;Desc;3500;
  30. 20;U;Users within Database;Select distinct user from user where user <> '';User;1800;
  31. 30;C;Column list for;O;Column;2000;Type;1200;Length;650;Scale;500;Nulls;500;Desc;3000;
  32. 31;O;Primary key for;P;Column;2000;
  33. 32;M;Access list for;Select User, Table_priv, Grantor, Timestamp from tables_priv where Table_name = ?;Userid;1200;Privileges;2200;Grantor;1200;Timestamp;1500;
  34. 33;A;Table authorities for user;Select Table_Name, '',  if(Table_priv REGEXP 'S','Y','N'), if(Table_priv REGEXP 'U','Y','N'), if(Table_priv REGEXP 'I','Y','N'), if(Table_priv REGEXP 'D','Y','N'), if(Table_priv REGEXP 'G','Y','N') from tables_priv where user = ? order by 1;Name;1800;Dummy;1;Select;700;UpDATE;700;Insert;700;Delete;700;Grant;700;
  35. 34;B;Access List for;Select Table_name, Table_priv, Grantor, Timestamp from tables_priv where User = ? order by 1;Table;1800;Privileges;2200;Grantor;1200;DATE;2000;
  36. 35;D;Contents of;xx;Name;1500;
  37. 36;S;Full details of user;select * from user where user=?;Column;1200;Value;2000;
  38.  
  39.  
  40.  
  41.  
  42.  
  43. func;DATE;date_format(:,'%y-%m-%d');CHAR;dayofweek(:);INTEGER;dayofmonth(:);INTEGER;dayofyear(:);INTEGER;week(:);INTEGER;month(:);INTEGER;year(:);INTEGER;dayname(:);CHAR;monthname(:);CHAR;date_add(:,interval 1 day);;date_sub(:,interval 1 month);;to_days(:);INTEGER;
  44. func;TIME*;time_format(:,'%h:%i:%s');CHAR;time_to_sec(:);INTEGER;hour(:);INTEGER;minute(:);INTEGER;second(:);INTEGER;
  45. func;TIMESTAMP;date_format(:,'%y-%m-%d %t');CHAR;dayofweek(:);INTEGER;dayofmonth(:);INTEGER;dayofyear(:);INTEGER;week(:);INTEGER;month(:);INTEGER;year(:);INTEGER;hour(:);INTEGER;minute(:);INTEGER;second(:);INTEGER;dayname(:);CHAR;monthname(:);CHAR;date_add(:,interval 1 day);;date_sub(:,interval 1 month);;to_days(:);INTEGER;
  46. func;CHAR;ascii(:);int;substring(:,1,20);;insert(:,2,1,'.');;concat(:,'string');;lcase(:);;ucase(:);;left(:,5);;right(:,5);;trim(:);;ltrim(:);;rtrim(:);;length(:);INTEGER;instr(:,'x');INTEGER;lpad(:,'.',5);;rpad(:,'.',5);;replace(:,'from','to');;reverse(:);;nullif(:,'unknown');;
  47. func;INT;format(:,0);CHAR;abs(:);;sign(:);;mod(:,2);;least(:,5);;greatest(:,5);;hex(:);CHAR;elt(:,'one','two');;if(:>10,'yes','no');;from_days(:);DATE;
  48. func;DEC;format(:,2);CHAR;abs(:);;sign(:);;floor(:);INTEGER;ceiling(:);INTEGER;round(:,2);;truncate(:,2);;least(:,5);;greatest(:,5);;    
  49.  
  50. const;DATE;'2001-01-23';current_DATE; 
  51. const;TIME*;'10:32:55';current_time;;
  52. const;TIMESTAMP;'2001-01-23 10:32:55';current_timestamp;
  53. const;CHAR;'value';space(20);repeat('x',20);char(10);
  54. const;INT;0;
  55. const;DEC;0;
  56. const;ALL*;current_DATE;current_time;current_timestamp;database();user();version();connection_id();
  57.