I have one query related to the mysql adding column query is-
alter table tbl_oppourtunities add column New_Oppourtunities as (lower(product))
if above query we have written then its throwing error like this---
ALTER TABLE tbl_oppourtunities ADD COLUMN New_Oppourtunities AS (
lower( product )
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as (lower(product))' at line 1
'Product' is a Column name And 'New_Oppourtunities ' column name that we want to add in a table 'tbl_oppourtunitiestable'
So please reply me with your best ideas ASAP.