Re: need list of country ISO code to demonyms

I don't have it, sorry. But it took me 10 seconds to copy paste it to an Excel, so I could save it as CSV and import it directly to MySQL. Further on, it'd be as simples as JOIN by name with a table with ISO-to-country-names, which you can fetch in hundreds of places, such as Wikipedia.

Re: need list of country ISO code to demonyms

like that, and paste it into Excel. That darn Microsoft -- they think of everything! :) Thanks for the tip. -Original Message- From: Nuno Tavares [mailto:nuno.tava...@dri.pt] Sent: Wednesday, October 03, 2012 3:10 PM To: mysql@lists.mysql.com Subject: Re: need list of country ISO code

Re: mySQL Query and Report Builder

Hi Don, Have a look at Jasper Reports: http://jasperforge.org/ -NT Em 30-04-2012 17:53, Don Wieland escreveu: Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line

Re: big character constant

Halász, not sure if I understood correcly, but you mysql console/client may have different charsets. This means you should set it accordingly. Check this out: mysql show global variables like '%character_set%'; +--++ | Variable_name

Re: One inst has 39 columns- the other 40

Charles, You should run SELECT @@version on both nodes. It looks like you have different version' schemas. -NT Em 22-03-2012 04:41, Brown, Charles escreveu: Look man, there has to be someone out there that can tell me why one user table has 5 extra columns. Is it version related or my

Re: Script need for dropping databases

Hi unknown, Have a look at database information_schema.TABLES: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='database'; As long as your MySQL version is = 5.1, you don't need a cron script, you can use the MySQL scheduler, create a stored procedure that will run each month. You'll

Re: MySQL Indexes

Neil, whenever you see multiple fields you'd like to index, you should consider, at least: * The frequency of each query; * The occurrences of the same field in multiple queries; * The cardinality of each field; There is a tool Index Analyzer that may give you some hints, and I think it's

Re: very large import

The following page has some nice interesting stuff, assuming you have a reasonable configuration in place (innodb_buffer_pool, etc[1]) http://download.oracle.com/docs/cd/E17952_01/refman-5.5-en/optimizing-innodb-bulk-data-loading.html [1]

Re: How to find values which do not return any tuple in IN clause

create table dim (value varchar(10), primary key(value)); insert into dim values ('aaa'),('bbb'),('ccc'),('ddd'); SELECT tablename.fieldname FROM dim LEFT JOIN tablename ON tablename.fieldname = dim WHERE tablename.fieldname IS NULL; If this is not what intended, I'd suggest you to spend a

Re: How to find values which do not return any tuple in IN clause

Fahim, I was not quite sure I understood you question, but looking at what you're trying to achieve in this example, give a try to my suggestion. You have to bear in mind that you can only GROUP BY values that indeed show up in the results. That means that if ('','y') never show up,

Re: Join based upon LIKE

Dear Jerry, I've been silently following this discussion because I've missed the original question. But from your last explanation, now it really looks you have a data quality kind of issue, which is by far related with MySQL. Indeed, in Data Quality, there is *never* a ready solution, because

Re: how to generate a data set then join with in on fly?

-are-ocurring-during-that-interval/ -- Nuno Tavares DRI, Consultoria Informática Telef: +351 936 184 086 Shawn Green (MySQL) escreveu: On 1/10/2011 18:51, Ryan Liu wrote: Hi, In MySQL, is that possible to generate a data set join with it on fly (without create an temporary table)? e.g

RE: query results group/summed by interval

://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com -- Nuno Tavares +351 93 618 40 86 dri Consultoria Informatica -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to put table definition into another table using SQL?

create table TableDef like TableX ? -- Nuno Tavares DRI, Consultoria Informática Telef: +351 936 184 086 mos escreveu: I'd like to get the field names and data types of a table, say TableX, and put it into TableDef using nothing but SQL. I know I can list the table definition using

Re: logging slow queries with time

General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=nuno.tava...@dri.pt -- Nuno Tavares +351 93 618 40 86 dri Consultoria Informatica -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql