Re: help converting tables to excel format

n the data directory of one existing database connect and use that database export data to an outfile by : select * from yourtable into outfile csv fields terminated by ';' open the csv with excel. Mathias Selon Tom Beidler <[EMAIL PROTECTED]>: I recently received some ol

help converting tables to excel format

I recently received some old database files from my ISP. I'm trying to convert the documents to excel format. When I try to load the .frm, .MYI and .MYD files on my OS X MySQL databases I get the following error. #5 - Out of memory (Needed 3024898224 bytes) Unfortunately I can't work with the

Calendar SELECT with repeating occurance

I¹m developing a calendar, with a view by month and list view, for a client and I would like to add the option for them to add an event and select if it is to repeat, i.e. Annually, monthly, weekly. As I see it now I can do one of two things (possibly more?). Add a predetermined amount of records i

DISTINCT LEFT JOIN

I¹m having problems with a left join. I¹m not even sure if I should be using a left join. I have two tables; sites and site_service. Site_service contains service dates for the sites. I¹m trying to write a query that will select each site and the last service date for that site. A site may have ma

CONCAT in WHERE clause?

I have a database with a first and last name fields that I would like to combine for a search. Basically on my web page interface I would like the end user to fill out one field instead of individual first and last fields. I tried writing a query like so; SELECT id, CONCAT(first," ",last) AS name

LIMIT by column return

I'm trying to write a query that will limit the results but not by the total amount returned like a normal LIMIT. It's an invoice database and I would like to return the last to invoices for a certain job. So if there are 100 jobs with several invoice dates I would like to return a web page displa

possible to loop through increments when end reached?

I have a database of sites for a grounds maintenance company. I want to flag sites for service. Each site has a service order, 1-875. I want to keep 25 sites flagged for service. Once a technician works on a site and posts a service report, I set that sites flag to 'no' and would like to flag the

ORDER and LIMIT dilemma

T 0, 25; I've also tried; SELECT id, name, state, country, status FROM dealer WHERE name LIKE "A%" ORDER BY name, state LIMIT 0, 25 But that didn't work. Any help would be appreciated. Thanks, Tom >>.>>.>>>.>>>>>.

can you "see" an index

Newbie question. I recently altered a table by adding an index. I then DESCRIBEd it and it didn't show an index. Is this correct and if so, how do I know it's there? Thank you, Tom >>.>>.>>>.>>>>>.>>>>>>>>>.>>>&g

DISTINCT list ORDER problem

;Harley-Davidson\" AND status = \"active\"" . " ORDER BY id"; How can I pull up distinct models and order just the distinct models by id? Thanks, Tom >>.>>.>>>.>>>>>.>>>>>>>>>

recommend a good book for connecting from mysql to other dbs

king about strategies of connecting other dbs. I'm looking for a starting point. Maybe I should wait till I have a specific example? Thanks in advance, Tom >>.>>.>>>.>>>>>.>>>>>>>>>.>>>>>>&

Newbie DISTINCT problem

the same name that meets the WHERE parameters and one that doesn't, the name won't appear in my pulldown menu. What am I doing wrong? Thanks, Tom >>.>>.>>>.>>>>>.>>>>>>>>>.>>>>>>>&g