Sia 0 Report post Posted July 9, 2009 please could not you help with syntax: I try to use this: < SELECT * INTO new_table_name FROM old_tablename < found it there: http://www.w3schools.com/sql/sql_select_into.asp but _Query($sql,"SELECT * INTO new FROM old WHERE id = "&$value&";") does not work _Query($sql,"SELECT * INTO new FROM old") does not work also I use cdkid`s mysql.au3. Other functions used - SELECT FROM, INSERT TO, UPDATE work. What`s wrong? Share this post Link to post Share on other sites
enaiman 14 Report post Posted July 9, 2009 What`s wrong?The Forum! This one is AutoIt not sql. SNMP_UDF ... for SNMPv1 and v2c so far, GetBulk and a new example scriptwannabe "Unbeatable" Tic-Tac-ToePaper-Scissor-Rock ... try to beat it anyway :) Share this post Link to post Share on other sites
Sia 0 Report post Posted July 13, 2009 SELECT INTO FROM does not work with mysql: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html this function works instead: _Query($sql,"INSERT INTO table2 (field1, field2) SELECT * FROM table1 WHERE id = "&$value&";") The Forum is OK, but I`m very sorry if sent this message into wrong thread Share this post Link to post Share on other sites
Yashied 200 Report post Posted July 13, 2009 The Forum! My UDFs:iKey | FTP Uploader | Battery Checker | Boot Manager | Font Viewer | UDF Keyword Manager | Run Dialog Replacement | USBProtect | 3D Axis | Calculator | Sleep | iSwitcher | TM | NetHelper | File Types Manager | Control Viewer | SynFolders | DLL HelperAnimated Tray Icons UDF Library | Hotkeys UDF Library | Hotkeys Input Control UDF Library | Caret Shape UDF Library | Context Help UDF Library | Most Recently Used List UDF Library | Icons UDF Library | FTP UDF Library | Script Communications UDF Library | Color Chooser UDF Library | Color Picker Control UDF Library | IPHelper (Vista/7) UDF Library | WinAPI Extended UDF Library | WinAPIVhd UDF Library | Icon Chooser UDF Library | Copy UDF Library | Restart UDF Library | Event Log UDF Library | NotifyBox UDF Library | Pop-up Windows UDF Library | TVExplorer UDF Library | GuiHotKey UDF Library | GuiSysLink UDF Library | Package UDF Library | Skin UDF Library | AITray UDF Library | RDC UDF LibraryAppropriate path | Button text color | Gaussian random numbers | Header's styles (Vista/7) | ICON resource enumeration | Menu & INI | Tabbed string size | Tab's skin | Pop-up circular menu | Progress Bar without animation (Vista/7) | Registry export | Registry path jumping | Unique hardware ID | Windows alignmentMore... Share this post Link to post Share on other sites