Does anyone know if there's a way to create a select statement where the FROM clause references tables listed in a field from another table?
So, for example let's say I have a database that stores data on 3,000 different stocks accross the nyse. Assume each stock has its own table with the...
When I run SELECT field_01 FROM table_01, where field_01 is of type TEXT, mySQL returns a broken table with the rows all miss-aligned.
Could this be because TEXT is a variable-length type? Is there a fix for this? Can the contents of a field be wrapped so to fit within the table?
I'm trying to build a mySQL database around 2 years of historical stock quotes for all tickers on nyse. The problem is some stocks use funny characters in their ticker symbols and company names (i.e., CD~ is one symbol). When I try to create table names and add records with these characters...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.