Iam having a users table which contains "Mobile" column as well. I want a query to set the country code value by default into the column name so that the column should be updated with the mobile number along with the default country code. kindly help me on this
Thanks for your reply and i got 1 more issue now. By default iam able to get +91 now for the column but when i tried to pass it with mobile number +91 is getting removed, but i want the mobile number should be added to the +91.
kindly help me on this.
After altering the table with default value as '+91' all the values in the column are being updated with +91. Now when iam passing the mobile number(9000400112) value from the client application, for me the column value in the DBshould be updated as : '+919000400112' but it is being updated in the column as 9000400112(default value is getting eliminated). It is not appending to the default value.Kindly help me on this
if this is the case, the mobile number sent from client app goes to mobile# column and countrycode will be +91 by default.. for displaying the numbers in the UI, you must have a select query which concatenates the two columns