如何将大写值插入mysql表 [英] how to insert uppercase values into a mysql table

问题描述

大家好，我只是想了解在将字母插入表格中时如何将字母转换为大写，我已经在文本框中获得了文本转换"样式，该样式允许用户仅将大写字母放入尽管已打开或关闭大写字母的文本框，但是当大写字母关闭时，即使它在文本框中显示大写字母，也仍将其作为小写字母插入表格中，我该如何更改呢?

hi all, just want to find out how can i convert letters to upper case when inserting them into a table, ive already got the "text-transform" style on the textboxes that allows the user to only put upper case letters into the textboxs despite caps been on or off, but when caps is off even though it shows upper case in the textbox its still inserting it into the table as lower case letters how can i change this please

推荐答案

您可以在向表中插入值时在sql中使用上"关键字...

选择鞋面(''sankar'')

回答
SANKAR

you can use ''upper'' key word in sql when inserting values to table...

select upper(''sankar'')

answer
SANKAR

你好

您只需使用Upper关键字，例如喜欢

Hello

You just use Upper keyword e.g. like

upper('abhimanyu')

谢谢
Abhimanyu

Thanks
Abhimanyu

嗨...

在大写插入查询中使用Toupper()方法插入数据，在后面使用Toupper()方法和value例如，如果您插入TextBox值，则使用

-Ex-TxtName.Text.Toupper()

-此方法将TxtName.Text值转换为大写形式，也可以用于DropDownlsi

-Ex- drpnameprefix.SelectedItem.Text.ToUpper()


-so只需放入Toupper()方法并转换为大写形式的任何值，然后将该值插入数据库中

享受编码

hi...

you use Toupper() methd for insert data in Upper case ininsert query you use Toupper() method behind and value for example if you insert TextBox value you use

-Ex-TxtName.Text.Toupper()

-this method convert TxtName.Text Value in Upper Case this way You can also Use for DropDownlsi

-Ex- drpnameprefix.SelectedItem.Text.ToUpper()


-so just Put Toupper()method and convert Any value in upper case and insert that value in database

Enjoy coding

这篇关于如何将大写值插入mysql表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！