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 `
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 a
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 6
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
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
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
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 My
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 -
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.
>>
>>
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 inclu
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, sto
> > 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.
>
> Specif
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.
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
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 (in)exp
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 y
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 - devel
19 matches
Mail list logo
