For this, an ALTER TABLE query is required. Once invoked, simply mention the column and its definition. Something like this:
ALTER TABLE cars
ADD COLUMN engine VARCHAR(80) AFTER colour;
Featured Post
What is the purpose of the php.ini file?
The PHP configuration file, php.ini , is the final and most immediate way to affect PHP's functionality. The php.ini file is read ea...
Subscribe to:
Post Comments (Atom)
Popular Posts
-
You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum sala...
-
Answer: select * from emp where hiredate < (’01-jan-81’);
No comments:
Post a Comment