Today's customers, database naming in the name of a variable, with the first letter capitalized, followed by lowercase to distinguish the word, in fact, this practice may have some problems, the program is difficult to write. Today, let's talk about
This article shares the MySQL stored procedure that modifies the table name to uppercase, as follows
1. Conditions:1.1 MySQL settings are case sensitive2. Execute the following stored procedures:
#call uppercase (' Library name ') DROP
Bulk change the table name to uppercase begin for C in (select table_name TN from USER_TABLES where TABLE_NAME <> UPPER (table_name)) Lo op begin EXECUTE immediate ' ALTER TABLE ' | | c.tn| | ' Rename to ' | | c.tn; exception
Oracle converts the table name and field name to uppercase. When using powerdesigner to create a database, pay attention to Case sensitivity. Note: The following scripts are correctly executed on oracle 10g and 11g to convert table names to
When compiling a program with GCC, parameters such as "-I" (uppercase I), "-l" (uppercase L), and "-l" (lowercase L) may be used, below is a record:
Example:
Gcc-O hello. C-I/home/Hello/include-L/home/Hello/lib-lworld
The above statement indicates
This article mainly introduces how php converts an uppercase name to an underscore (_), and explains some naming methods that are not used to an uppercase style, such as Pascal name and camper name, you can refer to the following code to convert a
This article mainly introduces how php converts an uppercase name to an underscore (_), and explains some naming methods that are not used to an uppercase style, such as Pascal name and camper name, you can refer to the following code to convert a
In PostgreSQL ,user is a reserved word. If you want to create a user table, you may encounter some problems! As you can see, there is no way to create a user table .You might say, I just don't have a double quote "" to enclose the uppercase table
Select BSK001 from DbdataError: Column "bsk001" of relation "dbdata" does not exist.The reason is that the fields in the database are named BSK001, and the uppercase letters are automatically converted to lowercase in SQL statements;That is, the
How to use script validation to automatically fill out the RMB in a form (uppercase) Amount fieldDemand:There are two fields in the form, one field is a manual entry of RMB amount (lowercase), and the other field needs to fill in the uppercase form
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.