UPPERCASE and Lowercase words in SQL

[adb34]

I am trying to modify an SQL file for a plugin I am developing. The SQL file I am looking at has UPPERCASE & lowercase characters for the same word, e.g. page. Is there a programming reason for this or is just to make it easier to read/follow?

I am doing this on my phone so I cannot copy the code in to here. The SQL file can be found in plugin called Add Pages to More Info Sidebox.

[mc12345678]

It really depends on where in the sql the statement/word is used...
For example there is no difference in operation of the following two statements:

select * from products where products_id = 1;

And

SELECT * FROM products WHERE products_id = 1;

However, the configuration of the system and on which device type it is installed plays a factor on whether capitalization matters.
Generally speaking, the table(s) name and field designation(s) are lower case. SQL commands can be upper case which tends to make them stand out and understandable that they are "construct" related and not datatable related.

The value assigned to a field designation may have capital letters in it though also, an underscore is a good "divider" and ensures that a unique character is used and reduces the likelihood of a problem occurring by accidental differences in capitalization.

[swguy]

Looking at the plugin you mentioned
https://www.zen-cart.com/downloads.php?do=file&id=787

We can consider this statement

insert into configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order, last_modified, date_added,
use_function, set_function) values ('Define Page 5', 'DEFINE_PAGE_5_STATUS', '1', 'Enable
the Defined Page 5 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define
Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '85',
now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');

The string 'Define Page 5' is a character string that shows up in the configuration menu.
The string 'DEFINE_PAGE_5_STATUS' is a reference to a PHP defined constant.

Does that help?

[adb34]

I think I understand what you both have written