A finite semigroup with left and right cancellation is a group.
A finite, cancellative semigroup is a group
I have a MySQL table with utf8 general ci collation. In the table, I can see two entries:  abad abád  I am using a query that looks like this:  SELECT *  FROM `words` WHERE `word` = 'abád'   The query result gives both words:  abad abád  Is there a way to indicate that I only want MySQL to find the accented word? I want the query to only return    abád    I have also tried this query:  SELECT *  FROM `words` WHERE BINARY `word` = 'abád'   It gives me no results. Thank you for the help. Calling a function from a string in C# Showing that $\int_0^\infty x^{-x} \mathrm{d}x \leq 2$. How to divide two 64-bit numbers in Linux Kernel? Some code that rounds up the division to demonstrate (C-syntax):  #define SINT64 long long int #define SINT32 long int  SINT64 divRound(SINT64 dividend, SINT64 divisor) {   SINT32 quotient1 = dividend / divisor;    SINT32 modResult = dividend % divisor;   SINT32 multResult = modResult * 2;   SINT32 quotient2 = multResult / divisor;    SINT64 result = quotient1 + quotient2;    return ( result ); }   Now, if this were User-space we probably wouldn't even notice that our compiler is generating code for those operators (e.g. divdi3() for division). Chances are we link with libgcc without even knowing it. The problem is that Kernel-space is different (e.g. no libgcc). What to do?  Crawl Google for a while, notice that pretty much everyone addresses the unsigned variant:  #define UINT64 long long int #define UINT32 long int  UINT64 divRound(UINT64 dividend, UINT64 divisor) {   UINT32 quotient1 = dividend / divisor;    UINT32 modResult = dividend % divisor;   UINT32 multResult = modResult * 2;   UINT32 quotient2 = multResult / divisor;    UINT64 result = quotient1 + quotient2;    return ( result ); }   I know how to fix this one: Override udivdi3() and umoddi3() with do_div() from asm/div64.h. Done right? Wrong. Signed is not the same as unsigned, sdivdi3() does not simply call udivdi3(), they are separate functions for a reason.  Have you solved this problem? Do you know of a library that will help me do this? I'm really stuck so whatever you might see here that I just don't right now would be really helpful.  Thanks, Chad Could "them" mean "those"? Background Nowadays, I see &quot;them&quot; used to mean &quot;those&quot; a lot. I don't know if it was as common in the past. For example, take &quot;one of &quot;. On researching about it, I found some people say it comes from a dialect of British English. Some others say it is a &quot;non-standard&quot; usage. I see this usage in Canadian English also, and it seems some people use it in a sarcastic way. Moreover, I have seen a song titled &quot;one of them days&quot;. I also read, in the book called &quot;A Broken Promise&quot;, &quot;&quot; Finally, Wikipedia says that it is a usage in  (a common name for the Southern Midland dialect of American English):  Pronouns and demonstratives &quot;Them&quot; is sometimes used in place of &quot;those&quot; as a demonstrative in both nominative and oblique constructions. Examples are &quot;Them are the pants I want&quot; and &quot;Give me some of them crackers.&quot;    Question(s): What would you say about the usage of this word? Is it correct? Could we use it in daily speech? Could this usage go beyond a specific dialect and be used in other dialects, regions, etc.? Does it really originate from Appalachian English? Why did this usage become popular among other English speakers? Note: I have already seen a similar question:  However, it only says, &quot;ungrammatical,&quot; there. This question is specific to this situation only, and there is more to it. I'm looking to have cell borders automatically applied when a cell is not empty. I thought I could use conditional formatting for this, but it doesn't seem to be an option. What is the British English way of referring to a source in-text.  Is it plural because there are two authors, like this:         X and Y (2011) describe ...   Or is it singular because you are referring to a singular source, like this:     X and Y (2011) describes...   So what I am asking is whether you refer to the source or to the authors? Which are safe and unsafe regions in Iran? Now there's a lot of propaganda in the west that leads us to believe Iran is dangerous and travellers shouldn't go there.  Obviously there are major political disagreements between several governments and the Iranian government and this should be taken into account.  But at a human level I have met many Iranians travelling elsewhere in the world and have found them to be friendly, charming, and hospitable. I have also met several western travellers who spent time in Iran, including hitchhiking around the country, who only have wonderful things to say about the country and its people.  As a traveller I've learned to trust the most what I hear from other travellers about a destination, especially ones which prefer similar ways of travel to myself. I've also learned to trust the opinions of inhabitants of countries bordering on the destination country the least.  Yet some people still insist that Iran is not safe for a traveller, or that .  I can look up for myself the general travel advisories issued by governments and disclaimers in WikiVoyage. So please don't regurgitate those an answers.  I want to know from travellers who've been there, from Iranians, or from references to specific incidents targeting foreigners/westers about which parts of Iran are no problem, and which parts should be avoided, even by experienced intrepid travellers.  (I realize any advice won't apply to Israeli citizens unfortunately. I'm Australian.) How to create a database directory structure for MySQL? I was following this tutorial:    So far, I installed mysql-server mysql-client libmysqlclient-dev, and I was suppose to tell MySQL to create its database directory structure where it will store its information using sudo mysql_install_db.  $ sudo mysql_install_db  [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize [ERROR]   The data directory needs to be specified.   I thought running mysqld --initialize would solve the issue:  $ mysqld --initialize   mysqld: Can't create directory '/var/lib/mysql/' (Errcode: 17 - File exists) [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). [ERROR] Aborting   How do I tell MySQL to create its database directory structure where it will store its information? How to use an optimization solver to get t-stats and p-values for the estimates? How to send a header using a HTTP request through a cURL call? I wish to send a header to my Apache server on a Linux box.  How can I achieve this via a cURL call? I have to teach the Bayes formula to some undergraduates, in the form:  $$ P(A|B) = \frac{P(A \cap B)}{P(B)} = \frac{P(B|A)P(A)}{P(B)} $$  I was wondering if anyone had any really thoughtful or alternative ways of teaching it instead of the standard approach. I have heard rumors that you can compile documents online, and more specifically that Google has a free online compiler, but I have never been able to find any. Is there a way to compile documents online, so that I can write and compile documents even if I don't have a TeX distribution installed on my computer? How do I get rid of my bounty? I accidentally killed a noble, now every guard wants to kill me. Is there any way I can get rid of the bounty? Get number of frames in scene from the command line? I'd like to know if there is a command-line option (or combination, or a way!) to get the number of frames that are included in a specified blender scene; for example I'd like to use is like this:  $ blender &lt;option&gt; file.blend $ Number of frames in blender scene: xxxx Lets say I have a loop in Bash:  for foo in `some-command` do    do-something $foo done   do-something is cpu bound and I have a nice shiny 4 core processor. I'd like to be able to run up to 4 do-something's at once.  The naive approach seems to be:  for foo in `some-command` do    do-something $foo &amp; done   This will run all do-somethings at once, but there are a couple downsides, mainly that do-something may also have some significant I/O which performing all at once might slow down a bit. The other problem is that this code block returns immediately, so no way to do other work when all the do-somethings are finished.  How would you write this loop so there are always X do-somethings running at once? How to replace the domain name in a Wordpress database? I have a Wordpress database which was installed in a development environment... thus, all references to the site itself have a fixed IP address (say 192.168.16.2). Now, I have to migrate that database to a new Wordpress installation on a hosting. The problem is that the SQL dump contains a lot of references to the IP address, and I have to replace it with: my_domain.com.  I could use sed or some other command to change the that from the command line, the problem is that there are a lot of configuration data which uses JSON. So what? Well, as you know, JSON arrays uses things like: s:4: to know how many chars an element has, and thus, if I just replace the IP with the domain name, the configuration files will get corrupted.  I used an app for Windows some years ago that allows to change values in a database and takes care of the JSON arrays. Unfortunately, I forgot the name of the app... so the question is: do you know any app that allows me to do what I want? Regard the diff equation:  $mϕ′′+aϕ′+(mg/L)ϕ=0$  $ϕ(0)=0.1$  $ϕ′(0)=0$  where $m=0.1,L=1,a=2,$  1) Rewrite the second order diff equation as a system of first order linear equations.  2) What is the matrix that comes from the rewritten equations? Case insensitive 'Contains(string)' Clock time is off on dual boot