Set Maximum Tables In A Database
DDL Trigger in MySQL?
Find the asymptotic tight bound in  $$ T(n) = 4T\left(\frac{n}{2}\right) + n^{2}\log n. $$  where $ \log n= \log _{2}n $ and $T(1) = 1$.  I should solve this using all three common methods: iteration, master theorem and substitution.  It is highly likely that this kind of recurrence equation will be in my test in two days. Thank you very much in advance! My friend installed Windows 7 on his computer (upgrading from XP).  He wasn't sure if his processor supported x64 or not, so he installed the x86 version, just to be on the safe side.  After I looked it up, it turns out his processor does support x64, and now we want to upgrade.  The question is: is it possible to upgrade without completely re-installing the OS?  Can I? Or do I have to format the C: partition again? Localization of ideals at all primes What do the fields in ls -al output mean? Disfigured Feynman Diagrams! CSS 100% height with padding/margin With HTML/CSS, how can I make an element that has a width and/or height that is 100% of it's parent element and still has proper padding or margins?  By "proper" I mean that if my parent element is 200px tall and I specify height = 100% with padding = 5px I would expect that I should get a 190px high element with border = 5px on all sides, nicely centered in the parent element.  Now, I know that that's not how the standard box model specifies it should work (although I'd like to know why, exactly...), so the obvious answer doesn't work:  #myDiv {     width: 100%     height: 100%;     padding: 5px; }   But it would seem to me that there must be SOME way of reliably producing this effect for a parent of arbitrary size. Does anyone know of a way of accomplishing this (seemingly simple) task?  Oh, and for the record I'm not terribly interested in IE compatibility so that should (hopefully) make things a bit easier.   EDIT: Since an example was asked for, here's the simplest one I can think of:  &lt;html style="height: 100%"&gt;     &lt;body style="height: 100%"&gt;         &lt;div style="background-color: black; height: 100%; padding: 25px"&gt;&lt;/div&gt;     &lt;/body&gt; &lt;/html&gt;   The challenge is then to get the black box to show up with a 25 pixel padding on all edges without the page growing big enough to require scrollbars. One Object won't Show up in Final Render even though it shows up in the Preview Render Is there is a way to exclude nested subdirectory specified by a path to that dir from grep recursive search? Or I have to use ack or find for this?  Here's what I want. Say I have this dir structure:  dir/nesteddir/match.txt otherdir/nesteddir/match.txt   How do I exclude first nesteddir only? Is it even possible using grep?  Most obvious answer $ grep -r --exclude-dir="dir/nesteddir" "stringToFind" . doesn't seem to work, nor do any of my experiments with various --exclude-dir paths using globbing, leading ./, etc.   Reading man page and googling didn't help, the only mention of this usecase I found is this question:   It was concluded that this is bug introduced in grep 2.12, but I'm using latest version (2.16) and grep's bugtracker () doesn't mention anything related to --exclude-dir, so I guess either it was fixed or it's an intended behaviour.   Would be really nice to get some clarification. Best way to start investing, for a young person just starting their career? I am young, just started my career, and looking to begin investing so I can make my money work for me. I'm still living like I did in college (occasional purchase on myself, but most of it goes into savings) and I would like to take the extra money and invest it.   What would you suggest are the best options for me to begin? I was considering getting a personal investor [a financial advisor] for perhaps a year or so, but I've heard that they really are not worth the money. I wanted to get the input of the great minds here. Where is the line drawn with domain names which include a trademark? A search on google for "iphone developer" turns up loads of websites which have "iphone" in them, a trademarked name by Apple.  So I'm led to believe that having a domain such as iphonedeveloper.com is ok? Well, you're still using Apple's trademark, but it would be hard to brand yourself otherwise. You're an IPHONE DEVELOPER... right?  Well, what if I want to provide a website where users pay to get a list of the best offers from Ebay? I might have a domain like ebaydeals.com (I don't... i'm just speculating!).  Now I've heard that places like Ebay are really hot on the trigger and fire out emails to people who register domains like that straight away. But whats the difference?  In both cases I'm making money from the trademark, effectively, so is it just down to how lenient the company who owns the trademark is? Or are there rules? Is there a specific "line" you don't cross?  Thanks How can I let player click text to use a command? I want players to be able to click text to run an OP command even if that player is not an OP. For example something like:  Console: Do you want to enable Fly? [If you do, Please click here]  *Player1 clicks that text*  Console: /fly Player1   Is something like this possible? Im trying to craft a regex that only returns &lt;link&gt; tag hrefs  Why does this regex return all hrefs including &lt;a hrefs?       (?&lt;=&lt;link\s+.*?)href\s*=\s*[\'\"][^\'\"]+        &lt;link rel="stylesheet" rev="stylesheet"      href="idlecore-tidied.css?T_2_5_0_228" media="screen">     &lt;a href="anotherurl">Slash Boxes&lt;/a>   thank you Is there any UNIX variant on which a child process dies with its parent? I'm building a quick csv from a mysql table with a query like:  select DATE(date),count(date) from table group by DATE(date) order by date asc;   and just dumping them to a file in perl over a:  while(my($date,$sum) = $sth-&gt;fetchrow) {     print CSV "$date,$sum\n" }   There are date gaps in the data, though:  | 2008-08-05 |           4 |  | 2008-08-07 |          23 |    I would like to pad the data to fill in the missing days with zero-count entries to end up with:  | 2008-08-05 |           4 |  | 2008-08-06 |           0 |  | 2008-08-07 |          23 |    I slapped together a really awkward (and almost certainly buggy) workaround with an array of days-per-month and some math, but there has to be something more straightforward either on the mysql or perl side.   Any genius ideas/slaps in the face for why me am being so dumb?    I ended up going with a stored procedure which generated a temp table for the date range in question for a couple of reasons:   I know the date range I'll be looking for every time The server in question unfortunately was not one that I can install perl modules on atm, and the state of it was decrepit enough that it didn't have anything remotely Date::-y installed   The perl Date/DateTime-iterating answers were also very good, I wish I could select multiple answers! Not able to see links to chat, logout, or privileges Asymptotic expansion for Fresnel Integrals If you take the fresnel integrals to be $$S(x) = \int_{0}^{x}\sin \left(\frac { \pi \cdot  t^2}{2} \right) dt$$ How do you find the asymptotic expansion? I know it begins with a $1/2$ but how? Is there a way to determine the device running an application. I want to distinguish between iPhone and iPod Touch, if possible. I'm trying to load data from different tables using left outer joins into a QgsVectorLayer. The approach I'm following so far is the one from the developers cookbook . The underlying database is postgres. The query returns correct data, including a geometry column, however I can't figure out how to get the join inside the query to work with . As the table the data come from needs to be specified, is it even possible to do so?  Would approaching the problem using psycopg2 be more suited, and if so, is there a way to create a layer from the result set? The only way I can think of is creating an empty layer and adding each feature individually by looping over the result set. But possibly there is an easier way?  Sadly, using the builtin DB Manager is not an option. The layer has to be added programmatically. I did a dumb thing... I forgot that Ubuntu 10.04 (Lucid Lynx) switched to &nbsp;2 which puts a ton of *.mod files (kernel modules) in /boot/grub. I thought they were soundtrack files put there erroneously, and I moved them. Needless to say, the next reboot was traumatic. I was presented with something I had no memory of ever seeing... a 'grub rescue>' prompt.  With the help of  however, I was able to recover...   I discovered that GRUB rescue does not have 'cd', 'cp' or any other filesystem commands except its own variation of 'ls'. So first I had to find the partition with the /boot directory containing vmlinuz file and other boot image files... (approximation from memory of failed attempts, as well as blank lines for clarity, added 2014-07-10 by docsalvage)    grub rescue&gt;  ls   (hd0,4) (hd0,3) (hd0,2) (hd0,1)    grub rescue&gt;  ls (hd0,4)/boot ... some kind of 'not found' message  grub rescue&gt;  ls (hd0,3)/boot ... some kind of 'not found' message  grub rescue&gt;  ls (hd0,2)/boot ... grub ... initrd.img-2.6.32-33-generic ... vmlinuz-2.6.32-33-generic   I found a /boot directory containing the vmlinuz file vmlinuz-2.6.32-33-generic on partition (hd0,2). Then I manually booted from the 'grub rescue>' prompt. The following commands will...   Set the root to use the /boot directory on partition (hd0,2). Load kernel module linux. Set that module to use the kernel image vmlinuz-2.6.32-33-generic. Set initrd(initialize RAM disk) to use the image initrd.img-2.6.32-33-generic. Boot Linux.  grub rescue&gt;  set root=(hd0,2)/boot   grub rescue&gt;  insmod linux   grub rescue&gt;  linux (hd0,2)/boot/vmlinuz-2.6.32-33-generic root=/dev/sda2 grub rescue&gt;  initrd (hd0,2)/boot/initrd.img-2.6.32-33-generic   grub rescue&gt;  boot    This boots and crashes to the BusyBox prompt which DOES have some rudimentary filesystem commands. Then I moved the *.mod files back to the /boot/grub directory...  busybox&gt;  cd /boot   busybox&gt;  mv mod/* grub busybox&gt;  reboot  The reboot was successful, but that was a lot of work.   Is there an easier way? Whitespace Problems With Script and Variables