Re: Move WebDNA DB to MySQL
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60746
interpreted = N
texte = Try thisLOAD DATA INfile 'c:/blah/blah.txt' INTO TABLE xyz IGNORE 1 LINESSal D'Anna-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfClint DavisSent: Tuesday, January 11, 2005 2:38 PMTo: WebDNA TalkSubject: Move WebDNA DB to MySQLI want to move a tab-delimited members database that WebDNA was using to aMySQL database. What would be the proper syntax to search the tab-delimitedfile with WebDNA and INSERT all founditems into the MySQL database? Is themethodology below acceptable?[SQLConnect dbType=MySQL&host=xxx&database=xxx&uid=xxx&pwd=xxx&conn_var=conn1][/SQLConnect][search db=my.db&neIDdata=find_all][founditems][SQLExecute conn_ref=conn1&result_var=rs1]INSERT INTO xxx VALUES ('[value1]', '[value2]', '[value3]', '[value4]')[/SQLExecute][/founditems][/search]Is there a better/easier way to INSERT multiple rows?---------------------------------------------------------------------Clint DavisWebmaster / Interactive Media SpecialistGray Loon Marketing Group, Inc. http://www.grayloon.com204 Main Street | Evansville, IN 47708 | Phone:812-422-9999----------------------------------------------------------------------------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Try thisLOAD DATA INfile 'c:/blah/blah.txt' INTO TABLE xyz IGNORE 1 LINESSal D'Anna-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfClint DavisSent: Tuesday, January 11, 2005 2:38 PMTo: WebDNA TalkSubject: Move WebDNA DB to MySQLI want to move a tab-delimited members database that WebDNA was using to aMySQL database. What would be the proper syntax to search the tab-delimitedfile with WebDNA and INSERT all founditems into the MySQL database? Is themethodology below acceptable?[SQLConnect dbType=MySQL&host=xxx&database=xxx&uid=xxx&pwd=xxx&conn_var=conn1][/SQLConnect][search db=my.db&neIDdata=find_all][founditems][SQLExecute conn_ref=conn1&result_var=rs1]INSERT INTO xxx VALUES ('[value1]', '[value2]', '[value3]', '[value4]')[/SQLExecute][/founditems][/search]Is there a better/easier way to INSERT multiple rows?---------------------------------------------------------------------Clint DavisWebmaster / Interactive Media SpecialistGray Loon Marketing Group, Inc. http://www.grayloon.com204 Main Street | Evansville, IN 47708 | Phone:812-422-9999----------------------------------------------------------------------------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Sal D'Anna"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[WriteFile] problems (1997)
Phantom Sendmail (2005)
Has anyone used WebCatalog with CGatePro? (2000)
Multi-processor Mac info ... (1997)
Variables for chat (1997)
Inventory Adjustment (2000)
Universal db access template ... (2002)
Summary search -- speed (1997)
Nested tags count question (1997)
Not Authorised Adding Items (1998)
Preliminary Vendor Solicitation (2004)
Project 2 (1998)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] Happy Friday (2016)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
WebCat2 several catalogs? (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
using WebCat for Associate Programs? (1998)
search/showif issues (2000)
New Calendar Snippet (1998)