awk script reading from mysql db?

[ianicr]

Is there a way to make an awk script query a mysql database rather than looking at a file? eg echo select * from table |mysql -u1234

Thanks

 

[vgersh99]

echo select * from table |mysql -u1234 | awk -f myAWKscript.awk

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[ianicr]

How about using it in a getline? eg something like:
getline <`echo &quot;select * from table&quot; |mysql -u1234`