Re: Mysql Finding the country name from country prefix

. If the database contains only real country codes, no. Then there will be at most one match for any number, and if the set of country codes is complete there will be exactly one match for any real and complete phone number. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: case insensitive search

that you read the relevant part of the manual, and if you still have problems after that, return to this mailing list with a detailed question. http://www.mysql.se/doc/refman/5.0/en/charset.html Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Country codes

exactly the order you need if you're parsing a phone number where you don't know beforehand how many digits are the country code. I suppose you could call it alphabetical order, only it's applied to digits instead of letters. Björn Persson -- MySQL General Mailing List For list archives: http

Re: Database IDs

Gleb Paharenko wrote: Really, in my opinion, it contradicts with the manual. Please, send me the bug id in case you'll report the bug. It turns out that it was reported nearly a year ago: http://bugs.mysql.com/bug.php?id=6880 Björn Persson -- MySQL General Mailing List For list archives: http

Re: case insensitive search

/refman/5.0/en/charset.html Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Finding the country name from country prefix

Rhino wrote: If you parsed the first example, you might assume that I am in Brazil, because '55' is the country code for Brazil. (Country codes '5' and '555' are not in use at present.) And they never will as long as 55 is in use, because then phone numbers would become ambiguous. Björn

RE: Database IDs

on its own? Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database IDs

(), 'b3'); insert into parent (value) values ('c'); insert into child (parent_ID, value) values (last_insert_ID(), 'd1'), (last_insert_ID(), 'd2'), (last_insert_ID(), 'd3'); select * from child; Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Database IDs

.) On a third box (4.1.14) it seems to work sometimes and fail sometimes. I think what happens when it fails is that the second last_insert_ID() gets the ID of the first row in the same query. I suppose I should file a bug report then? Björn Persson -- MySQL General Mailing List For list archives

Re: With Rollup wrong results

(log.product), 2) AS 'Total' For the summary line that means Pick a price field at random (as there are several rows to choose from) and multiply it with the count of all the log.product fields. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Best Fieldtype to store IP address...

that and store them all as IPv6 addresses. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with collation...

as messed up as the imported data. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database IDs

) values (last_insert_ID(), 1), (last_insert_ID(), 2); I've looked in the manual for details on which order that statement is processed in, but I haven't found an answer. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Triggers that handle multiple events (insert and update)

onsdagen den 9 november 2005 18:07 skrev Burke, Dan: For example, one field has to be = 0, so I put this validation Why don't you just declare that field as unsigned? Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Delete all but the newest 100 records?

not in (select ID from x order by timestamp desc limit 100); Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Add New User

='testUser'; granted those privileges on _all_ databases. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Are functions evaluated before or during insertion?

, or are functions supposed to be evaluated before insertion starts? 2: Whichever order a query is processed in, wouldn't it be better to always do things in the same order? Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http