Bugs Faced while Code

How to fetch the Exact UPPERCASE values from a column in MySQL? If a column have uppercase value like "NEW". We want to take the exact value from the table. SELECT * FROM sales  WHERE status REGEXP BINARY '^[A-Z]{2,}' AND uploadeddate LIKE '%2017-03-31%' AND status = 'NEW';                 

Update Query -------------------                                            --> You can update more one column value together.                      --> You can give any condition using [where clause]. Syntax to update in mysql -------------------------- ------- -- Update                   Table-Name  Set                   Column-Name1 = "Value1",                   Column-Name2 = "Value2"     ...

First we want to enter into the Mysql command line prompt by giving the Password MySQL> Enter the password : xxxxxxx To know how many connections are in the database MySQL> show variables like "max_connections"; It will list out the output as Variable Name         Value max_connections        100 Default value for the max_connections is 100. If we want to increase the max connections then we wan to give Set global max_connections = "our value" [our value refers= 200,300,500 etc...] It will affect immediately. and it will again remain to max_connections as 100 when the mysql server restarts. For that we want to change the  My.conf[for linux OS] or My.ini file [for windows OS] Thanks for viewing our post..