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:
When to use [convertchars] ?!?!? (2000)
&fieldsdir=ra truely random?? (2000)
Can't add a field (1998)
Internal server error (2004)
New Beta Documentation (1997)
New Server? (2006)
Note added to [sendmail] in Docs (2004)
TemplateCacheSize preference (1998)
Separate SSL Server (1997)
[shell] (2002)
Reserved words - Enhancement request (2000)
Content search & results (2008)
Multiple cart additions (1997)
[WebDNA] [OT]Oracle to Buy Sun (2009)
upgrading (1997)
Summing fields (1997)
multiple search commands (1997)
cybercash (2002)
Erotic Sites (1997)
Possible Shownext from Listfiles???? (2000)