[B! sql] griffin-stewieã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

griffin-stewie id:griffin-stewie

sqlã«é–¢ã™ã‚‹griffin-stewieã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

iPhone SDK ã§UIImageã®ç”»åƒã‚’SQLiteã®DBã«æ ¼ç´ã™ã‚‹æ–¹æ³• - é›»åè¶£å‘³ã®éƒ¨å±‹
UIImageã«æ ¼ç´ã•ã‚ŒãŸç”»åƒã®ãƒã‚¤ãƒŠãƒªã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’SQLiteã®DBã«ä¿å˜ã‚’ã™ã‚‹æ–¹æ³• SQLiteã®ä½¿ã„æ–¹ã¯iPhoneSDKã§SQLiteã‚’ä½¿ã†æ–¹æ³•ã«æ›¸ã„ã¦ã‚ã‚Šã¾ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ä½¿ã†ãƒ†ãƒ¼ãƒ–ãƒ« ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã—ã¦ã€æ ¼ç´ã—ã¾ã™ã€‚ ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹é …ç›®ã¯blobã§å®šç¾©ã—ã¾ã™ã€‚ create table IMAGETABLE ( id integer, // ãªã‚“ã¨ãªãID size integer, // ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º data blob // ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ ); ç”»åƒãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ UIImageã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã®UIImagePNGRepresentationã‚’ä½¿ã£ã¦NSDataã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã«å¤‰æ›ã—ã¦ã‹ã‚‰ã€ãƒã‚¤ãƒˆé…åˆ—ã¨ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ›¸ãè¾¼ã¿ã¾ã™ã€‚ ç”»è³ªã‚ˆã‚Šã‚µã‚¤ã‚ºã‚’å„ªå…ˆã™ã‚‹ãªã‚‰ã°ã€UIImageJPEGRepresentationã§ã‚‚ã‹ã¾ã„ã¾ã›ã‚“
griffin-stewie 2009/07/15
iphone

development

sql

image
ãƒªãƒ³ã‚¯
Home Â· mootoh/toddledatabase Wiki Â· GitHub
ToddleDatabase ======== A SQLite3 wrapper library for iPhone development. It makes small abstraction for using SQLite3 a bit easier. Usage -â€”â€”â€”â€”â€”â€”- include â€˜ToddleDatabase.hâ€™ and â€˜libToddoleDatabase.aâ€™ in your project create db instance via â€˜ToddleDatabase:initWithPath:â€™ query it Example: SELECT -â€”â€”â€”â€”â€”â€”- specify the field by NSDictionary with (field_name, field_type) result will be an NSArray cons
griffin-stewie 2009/04/15
iphone

development

sql

sqlite
ãƒªãƒ³ã‚¯
SQLiteã‚’åˆ©ç”¨ã™ã‚‹æ–¹æ³• - ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒŽãƒ¼ãƒˆ
ä¸‹è¨˜ã‚µã‚¤ãƒˆã‚’å‚è€ƒã«è‡ªåˆ†ã§ã‚‚è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ è¶…ç°¡å˜ã«Sqliteã‚’ã¤ã‹ã† iPhone Programming Tutorial - Creating a ToDo List Using SQLite Part 1 åˆ©ç”¨æ‰‹é † 1. DBãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ 2. å¿…è¦ãªãƒ©ã‚¤ãƒ–ãƒ©ãƒª(FMDB for iPhone, libsqlite3.0.dylib)ã‚’è¿½åŠ 3. FMDBã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’åˆ©ç”¨ã—ã¦SQLiteã‚’åˆ©ç”¨ DBãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ ã¾ãšã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ $ sqlite3 sample.db sqlite> CREATE TABLE TEST( ...> id INTEGER PRIMARY KEY, ...> name VARCHAR(255) ...> ); ã¨ã„ã†é¢¨ã«ã‚³ãƒžãƒ³ãƒ‰ã§ã‚„ã£ã¦ã‚‚ã„ã„ã§ã™ãŒã€ãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ä½œã£ãŸã‚‰å¾Œã¯Litaã¨ã„ã†AIRã®SQL
griffin-stewie 2009/03/06
iphone

development

sql

sqlite
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€REVIEWã€‘SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆã«å„ªã‚ŒãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€ŒA5:SQL Mk-2ã€
ã€ŒA5:SQL Mk-2ã€ã¯ã€SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆãªã©ã®æ©Ÿèƒ½ã‚’å‚™ãˆãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€‚Windows 98/2000/XP/Server 2003/Vista/Server 2008/Vista x64ã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ æœ¬ã‚½ãƒ•ãƒˆã¯ã€SQLæ–‡ã®ä½œæˆãƒ»å®Ÿè¡Œã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚ADOã‚„ODBCãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã‚’åˆ©ç”¨ã—ã¦å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ã§ã€æœ¬ã‚½ãƒ•ãƒˆã§ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿè¡Œã—ã€ãã®çµæžœã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ã¾ãŸã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€å®Ÿè¡Œçµæžœã‚’ã€ŒExcelã€ã¸å‡ºåŠ›ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ ç”»é¢ã¯ã‚µã‚¤ãƒ‰ãƒãƒ¼ã¨ç·¨é›†ç”»é¢ã®2ã¤ã«åˆ†å‰²ã•ã‚Œã¦ãŠã‚Šã€ã‚µã‚¤ãƒ‰ãƒãƒ¼ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŠã‚ˆã³é–¢é€£ã™ã‚‹ã‚¹ã‚ãƒ¼ãƒžãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ãƒ“ãƒ¥ãƒ¼ã¨ã„ã£ãŸé …ç›®ãŒãƒ„ãƒªãƒ¼å½¢å¼ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ç·¨é›†ç”»é¢ã¯ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆå¼ã«ãªã£ã¦ãŠã‚Šã€SQLæ–‡ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ãªã©ã‚’è¤‡æ•°é–‹ã„ã¦
griffin-stewie 2008/12/06
sql

software
ãƒªãƒ³ã‚¯
sonson@Picture&Software - [iPhone SDK] SQLiteã¸ã®èª¤è§£
ç§ã¯æ¿€ã—ãSQLiteã‚’èª¤è§£ã—ã¦ã„ã¾ã—ãŸï¼Žãã®èª¤è§£ã‚’ä¸¦ã¹ã¦ã¿ã¾ã—ãŸï¼Ž ï¼‘ï¼ŽINSERTã¯é…ããªã„ INSERTã‚¯ã‚¨ãƒªã¯ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§ã¾ã¨ã‚ã‚‹ï¼Žãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Œä¸€æ—¦ï¼Œä»–ã‹ã‚‰ã®å‡¦ç†ã‚’ãƒãƒƒã‚¯ã—ã¦ï¼Œã¾ã¨ã‚ã¦ç™»éŒ²ã™ã‚‹ã‚ˆã†ãªæ„Ÿã˜ã®å‡¦ç†ã‚‰ã—ã„ï¼Ž å¤šãã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã™ã‚‹ã¨ãã¯ï¼Œ sqlite3_exec( database, "BEGIN", NULL, NULL, NULL ); for(){ insert---- } sqlite3_exec( database, "COMMIT", NULL, NULL, NULL ); ã¨ã™ã‚‹ï¼Ž ï¼’ï¼ŽVACUUMã—ã¦ï¼Œãƒ¡ãƒ¢ãƒªã‚’åŠ¹çŽ‡ã‚ˆãä½¿ã† SQLiteã¯ï¼Œå‰Šé™¤ã—ãŸé …ç›®ãŒæ®‹ã‚‹ï¼Žå®šæœŸçš„ã«VACUUMã‚’ã—ã¦ï¼Œæ®‹ã£ãŸã‚´ãƒŸã‚’æŽƒé™¤ã™ã‚‹ï¼Ž iPhoneã§ã¯ï¼Œä½¿ãˆã‚‹ãƒ¡ãƒ¢ãƒªãŒå°‘ãªã„ã®ã§ï¼Œã“ã‚Œã¯ã‹ãªã‚Šã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªå•é¡Œã¨ãªã‚‹ï¼Ž ãŸã ã—ï¼ŒçµŒé¨“çš„ã«VACUUMã¯ã‚´ãƒŸãŒ
griffin-stewie 2008/12/01
sql

sqlite
ãƒªãƒ³ã‚¯
http://matetips.info/?q=node/17
griffin-stewie 2007/08/08
mac

textmate

database

sql
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã§mysqlã®è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— | ãƒ©ãƒ³ã‚µãƒ¼ã‚ºç¤¾é•·æ—¥è¨˜
ã„ã„ãï¼ 4 ãƒ„ã‚¤ãƒ¼ãƒˆ B! ã¯ã¦ãƒ– 185 Pocket 22 ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã¯éžå¸¸ã«é«˜æ©Ÿèƒ½ãªã‚“ã§ã™ãŒã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã ã‘ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ï¼ˆç§ãŒç¢ºèªã™ã‚‹é™ã‚Šã€‚ï¼‰ HTMLã‚„GIFã€PHPãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒãƒ¼ã‚«ãƒ«ã®PCã§æŒã£ã¦ã„ã‚‹ã‹ã‚‰å¤§æŠµã¯å¤§ä¸ˆå¤«ã ã¨ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã¯é–“é•ã£ã¦å…¨éƒ¨æ¶ˆã—ã¦ã—ã¾ã£ãŸæ—¥ã«ã¯ç›®ã‚‚å½“ã¦ã‚‰ã‚Œã¾ã›ã‚“ã€‚ã€‚å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ãŒã€å¿˜ã‚Œã‚‹ã“ã¨ã‚‚ã‚ˆãã‚ã‚‹ã®ã§ã€è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’cronã«ç™»éŒ²ã—ã¨ãã¾ã—ãŸã€‚ ã‚ˆãã‚ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ãŒã€å‚è€ƒã¾ã§ã«å¼µã£ã¦ãŠãã¾ã™ã€‚3æ—¥é–“åˆ†ã®MYSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã—ã¾ã™ã€‚mysqlã®ID/PWãªã©ã¯æ›¸ãæ›ãˆã¦ä¸‹ã•ã„ã€‚ ä½•ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã‚“ã¦ã—ã¦ãªã„ï¼ã¨ã„ã†äººã¯ã€è‡ªå·±è²¬ä»»ã§ä½¿ã£ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ #!/bin/sh PATH=/bin:/usr/bin:/sbin:/usr/sbin:/
griffin-stewie 2007/07/30
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ

sql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

é‹ç”¨

tips

mysql

db

backup
ãƒªãƒ³ã‚¯
ãƒ—ãƒãŒä½œã£ãŸé»’çŒ«å°ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ (å¼•ã£è¶Šã—ã¾ã—ãŸ)
â– æœ€æ–°æƒ…å ± é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯å¼•ã£è¶Šã—ã¾ã—ãŸã€‚ æ–°ã—ã„ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯ã“ã¡ã‚‰ â†’ http://kuronekosoft.ewinds.net/ 5ç§’å¾Œã«è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã€‚ é»’çŒ« SQLÂ Studio ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚é»’çŒ« SQLÂ Studio ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å…¥åŠ›æ”¯æ´æ©Ÿèƒ½ã‚„ã€ä½œã£ãŸSQLã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦ç®¡ç†ã™ã‚‹æ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ â– é»’çŒ« SQL StudioÂ ã«ã¤ã„ã¦çŸ¥ã‚ŠãŸã„ â†’ é»’çŒ« SQL Studio â– é»’çŒ« SQL StudioÂ ã‚’ç´¹ä»‹ã—ã¦ã„ãŸã ãã¾ã—ãŸ â†’ SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒ... - çª“ã®æœ â†’ ä½¿ã„ã‚„ã™ã„SQLå®Ÿè¡Œç’°å¢ƒ... - Unofficial DB2 BLOG â†’ ã©ã‚“ãªDBã‚‚GUIã§SQLä½œæˆ... - Hibiæ—¥è¨˜ â†’ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®å¿…éœ€å“
griffin-stewie 2007/07/05
database

db

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

ãƒ„ãƒ¼ãƒ«

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

windows

tool

sql
ãƒªãƒ³ã‚¯
SQLæ–‡ã‚’ãã‚Œã„ã«ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã€ŽSQL in Formã€ | POP*POP
é•·ï½žã„SQLæ–‡ã‚’è¦‹ã¦ã„ã‚‹ã¨ã©ã“ãŒã©ã†ã„ã†æ§‹é€ ã«ãªã£ã¦ã„ã‚‹ã®ã‹ãŒã‚ã‹ã‚‰ãªããªã£ã¦ãã¾ã™ã‚ˆãã€‚ ãã†ã—ãŸã¨ãã«ä½¿ãˆãã†ãªã®ãŒã€ŒSQL in Formã€ã§ã™ã€‚ ä¸€èˆ¬å‘ã‘ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ãªã„ã§ã™ãŒã€é–¢ä¿‚ã‚ã‚‹æ–¹ã«ã¯ä¾¿åˆ©ãªã®ã§ã¯ã€‚ ä»¥ä¸‹ã«ç°¡å˜ã«ã”ç´¹ä»‹ã€‚ â†‘ ãŸã¨ãˆã°ã“ã®ã‚ˆã†ãªSQLæ–‡ã€‚ã‚³ãƒ¡ãƒ³ãƒˆåˆ†ã‚„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆãŒã‚ã‹ã‚Šã«ãããªã£ã¦ã„ã¾ã™ã€‚ â†‘ SQL in Formã‚’é€šã›ã°ã“ã®é€šã‚Šã€‚æ§‹é€ ãŒã™ã£ãã‚Šã—ã¦è¦‹ã‚„ã™ã„ã§ã™ãã€‚ å¤‰æ›ã™ã‚‹éš›ã«ã¯æ”¹è¡Œã‚„ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆã€ç©ºç™½ã®æ‰±ã„ãªã©ã®è¨å®šã‚’ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ã¾ãŸãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ç”¨ã®ã‚¢ãƒ—ãƒªã‚‚ã‚ã‚‹ã¿ãŸã„ã§ã™ãã€‚ ã”åˆ©ç”¨ã¯ä»¥ä¸‹ã‹ã‚‰ã©ã†ãžã€‚ç„¡æ–™ã§ä½¿ãˆã¾ã™ã€‚ Â» SQL Formatter / SQL Formatter formats SQL Statements
griffin-stewie 2007/05/19
webã‚µãƒ¼ãƒ“ã‚¹

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

database
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
griffin-stewie 2007/03/15
å…¨æ–‡æ¤œç´¢

æŠ€è¡“

æ¤œç´¢

mysql

n-gram

database

sql
ãƒªãƒ³ã‚¯
CakePHP ã® findAll ã§åŠ¹çŽ‡è‰¯ã recursive - d.hetima
CakePHP 1.1.13.4450 + PHP 5ç³» + MySQL 4.1ç³»ã«ã¦ãƒ†ã‚¹ãƒˆ Job ãƒ¢ãƒ‡ãƒ«ã¯ com_id ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒã‚ã£ã¦ Com ãƒ¢ãƒ‡ãƒ«ã« belongsTo Job ã‚’ä¸€è¦§è¡¨ç¤ºã™ã‚‹ã¨ãã« Com ã® name ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚‚è¡¨ç¤ºã—ãŸã„ Job.idJob.nameJob.com_id 1ä»•äº‹A1 2ãã¤ã„ä»•äº‹2 3æ¥½ãªä»•äº‹1 Com.idCom.name 1ä¼šç¤¾A 2ä¼šç¤¾B ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ã€ Job.idJob.nameCom.name 1ä»•äº‹Aä¼šç¤¾A 2ãã¤ã„ä»•äº‹ä¼šç¤¾B 3æ¥½ãªä»•äº‹ä¼šç¤¾A ã“ã‚“ãªæ„Ÿã˜ã®ä¸€è¦§ã‚’è¡¨ç¤ºã—ãŸã„ã‚ã‘ã§ã™ã€‚ã©ã†ã™ã‚‹ã®ãŒåŠ¹çŽ‡ãŒè‰¯ã„ã‹ã€‚ã¾ãšã€Job ãƒ¢ãƒ‡ãƒ«ã®ã‚¢ã‚½ã‚·ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã€‚ <?php class Job extends AppModel { var $name = 'Job'; var $belongsTo = array(
griffin-stewie 2007/03/03
cakephp

SQL
ãƒªãƒ³ã‚¯
1