i'm trying to install the F&E Checkout plugin and in looking at the install.sql some of these lines do not look like SQL commands. for example:
# this next line can be skipped if it already exists in the database
INSERT IGNORE INTO configuration (configuration_title, configuration_key, configuration_value,....
should i just copy and paste the entire doc?, of should i leave lines like the one above that starts with the # symbol?
Thread: Question about using SQL
Results 1 to 3 of 3
-
14 Jan 2013, 11:12 PM #1
Zen Follower
- Join Date
- Oct 2012
- Posts
- 282
- Plugin Contributions
- 0
Question about using SQL
-
15 Jan 2013, 01:23 AM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,445
- Plugin Contributions
- 81
Re: Question about using Install SQL patches
In MySQL (and many other languages), the # hashmark at the beginning of a line denote comments, and those lines are ignored.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
15 Jan 2013, 04:32 PM #3
Zen Follower
- Join Date
- Oct 2012
- Posts
- 282
- Plugin Contributions
- 0
Re: Question about using Install SQL patches
okay thanks, didn't know that. was only familiar with /* and //
Reply With Quote
Similar Threads
-
question about $sql statements
By tcarden in forum Contribution-Writing GuidelinesReplies: 3Last Post: 27 Dec 2012, 03:51 AM -
How did you hear about us (SQL question)
By Serious in forum All Other Contributions/AddonsReplies: 2Last Post: 10 Oct 2011, 02:31 PM
