Aaron,
> why doesn't this work? the select works perfectly
Define "doesn't work"? What is the error message?
> create view cost_report as
> SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as
> "Number Enrolled",
> d_price as "Monthly Price", count(1)*d_price as "Cost"
> FROM `
Hello.
Views (including updatable views) are being implemented in the 5.0 version
of MySQL Server. They are already available in binary releases from 5.0.1
and up.
sirisha gnvg <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 18 lines --]
>
> we are w
I believe CREATE VIEW came in with 5.01, not 4.1.x.
PB
sirisha gnvg wrote:
we are working on mysql 4.1.8 and windows XP platform.
This version supports views.We created a view like this
mysql>use sample
mysql>create view v1 as select * from sam2;
sam2 is a table
We got an error
errror 1024(42000)
sirisha gnvg wrote:
we are working on mysql 4.1.8 and windows XP platform.
This version supports views.We created a view like this
mysql>use sample
mysql>create view v1 as select * from sam2;
sam2 is a table
We got an error
errror 1024(42000):you have an error in your sql syntax;
we checked the m
