CREATE VIEW COMMENT ''

To endow CREATE VIEW with COMMENT would be splendid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: create view not working

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 "

create view not working

why doesn't this work? the select works perfectly 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 left join b_dev

Re: CREATE VIEW xxxx

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 featur

CREATE VIEW xxxx

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? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: create view and insert into problems

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 "Kri

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this case it was a newbie question. And therefore it's most important that he tries to learn how to look at the doc. Remembering my own troubles learn

re[2]: Newbie - CREATE VIEW Question

>> I agree that it's often better to point someone in the right direction >> rather than just writing the query for them, but in this case it was a >> newbie question. >And therefore it's most important that he tries to learn how to look at >the doc. Remembering my own troubles learning MySQL, i

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the tables. I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the query for them,

re[2]: Newbie - CREATE VIEW Question

> Sorry but you want me to write the whole SQL query? > He has to use his brain. > Grouping and joining the tables. > I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this cas

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: To those who responded - read the question. He wants to combine the values from the data column of *2* rows into one, not just a straightforward string concatenation. Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the

Re: Newbie - CREATE VIEW Question

bble.com/NewbieCREATE-VIEW-Question-tf1890326.html#a5171910 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie - CREATE VIEW Question

Thank you! -- View this message in context: http://www.nabble.com/NewbieCREATE-VIEW-Question-tf1890326.html#a5171108 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Newbie - CREATE VIEW Question

Hi, Say I have the following tables; siteID,name -- site1, XYZ site2, RSQ ID,site,data 1, site1, M 2, site2, Q 3, site2, Y 4, site1, P ... etc. And I want to create a view like this; siteID,name,data -- site

re[2]: Newbie - CREATE VIEW Question

>> z247 schrieb: >> Say I have the following tables; >> >> siteID,name >> -- >> site1, XYZ >> site2, RSQ >> >> ID,site,data >> >> 1, site1, M >> 2, site2, Q >> 3, site2, Y >> 4, site1, P >> >> ... etc. >> >> And I want to create a view like

Re: Newbie - CREATE VIEW Question

z247 schrieb: Say I have the following tables; siteID,name -- site1, XYZ site2, RSQ ID,site,data 1, site1, M 2, site2, Q 3, site2, Y 4, site1, P ... etc. And I want to create a view like this; siteID,name,data --

RE: Newbie - CREATE VIEW Question

Search the Manual for CONCAT. SELECT /Peter -Original Message- From: z247 [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 04, 2006 10:02 PM To: mysql@lists.mysql.com Subject: Newbie - CREATE VIEW Question Say I have the following tables; siteID,name

Newbie - CREATE VIEW Question

, (M,P) site2, RSQ, (Q,Y) where all the related column data in the second table is placed in another column. How can I do this? Is there a function that can group these values into one variable or array? Thank you -- View this message in context: http://www.nabble.com/NewbieCREATE-VIEW

create view and insert into problems

t_authors done with phpmyadmin) 3 title 4 subtitle Now I want to create a view from t_authors, so that the fields of lastname and firstname are one field with the value inside: "lastname, firstname": create view v_authornames as select authorid, lastname || ', ' || f

Re: create view not working on mysql 4.1.8

; > 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 > > e

Re: create view not working on mysql 4.1.8

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

Re: create view not working on mysql 4.1.8

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 check

create view not working on mysql 4.1.8

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

create view - what does the algorithm clause do?

I'm using 5.0.2 and playing with views. The documentation indicates: CREATE [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] VIEW . . . I can't figure out what that alrorithm setting changes (it's not discussed in the MySQL documentation). I don't see it in the SQL:2003 docs I have. It looks like te

Re: easy way to drop a tempoary table created by Create view?

Hello. No. Because mysql -e 'drop view v' just executes the SQL statement. And DROP VIEW doesn't support such syntax. See: http://dev.mysql.com/doc/mysql/en/DROP_VIEW.html sam wun <[EMAIL PROTECTED]> wrote: > sam wun wrote: > >> Gleb Paharenko wrote: >> >>> Hello. >>> >>> >>>

Re: easy way to drop a tempoary table created by Create view?

sam wun wrote: Gleb Paharenko wrote: Hello. Use -e command line option for mysql client program. For example: mysql -u root -p test -e 'drop view v' Hi, does it take wildcard? something like: mysql -u root -p test -e 'drop view v*' Or even drop all view tables (only affect the view tables): my

Re: easy way to drop a tempoary table created by Create view?

Gleb Paharenko wrote: Hello. Use -e command line option for mysql client program. For example: mysql -u root -p test -e 'drop view v' Hi, does it take wildcard? something like: mysql -u root -p test -e 'drop view v*' Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysq

Re: easy way to drop a tempoary table created by Create view?

Hello. Use -e command line option for mysql client program. For example: mysql -u root -p test -e 'drop view v' sam <[EMAIL PROTECTED]> wrote: > Hi, > > What is the easiest way to drop a table created by "create view"? > I m using mysql 5.0.

easy way to drop a tempoary table created by Create view?

Hi, What is the easiest way to drop a table created by "create view"? I m using mysql 5.0. I would like to execute the drop from Unix commandline. Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

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

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

tered_ would be redundancy. No, it is not redundant. If I look at the information in the VIEW_COLUMN_USAGE, VIEW_ROUTINE_USAGE, VIEW_TABLE_USAGE and VIEWS views in the INFORMATION_SCHEMA (or their equivalent base tables in the DEFINITION_SCHEMA), they do not contain sufficient information to reconstruct

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

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

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

objects. Agreed. For a view, it might store the resulting column datatypes etc... > Thus it must parse the SQL DDL > strings and store its "meaning". Additionally storing the SQL string > _as entered_ would be redundancy. Disagreed. For code, formatting has a reason. Return

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

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 a stored SQL string - it's a standardized way to access meta information about your DB objects. Thus

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

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

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

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

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

> > But that doesn't make it right. > > Specifically, I seem to remember from the SQL standard that the use of > database.table.field is undesired (or schema.table.field if you don't > use MySQL) and instead database.table should be aliassed. In that case > it should be: >

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

ing it in > memories. But that doesn't make it right. Specifically, I seem to remember from the SQL standard that the use of database.table.field is undesired (or schema.table.field if you don't use MySQL) and instead database.table should be aliassed. In that case it should be: C

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

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

Re: CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

e (in)experience). so, "don;'t worry, be happy". Regards, Eldo. On Wed, 29 Sep 2004 11:57:22 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi there, > > I'm testing MySQL 5.0.1 a bit - and I noticed the following... > > When executing this: > creat

CREATE VIEW gets all mangled up when doing SHOW CREATE VIEW

Hi there, I'm testing MySQL 5.0.1 a bit - and I noticed the following... When executing this: create view myview2 (t0) as select c1 from t It returns this when doing a SHOW CREATE VIEW myview2: CREATE VIEW test.myview2 AS select `test`.`t`.`c1` AS `t0` from `test`.`t` This is not at all w

RE: CREATE VIEW

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 Work

Re: CREATE VIEW

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

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 ? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: is CREATE VIEW possible in MySQL?

uot;Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, 18 June, 2003 17:02 Subject: Re: is CREATE VIEW possible in MySQL? Thank you for your reply, Edward, And, where's the repository? Lingua - Original Message - From: "Becoming Digital&

Re: is CREATE VIEW possible in MySQL?

Thank you for your reply, Edward, And, where's the repository? Lingua - Original Message - From: "Becoming Digital" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 1:04 AM Subject: Re: is CREATE VIEW possible in MySQL? > &g

Re: is CREATE VIEW possible in MySQL?

"Lingua2001" <[EMAIL PROTECTED]> wrote: > If not, is there a way to get the same effect in MySQL? Nope. VIEWs currently are not supported in MySQL: http://www.mysql.com/doc/en/ANSI_diff_Views.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is

Re: is CREATE VIEW possible in MySQL?

m: "Oh Chye Yong" <[EMAIL PROTECTED]> To: "Lingua2001" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, 18 June, 2003 01:20 Subject: Re: is CREATE VIEW possible in MySQL? View is not supported in MySQL version 4.x. You have to wait for version 5. You have

Re: is CREATE VIEW possible in MySQL?

View is not supported in MySQL version 4.x. You have to wait for version 5. You have to implement the view functionailty in code. Or maybe someone else has a better suggestion :) OH Chye Yong Software Engineer OpenFeel Pte Ltd Web: http://www.openfeel.com/ Email: [EMAIL PROTECTED] Tel: (+65) 633

is CREATE VIEW possible in MySQL?

If not, is there a way to get the same effect in MySQL? Thanks in advance, Lingua -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL question - no CREATE VIEW in mysql

Luca, > In Oracle I could create a view from the initial table, what about MySQL? MySQL will support views as of version 5.1. I cannot find it in the todo (http://www.mysql.com/doc/en/TODO.html) but I saw it elsewhere. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

SQL question - no CREATE VIEW in mysql

Hi People. SQL problem: given a table where each column is a number, let's say that I wish to create a second table where columns are the sum of specific columns of the first, i.e.: col_1 + col_2 + col_3 + col_4 > col_1 of second table col_5 + col_6 + col_7 + col_8 > col_2 of se