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 `b_devices` A
On Monday 17 July 2006 13:26, Karl Larsen wrote:
I'm using mysql on Linux and all is going well but I can't find the
proper way to write a CREATE VIEW. I'm using 4.1 and is this function
still in mysql?
If the MySQL manual for 4.1 does not list views as a feature of that version,
odds are
create view v_authornames as
select authorid, CONCAT(lastname,',',firstname)
from t_authors;
Or replace the middle term in the CONCAT function to whatever you want
to separate it -- ie, ' ' for a space, or just
CONCAT(lastname,firstname) to get output KritzerSheeri.
-Sheeri
On
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
mysqluse sample
mysqlcreate view v1 as select * from sam2;
sam2 is a table
We got an error
errror
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
mysqluse sample
mysqlcreate 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
In article [EMAIL PROTECTED],
Martijn Tonies [EMAIL PROTECTED] writes:
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or Firebird, for example, store the
Hello Harald, others,
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or Firebird, for example, store the view-source as defined -
this includes
In article [EMAIL PROTECTED],
Martijn Tonies [EMAIL PROTECTED] writes:
Hello Harald, others,
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or
Hello Harald, others,
This is plain rubbish. See my other example with a more complicated
view source. When adjusting the view, or extracting a script - the
view source becomes complete gibberish.
MS SQL, or Firebird, for example, store the view-source as defined -
this includes
On 05 Oct 2004 11:46:18 +0200, Harald Fuchs wrote:
Martijn Tonies writes:
MS SQL, or Firebird, for example, store the view-source as defined -
this includes comments, spacing etc etc... In short: it becomes usuable.
MySQL should do this too. From reading these lists, I think MySQL
only
On 05 Oct 2004 12:02:44 +0200, Harald Fuchs wrote:
Martijn Tonies [EMAIL PROTECTED] writes:
I was asking if the view-source can be stored, so that it can be retrieved
the way I created it. Do you agree or disagree?
I disagree. A proper information_schema implementation is much more
than
In article [EMAIL PROTECTED],
Jochem van Dieten [EMAIL PROTECTED] writes:
Since the is no requirement to have an accessible DEFINITION_SCHEMA
there may be a mechanism to recreate the definition on the fly from
other information, but the same goes for the other view related base
tables in the
Hai Martin,
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
just the same way for oracle(where i have some
Hello Eldo,
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
just the same way for oracle(where i have some
On Tue, 5 Oct 2004 00:27:45 +0530, Eldo Skaria wrote:
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
But
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
But that doesn't make it right.
Specifically, I
Hi,
I can't find this syntax in mysql tutorial and the program does not accept
it.
Well, that should give you a hint, shouldn't it?
Is there another method of achieving this ?
Views are going to be supported in MySQL 5, I believe.
With regards,
Martijn Tonies
Database Workbench -
Hi,
Subject: CREATE VIEW
I can't find this syntax in mysql tutorial and the program
does not accept
it. Is there another method of achieving this ?
About Views:
http://www.mysql.com/doc/en/ANSI_diff_Views.html
http://www.mysql.com/doc/pt/Unnamed_views.html
Workarounds:
With google
18 matches
Mail list logo