Bug #51290 Implement declare variable %rowtype
Submitted: 18 Feb 2010 18:30 Modified: 18 Feb 2010 18:38
Reporter: Vicente Salvador Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[18 Feb 2010 18:30] Vicente Salvador 
Description:
Please, implement variable declaration with type referencing to table.column type. This is done in all SQL engines like Oracle, Postgres or Informix.

Syntax could be oracle compatible:

DECLARE m_myvariable tabname.colname%TYPE;

Or like IBM-Informix

DECLARE m_myvariable LIKE tabname.colname;

How to repeat:
It's a feature request. Just a syntax implementation. Reproducible always.
[18 Feb 2010 18:38] Valeriy Kravchuk 
This is a duplicate of Bug #3286.
[10 Aug 2010 5:24] shaffy kathpal 
Nice article
[22 Jan 2019 17:19] vincent tang 
why not allow??? why not no now???