I have started using mySQL workbench (Version 6.3.4.0) and I have used the EER Diagram tool to design a schema. So far, so good. However, when I try and run the Forward Engineering, I get the error below.      "ERROR: Error 1064: You have an error in your SQL syntax; check the   manual that corresponds to your MySQL server version for the right   syntax to use near 'COMMENT '') ENGINE = InnoDB' at line 8"   I've not edited it at all, this is purely the automatic code.  If I remove the "COMMENT ''" from the primary key, then it runs, but it doesn't create any tables on my server.  -- Table `mrcatalogue2`.`Location` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mrcatalogue2`.`Location` (   `chromosome` VARCHAR(2) NULL COMMENT '',   `position` VARCHAR(10) NULL COMMENT '',   `hg19_coordinates` VARCHAR(15) NOT NULL COMMENT '',   PRIMARY KEY (`hg19_coordinates`)  COMMENT '') ENGINE = InnoDB;
Every time I try to create a table using MySQL Workbench 6.3 CE it adds "broken" comments at the end of the script.  Example:  I am trying to create a table called "user". This is what the table should look like:   However when I click the apply button, the script generates incorrectly:  CREATE TABLE `user` (   `userid` INT NOT NULL AUTO_INCREMENT COMMENT '',   `record_status` INT NOT NULL DEFAULT 1 COMMENT '',   `createdby` VARCHAR(75) NOT NULL COMMENT '',   `createddate` DATETIME NOT NULL COMMENT '',   `updatedby` VARCHAR(75) NULL COMMENT '',   `updateddate` DATETIME NULL COMMENT '',   `username` INT NOT NULL COMMENT '',   `password` VARCHAR(75) NULL COMMENT '',   `firstname` VARCHAR(75) NULL COMMENT '',   `lastname` VARCHAR(75) NULL COMMENT '',   `email` VARCHAR(75) NULL COMMENT '',   `facebook_userid` VARCHAR(75) NULL COMMENT '',   `email_verified` VARCHAR(75) NULL COMMENT '',   PRIMARY KEY (`userid`, `username`)  COMMENT '');   The comment in this line should not be there, so the code should be:   PRIMARY KEY (`userid`, `username`));   and the code executes when I paste it into an editor and remove this comment. However I create massive databases daily. (Each with +- 15 tables). I can't keep doing this for each table as it is time consuming.  How can I disable this feature that adds the comments to the script? I don't need them in my databases
Decrease Backlight Below Minimum I have this laptop that doesn't handle the backlight very well.  In /etc/default/grub, I have added a acpi_backlight=vendor function to get it to work at all. Which is cool, and the backlight now actually works, but the minimum backlight setting is still pretty high.  Is there any way to decrease the backlight below minimum? I don't mind having to type in the terminal to do that, as I won't need to do it often (just at night etc.) How to Improve Mathematical Thinking and General Problem Solving Skills? I'm a sophomore in university and seriously feel that I'm bad at solving mathematical and algorithmic problems (be it discrete math, calculus or just puzzles). I noticed that I'm only good at solving questions that are similar to the ones that have been taught to us.  Here's how I generally approach it:   What is the problem? What do I need to do here? Does it look like I've encountered this before?  Can I think of a smaller problem to solve instead?   If the answer is no to all the above then I sort of blank out. I stare at it and force my brain to run through a wide variety of stuff, almost like a brute force attempt of solving it. Obviously that leads me to nowhere everytime. I simply can't think "outside the box."   What can I do to improve my situation? Do individual rays of light lose energy via the inverse square law? What happens to folks who get question banned, by and large? There is a steady stream of duplicates of  coming in lately. It's got me wondering. Roughly speaking, out of say 100 folks who get this ban, how many    wander away and never interact with SO again?   do the sorts of things that might lift a ban, but don't get it lifted? do the sorts of things they should, and lift the ban? post a question of their own on Meta which we close as a dupe?   Among the continue-to-interact folks, is there a difference in success rate between those who post on Meta about it (motivated, but not good rules-readers, who nonetheless get customized advice) and those who do not (better rules readers, but working to some extent blind) - which do better?  Is there a reasonable chance of recovering from a ban, assuming you care enough to try? Is $\{\frac{m}{10^n}\mid m,n\in\mathbb Z,\ n\geq 0\}$ dense in $\mathbb R$? The set $S$ of real numbers of the form $m/10^n$, $m,n$ integers and $n$ greater than or equal to $0$, is a dense subset of $\mathbb R$ or not??   I know dense means closure of $S$ in $\mathbb R$ is $\mathbb R$ then it will be dense. How to prove or disprove I have no idea. How can I kill a thread? without using stop(); A Google search spewed forth millions of hits on how to find tables without clustered indexed, the PK normally being the clustered index of a table. However, a table could easily have a natural key as a clustered index, and a non-clustered surrogate index, like an identity column.  How do I find all tables in a DB without a primary key defined? I have 245 tables in this DB: manual inspection is grossly inefficient. Help resizing posted images I often add pictures to my questions. Most of the time they come out the right size. Well, that used to be OK always, up until I started posting screenshots taken by my mobile. For example, this one:  This way, I'm sure you'll agree it is huge, decidedly too big, it takes up the whole body of the question, I mean. At present, the only way I have to resize it is the following code: &lt;sub&gt;(Click image to enlarge)&lt;/sub&gt;  [&lt;img src=&quot;http://i.stack.imgur.com/hKmRp.jpg&quot; width=&quot;210&quot; height=&quot;350&quot; alt=&quot;&quot;&gt;][1]  which I do not remember, and always have to recover from . Is there a simpler, less HTML-hacky (and, I'd expect, more Markdown-based) way of resizing it? PS The output of the above code is: (Click image to enlarge) Can I find out the return value before returning while debugging in Visual Studio? Take the following function:  DataTable go() {     return someTableAdapter.getSomeData(); }   When I set a breakpoint in this function, is there a possibility to inspect the returned value? go() is directly coupled to a datagrid in an .aspx page.  The only way to inspect the returned datatable is to use a temporary variable. However, that's a bit inconvenient. Isn't there another way? An annulus in $\mathbb R^2$ is path connected Let $A = \{(x,y) \in\mathbb{R}^2: a \leq (x-c)^2+(y-d)^2 \leq b\}$ for given $a,b,c, d$ real numbers. I want to show that $A$ is path-connected.  How can I do that?  I know that every open subset of $\mathbb R^2$ that is connected is path connected. But this is obviously not open so I cannot use that. Then I thought of multiple cases. If we take arbitrary $x$ and $y$ and draw the line between them and they do not intersect with the circle centred at $(c,d)$ then we can obviously draw a line between the points which is still in the set, so we can then define the function. I am stuck on the other case. How to use GCC 4.7 in place of 4.6? So I'm working on a project and I wanted to use some C11 features for C. To use those features GCC 4.7 is required, so I went to synaptic and looked up 4.7, and I found the packages gcc-4.7-base so I installed it[1].   So now that gcc-4.7-base is installed I expected to be able to use 4.7, but no, when I do gcc --version it still shows 4.6.3 even more, when I try to directly call 4.7(via /usr/bin/gcc-4.7) it doesn't exist, though a gcc-4.6 executable does exist.  How do I "activate" GCC 4.7? I read , you do some crazy stuff with update-alternatives, but it doesn't work for me as the gcc-4.7 executable doesn't actually exist on my machine.   Notes: 1. I also saw gcc-4.6-base, so I figured I'd uninstall it, but synaptic attempted to remove every package I had installed and install a Java runtime, so for obvious reason I decided not to remove it. If I have multiple objects selected can I use scaling to make the objects closer together (without rescaling the objects)? Arguably the most famous scene in Star Wars is when Darth Vader reveals to Luke Skywalker that      He is Luke's father.   This surprise was kept secret to most of the crew and even the cast , with Dave Prowse, the actor playing Darth Vader, delivering a fake line, the actual line being overdubbed. (Of course, Darth Vader wasn't voiced by him in the first place; all lines were overdubbed by James Earl Jones).   Like Mark Hamill relates in :     But, for example, your big scene, one of the classic cinematic moments when Darth Vader divulges his true identity, is no longer a revelation.       It's such a great moment! The fake line that was put in there just to try and keep the secret was "You don't know the truth: Obi-Wan killed your father!" But as much as I enjoyed leaking false information, it was a wonderfully hard secret to keep because (Irvin) Kershner, the director, brought me aside and said "Now I know this, and George knows this, and now you're going to know this, but if you tell anybody, and that means Carrie or Harrison, or anybody, we're going to know who it is because we know who knows."   So how do we explain ?       And [David Prowse] offered a glimpse of a possible plot for the second sequel. Darth Vader and Luke Skywalker, the young hero in the first film played by Mark Hamill, are hooked up in a do-or-die light saber duel when Luke learns that Darth is, in fact, his long-lost father.   So exactly how secret was this secret anyway?    As DVK points out , the newspaper article is probably authentic. How can I exclude API keys, passwords, and so on from configuration management? I am using Drupal 8 and drush cex to commit my configuration to my repository.  However, I want to keep passwords and API keys out of the repository.  How do I do that? (selectively exclude sensitive information from configuration management).  For example, I'm using the  module, but I noticed that in addition to the SMTP server and sender's name, etc., it also exports the API key to code, which should not be exposed.  I want to manage module configuration with configuration management, but I don't want to commit the key. Is there a correct gender-neutral singular pronoun ("his" vs. "her" vs. "their")? Number of non-decreasing functions? Let $A = \{1,2,3,\dots,10\}$ and $B = \{1,2,3,\dots,20\}$. Find the number of non-decreasing functions from $A$ to $B$.  What  I tried: Number of non-decreasing functions = (Total functions) - (Number of decreasing functions) Total functions are $20^{10}$. And I think there are ${20 \choose 10}$ decreasing functions. Since you choose any $10$ codomain numbers and there's just one way for them to be arranged so that the resultant is a decreasing function. However my answer doesn't match. Where am I going wrong? How can I directly compute the non-decreasing functions like without subtracting from total? Copy Physics To Multiple Objects Using the cell fracture addon, I created many objects from my mesh. I want to have a rigid body physics on all of them. How would I copy one of the fractured pieces physics to all the pieces? I tired ctrl L and the copy attributes addon, but none of them have the option. Any help is great. How to get keycodes for xmodmap? I'm trying to use xmodmap to remap Alt / Super keys on Dell L100 keyboard, and have trouble getting the keycodes.  For instance, using xev doesn't give me keycode for Alt   FocusOut event, serial 36, synthetic NO, window 0x4a00001,     mode NotifyGrab, detail NotifyAncestor  FocusIn event, serial 36, synthetic NO, window 0x4a00001,     mode NotifyUngrab, detail NotifyAncestor  KeymapNotify event, serial 36, synthetic NO, window 0x0,     keys:  122 0   0   0   0   0   0   0   0   0   0   0   0   0   0   0               0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0      For Right Super key, xev and showkey give different keycodes -- 134 and 126 respectively.  What's going on with these keycodes?  I tried getting keycodes from showkey -k, and using xmodmap file below, but that gave a weird map which remapped b key:  clear Mod1 clear Control keycode 125 = Meta_L keycode 126 = Meta_R keycode 58 = Control_L keycode 56 = Control_L keycode 100 = Control_R add Control = Control_L Control_R add Mod1 = Meta_L Meta_R I have an upcoming trip where I will be flying to and from Copenhagen, through Toronto.  I notice that my departure and return gate in the Philadelphia airport is not in the international terminal.  Where will I clear customs? Mavericks unusually high RAM usage I thought Mavericks was suppose to utilize RAM memory better, thus run smoother.  Running ML on Mac mini 2012, with 16GB RAM...always running smoothly even with over a dozen apps running.  Now, after installing Mavericks, my Mac is SLOW, eating up RAM like crazy! Looking over usage, of the 16GB of installed memory...on average it uses 10-14 GB RAM when barely running a few apps!!!   There is this kernel_task that is always running with over 1GB of RAM and most apps are not taking that much RAM, so what is using up all my RAM?! File cache? It shows very high in that new description, with about 1/3 of my total RAM