SQL Queries Plugin
Versions: 4.1, 4.0, 3.9, 3.8, 3.7, 3.6
This plugin allows viewing record from SQL by using certain queries.
SQL plugin allows viewing record from SQL by using selected queries. Don’t use: create, insert, update, delete, alter, drop, into and truncate queries.
1 Download plugin.
2 Unzip the downloaded file.
3 In your nopCommerce web folder, you will see a Plugins folder, in it...
4 Create a sub folder with plugin name (TMotions.Sql queries).
5 Copy all the files from the zip download into the subfolder.
a restart the nopCommerce application, or
b login as Administrator, goto Administration > Configuration > Plugins > click the button "Reload list of Plugins".
7 after the list reloads, scroll down to the line with new plugin name, and click the "Install" link.
8 When you install the plugin, "Display Data" will shown under the plugin tab and once you click on Display Data
1. You may view record from SQL by using select queries
2. Don't use create, inser , update, delete, alter, drop and truncate query
and there will be one box in which you write the select query.