Dushy_Squirt

Hi, I have imported a delimited text file into a MySQL database and one of the fields did not import correctly. In my import file I have a field formatted as text using text qualifiers that contains a mixture of fractional values and some integers but it is all formatted as text. When importing into MySQL the fractional part is being replaced by a question mark symbol, for example the value of 2¾ is imported as 2?. I have set the field value in MySQL as text but it still imports wrongly. Any advice most appreciated. Thx Dushy_Squirt

It is the query builder with graphical objects that I am looking for. Rgds Dushy_Squirt

Hi, Has anyone please got a working link to a safe download of the MySQL Query Browser? It is listed as one of the archives on the MySQL site but there is no download available? Is this functionality available in the MySQL Workbench, if it is I will download that? Rgds Dushy_Squirt

I am not sure if this is suitable for a small hobbyist group with limited funds?

It looks good, the selection boxes work nice and its a quick refresh of the data. I am hoping to do something similar for some sports stats and would be grateful for some info on what applications you used to build the site and how the raw data for the stats is stored and retrieved? Dushy_Finger

Hi, Would anyone please be able to let me know if there are any frameworks that are suitable for a data reporting tool based on a MySQL database? In particular, something that would be suitable for a total novice would be preferable. I have a single table in a MySQL database that I would like to act as data provider for a series of web pages in which the user can make selections in search boxes, submit the page, and get the result returned to the browser. The requests to the database would only be selections, no creation, deletion or updating of records, however, some of the requests would involve aggregation and grouping of the selected records using conditions. My level of experience with php and html is pretty much nil, however, I am OK with the MySQL side of things and can create the database and table OK. If it is beyond the capabilities of a total novice then I will try to find a developer who can configure something for me. I would prefer to try to do it myself as the need is only for a small enthusiast hobby group with limited funds. Any advice most appreciated. Rgds Dushy_Squirt

Hello, Just joined up so hello everyone.