kme + solution   2581

mysql - Increment autoincrement id field by one - Stack Overflow |
I see no good reason for this. Only problems. Before running the folowing statement, check if you have FOREIGN keys defined, that reference this id. Are they set to ON UPDATE CASCADE? Also, do you have any triggers that are related to this table?

But first consider, why you (think you) need this. Is it going to be used for ordering the table? In that case, as @Mark pointed, you should use a separate column to specify your desired order.

If, however, you decide you really want this, use:
<code class="language-sql">
UPDATE myTable
SET id = id + 1
WHERE id >= 53
ORDER BY id DESC;</code>
mysql  sql  dba  primarykey  autoincrement  solution 
3 hours ago by kme
python - Control formatting of the argparse help argument list? - Stack Overflow |
Still wraps the help text to 80 columns, I think, rather than the terminal width.

I like this solution of putting all the arguments in a list, though.
You could supply formatter_class argument:
<code class="language-python">parser = argparse.ArgumentParser(prog='tool',
formatter_class=lambda prog: argparse.HelpFormatter(prog,max_help_position=27))

args = [('-u', '--upf', 'ref. upf', dict(required='True')),
('-s', '--skew', 'ref. skew', {}),
('-m', '--model', 'ref. model', {})]
for args1, args2, desc, options in args:
parser.add_argument(args1, args2, help=desc, **options)

python  argparse  argumentparsing  commandline  cli  sortof  solution 
11 hours ago by kme
Mechanics of Flite - Hash-based workarounds for MySQL unique constraint limitations |
In the past I have written about MySQL’s limitations that prevent you from creating an index over a certain length, or with more than a certain number of columns. I’ve offered some solutions for those problems, but many of my solutions hit another limit further down the line. For example innodb_large_prefix allows you to create an index on larger columns, but only up to 3072 bytes, and my workarounds for the 16 column limit per index will also hit that 3072 byte limit once you add lots of columns or add some very long columns.
mysql  indexing  primarykey  workaround  dba  webdevel  devel  solution 
15 hours ago by kme
python - SQLAlchemy blocked on dropping tables - Stack Overflow |
In my case the "waiting for table metadata lock" was because I had an uncommitted session in another IPython session.
python  dba  sqlalchemy  mysql  errormessage  solution 
2 days ago by kme
How do I determine the size of an object in Python? - Stack Overflow |
The Pympler package's asizeof module can do this.

Use as follows:
<code class="language-python">
from pympler import asizeof

Unlike sys.getsizeof, it works for your self-created objects. It even works with numpy.
python  syntax  sizeof  solution 
2 days ago by kme
How can I represent an 'Enum' in Python? - Stack Overflow |
You can also easily support automatic enumeration with something like this:
<code class="language-python">def enum(*sequential, **named):
enums = dict(zip(sequential, range(len(sequential))), **named)
return type('Enum', (), enums)</code>

and used like so:
<code class="language-python">
>>> Numbers = enum('ZERO', 'ONE', 'TWO')
>>> Numbers.ZERO
>>> Numbers.ONE
python  syntax  enum  shim  solution 
3 days ago by kme
python - Are Mixin class __init__ functions not automatically called? - Stack Overflow |
<code class="language-python">class MixedClass2(SomeMixin, MyClass):

>>> m = MixedClass2()
mixin before
mixin after</code>

The pattern @Ignacio is talking about is called cooperative multiple inheritance, and it's great. But if a base class isn't interested in cooperating, make it the second base, and your mixin the first. The mixin's __init__() (and anything else it defines) will be checked before the base class, following Python's MRO.

But also note:
Have the base class invoke super().__init__() even though it is a subclass of object. That way all the __init__() methods will be run.
<code class="language-python">
class BaseClassOne(object):
def __init__(self, *args, **kwargs):
super(BaseClassOne, self).__init__(*args, **kwargs)
print (" base ")
python  inheritance  mixins  multipleinheritance  syntax  oop  solution 
3 days ago by kme
introspection - Getting the class name of an instance in Python - Stack Overflow |
Have you tried the __name__ attribute of the class? ie type(x).__name__ will give you the name of the class, which I think is what you want.
<code class="language-python">>>> import itertools
>>> x = itertools.count(0)
>>> type(x).__name__
python  class  oop  syntax  solution 
3 days ago by kme
GitHub - abrookins/WrapToColumn: an Intellij/PyCharm/RubyMine etc. plugin that wraps selected text to the column width setting |
This plugin wraps text to a maximum line width, as defined in the section "Setting the maximum line width." It is intended as a replacement for the gq command in Vim and fill-paragraph in Emacs.
vikeybindings  intellij  pycharm  extension  plugin  keybinding  workaround  solution 
3 days ago by kme
windows - Get user's non-truncated Active Directory groups from command line - Stack Overflow
GPRESULT is the right command, but it cannot be run without parameters. /v or verbose option is difficult to manage without also outputting to a text file. E.G. I recommend using
<code style="language-batch">
:: Ensure C:\Dev\me.txt exists
gpresult /user myAccount /v > C:\dev\me.txt

Another option is to display summary information only which may be entirely visible in the command window:
<code style="language-batch">gpresult /user myAccount /r</code>
windows  usermanagement  commandline  groupmembership  dammitbrain  solution 
3 days ago by kme
dual boot - How to get grub2 to remember last choice? - Ask Ubuntu -
The documentation in this case is wrong. All variables in /etc/default/grub start with GRUB_, so it's GRUB_DEFAULT=saved, not DEFAULT=saved. I've corrected the Ubuntu wiki to reflect that.

The official grub manual describes this correctly:

Put the following in /etc/default/grub:
<code class="language-bash">

Then run:
<code class="language-bash">
sudo update-grub
linux  windows  grub  grub2  dualboot  bootmanager  configfile  configsetting  dammitbrain  solution 
3 days ago by kme
Help:Link - Meta |
For external links, it is not possible to add a title attribute to the href element. However, the same effect can be obtained with a span:<code>[ <span title="hover text on external link"> web site</span>]</code>
mediawiki  wikitext  links  solution 
4 days ago by kme
astanin / python-tabulate / issues / #135 - Row length — Bitbucket
<code class="language-python">>>> table_multiline = [[textwrap.fill(row[0], width=12)]+row[1:] for row in table]</code>
python  textwrapping  textprocessing  newlines  whitespace  fuckina  solution 
9 days ago by kme
How do you set a default value for a MySQL Datetime column? - Stack Overflow

In version 5.6.5, it is possible to set a default value on a datetime column, and even make a column that will update when the row is updated. The type definition:

<code class="language-sql">CREATE TABLE foo (
mysql  dba  timestamps  dateandtime  mysql56  sortof  solution 
9 days ago by kme
python - pip install from git repo branch - Stack Overflow |

Prepend the url prefix git+ (See VCS Support):
<code class="language-bash">pip install git+</code>

And specify the branch name without the leading /.
python  pip  packagemanagement  sysadmin  deployment  git  solution 
10 days ago by kme
python - catching SQLAlchemy exceptions - Stack Overflow
To catch any exception SQLAlchemy throws:
<code class="language-python">from sqlalchemy import exc
except exc.SQLAlchemyError:
pass # do something intelligent here</code>

See help(sqlalchemy.exc) and help(sqlalchemy.orm.exc) for a list of possible exceptions that sqlalchemy can raise.
python  flask  sqlalchemy  exceptionhandling  solution 
11 days ago by kme
Flask, WTForms, and duplicate IDs |
This actually works fine; I don't see what's so suboptimal about it.
Currently I do the following (I hope the code is clear enough):

<code class="language-python">
@app.route('/create', methods=('GET', 'POST'))
def create():
form = IUser()
if request.method == 'POST' and form.validate():
user = User()
except DuplicateKeyError: # I wish MySQLdb would have
# something like this
from.username.errors.append('Duplicated user name.')
flash('User "%s" created.' %['username'])
return redirect(url_for('manage.users.index'))
return render_template('users/create.html', form=form)

but it feels suboptimal. Suggestions?

See also
<code class="language-python">class Unique(object):
""" Validator that checks field uniqueness """
def __init__(self, model, field, message=None):
self.model = model
self.field = field
if not message:
message = u'This element already exists'
self.message = message

def __call__(self, form, field):
check = self.model.query.filter(self.field ==
if check:
raise ValidationError(self.message)
python  flask  wtforms  webdevel  forms  validation  solution 
11 days ago by kme
What is cmake equivalent of 'configure --prefix=DIR && make all install '? - Stack Overflow |
You can pass in any CMake variable on the command line, or edit cached variables using ccmake/cmake-gui. On the command line,
<code class="language-bash">cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr . && make all install</code>

Would configure the project, build all targets and install to the /usr prefix. The type (PATH) is not strictly necessary, but would cause the Qt based cmake-gui to present the directory chooser dialog.
cmake  build  toolchain  devel  dammitbrain  solution 
15 days ago by kme
command line - Why does XMLStarlet return additional whitespace/newline for XML text nodes? - Super User |
I thought I got this to work, but in the end I still had to pipe it all through
<code>tr -ds '[:blank:]\r' '' | sed '/^$/d'</code>
<code>xmlstarlet sel -T -t -v "//node/item" file.xml</code>

and it outputs the content of
<code class="language-xml"><node><item>content</item></node></code>

as text without additional whitespace.
xml  xslt  xpath  whitespace  textprocessing  webdevel  almost  solution 
16 days ago by kme
html - XPath with optional element in hierarchy - Stack Overflow |
My answer was to just use two piped XPath expressions. This seems to work if you have something like 'saxon-lint' that understands it, though:
In XPath 2.0, the optional step can be expressed as (tbody|.).
xpath  xpath2  patternmatching  xml  webdevel  solution 
16 days ago by kme
nagative aurument in converter.rb:417 · Issue #12 · ttscoff/mdless |
I got this error without having 'pygmentize' installed:

<code>$ mdless --width=80
/Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:428:in `*': negative argument (ArgumentError)
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:428:in `block (2 levels) in convert_markdown'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:424:in `map'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:424:in `block in convert_markdown'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:404:in `gsub!'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:404:in `convert_markdown'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:118:in `block in initialize'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:106:in `each'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/lib/mdless/converter.rb:106:in `initialize'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/bin/mdless:17:in `new'
from /Users/username/.gem/ruby/2.3.0/gems/mdless-0.0.10/bin/mdless:17:in `<top (required)>'
from /Users/username/.gem/ruby/2.3.0/bin/mdless:23:in `load'
from /Users/username/.gem/ruby/2.3.0/bin/mdless:23:in `<main>'</code>
markdown  viewer  errormessage  ruby  workaround  solution 
16 days ago by kme
command line - Markdown Viewer - Unix & Linux Stack Exchange |
Brett Terpstra's 'mdless' is still prettier, and it's as easy as a 'gem install mdless'.
markdown  terminal  commandline  cli  viewer  workaround  solution 
16 days ago by kme
How do you run a perl script using a custom perl build from an AppleScript? |
The solution for me was to change the shebang line to use "#!/usr/bin/env perl"; totally worked when I got the error message

<code>$ ./
dyld: lazy symbol binding failed: Symbol not found: _Perl_xs_handshake
Referenced from: /Users/kernst/perl5/lib/perl5/darwin-thread-multi-2level/auto/XML/LibXML/LibXML.bundle
Expected in: flat namespace

dyld: Symbol not found: _Perl_xs_handshake
Referenced from: /Users/kernst/perl5/lib/perl5/darwin-thread-multi-2level/auto/XML/LibXML/LibXML.bundle
Expected in: flat namespace

Trace/BPT trap: 5</code>

attempting to run saxon-lint with Perl 5.24 from MacPorts.
macports  perl  mac  osx  dyld  dynamicloader  errormessage  sortof  solution 
16 days ago by kme
python - Does PyCharm support Jinja2? - Stack Overflow |
Yeah, you need the "pro" version for full support, but to some extent, you can just add the keywords for a new file type (Preferences -> General -> File Types) by yourself.
pycharm  intellij  idea  jinja  jinja2  syntaxhighlighting  sortof  workaround  solution 
17 days ago by kme
jinja2 code formatting – IDEs Support (IntelliJ Platform) | JetBrains |
Hi Ivan, formatting of jinja2 templates works in PyCharm. Do you have jinja2 selected as template language on the Template Languages settings page (

Seems to be supported only in the "pro" version.
pycharm  intellij  idea  jinja  syntaxhighlighting  sortof  solution 
17 days ago by kme
[CentOS-announce] Announcing release for MySQL 5.5 and 5.6 on CentOS Linux 6 x86_64 SCL |
Both the collections include no client library and client applications are advised to use the client library available in mysql-libs package from base system.
mysql  mysql55  centos6  libmysqlclient  library  build  errormessage  annoyance  solution 
17 days ago by kme
linux - Find pid of a certain ssh instance - Super User |
What I actually did was *not* put 'ssh' in the background (no '-f') and then capture the PID with '$!'.
Give pgrep a go:
<code class="language-bash">pgrep -f 'ssh .* -nNCTR'</code>
ssh  backgroundprocess  sshtunnels  processmanagement  unix  tipsandtricks  worksok  solution 
17 days ago by kme
python - Booleans in ConfigParser always return True - Stack Overflow |
Use getboolean():

<code class="language-python">print config.getboolean('main', 'some_boolean')
print config.getboolean('main', 'some_other_boolean')</code>

From the Python manual:

RawConfigParser.getboolean(section, option)

A convenience method which coerces the option in the specified section to a Boolean value. Note that the accepted values for the option are "1", "yes", "true", and "on", which cause this method to return True, and "0", "no", "false", and "off", which cause it to return False. These string values are checked in a case-insensitive manner. Any other value will cause it to raise ValueError.
python  webdevel  configfile  configparser  solution 
17 days ago by kme
javascript - How can I change the default width of a Twitter Bootstrap modal box? - Stack Overflow |
Note 3: In Bootstrap 3 and 4, there is a modal-lg class. So this may be sufficient, but if you want to make it responsive, you still need the fix I provided for Bootstrap 3.

You need to use this like this:
<code class="language-html">
<div class="modal fade" id="{{ modal_window_id }}" tabindex="-1" role="dialog" aria-labelledby="{{ modal_label_id }}">
<div class="modal-dialog modal-lg" role="document">
{# bootstrap version > 3.1.0 required for this to work #}
<div class="modal-content">

For Boostrap < 3:
<code class="language-css">body .modal-admin {
/* new custom width */
width: 750px;
/* must be half of the width, minus scrollbar on the left (30px) */
margin-left: -375px;
bootstrap  css  ui  webdevel  solution 
18 days ago by kme
How do I find which file Perl loaded when I use a module? - Stack Overflow |
Best solution I've found:

<code class="language-bash">
$ perldoc -lm List::Util

See also:
perl  wherefrom  whereis  module  library  PERL5LIB  solution  devel 
19 days ago by kme
Symkat - Find a Perl Module's Path |
<code class="language-bash">
$ perldoc -lm List::Util

Using Perl itself (maybe `perldoc` isn't installed):
<code class="language-perl">#!/usr/bin/perl
use warnings;
use strict;

for my $module ( @ARGV ) {
my $package = $module;

# From This::That to This/
s/::/\//g, s/$/.pm/ for $module;

if ( require $module ) {
print $package . " => " . $INC{$module} . "\n";
perl  devel  library  PERL5LIB  whereis  wherefrom  annoyance  dammitbrain  solution  module 
19 days ago by kme
mysql - Insert auto increment primary key to existing table - Stack Overflow |
This is interesting, but I don't know how it could work:

You can add a new Primary Key column to an existing table, which can have sequence numbers, using command:
<code class="language-sql">ALTER TABLE mydb.mytable ADD pk_columnName INT IDENTITY
dba  mysql  sql  newbie  syntax  primarykey  altertable  solution 
29 days ago by kme
sql - Update one MySQL table with values from another - Stack Overflow |

<code class="language-sql">UPDATE tobeupdated
INNER JOIN original ON (tobeupdated.value = original.value)
SET =</code>

That should do it, and really its doing exactly what yours is. However, I prefer 'JOIN' syntax for joins rather than multiple 'WHERE' conditions, I think its easier to read

As for running slow, how large are the tables? You should have indexes on tobeupdated.value and original.value

EDIT: we can also simplify the query
<code class="language-sql">UPDATE tobeupdated
INNER JOIN original USING (value)

USING is shorthand when both tables of a join have an identical named key such as id. ie an equi-join -
dba  sql  innerjoin  solution  newbie 
29 days ago by kme
MySQL's INSERT IGNORE INTO & foreign keys - Stack Overflow |
INSERT IGNORE turns INSERTS that don't meet a primary key constraint into warnings (try SHOW WARNINGS right after0.
dba  mysql  sql  newbie  solution 
4 weeks ago by kme
MySQL :: MySQL 5.7 Reference Manual :: 10.3.1 Collation Naming Conventions |
<code>Table 10.1 Collation Case Sensitivity Suffixes
Suffix Meaning
_ai Accent insensitive
_as Accent sensitive
_ci Case insensitive
_cs case-sensitive
_bin Binary</code>
mysql  dba  collation  casesensitivity  reference  solution 
4 weeks ago by kme
mysql - How do I find which transaction is causing a "Waiting for table metadata lock" state? - Stack Overflow |
All I actually had to do was stop the web server. The Flask-Admin web application had a lock on the table metadata, and I was trying to ALTER TABLE changing the data type/size of the columns. No go while the application was running, and that makes sense in retrospect.
If you cannot find the process locking the table (cause it is alreay dead), it may be a thread still cleaning up like this

section TRANSACTION of
<code class="language-sql">show engine innodb status;</code>

at the end
<code>---TRANSACTION 1135701157, ACTIVE 6768 sec
MySQL thread id 5208136, OS thread handle 0x7f2982e91700, query id 882213399 xxxIPxxx my_user cleaning up</code>

as mentionned in a comment in Clear transaction deadlock?

you can try killing the transaction thread directly, here with
<code class="language-sql">KILL 5208136;</code>

worked for me.
dba  mysql  sql  processmanagement  solution  flask-admin 
4 weeks ago by kme
How to connect MySQL database using Python+SQLAlchemy remotely? - Stack Overflow |
n my setup (I'm using mysql-python) just using instead of localhost in the MySQL SQLAlchemy url works. The complete url I'm using exactly for that scenario (tunnel with local port 3307) is:


I'm using SQLAlchemy 1.0.5, but I guess that doesn't matter too much...
python  mysql  dba  networking  sqlalchemy  errormessage  annoyance  solution 
4 weeks ago by kme
mysql - Is it not possible to show warnings when using mysqlimport? - Stack Overflow |
I used the mysql CLI tool, passing an equivalent "LOAD DATA ..." command followed by a semicolon, followed by "SHOW WARNINGS". The resulting display is helpful in finding detail on each warning.

For example:
<code class="language-bash">mysql <options> -e "LOAD DATA LOCAL INFILE 'foo' INTO TABLE bar; SHOW WARNINGS"</code>

P.S.: You will probably also need to add the '--local-infile=1' option or you'll get an error message about something not being supported in this version of MySQL.

What worked (finally) for me was:
<code class="language-sql">
mysql --login-path=dbserver --local-infile=1 --protocol=TCP \
-e 'load data local infile "zz_ensembl_genes.tsv" into table zz_ensembl_genes; show warnings;' \
dba  mysql  importexport  solution  debugging  logging  errormessage 
4 weeks ago by kme
MySQL :: MySQL Workbench Manual :: 5.3.5 Remote Management |
The "SSH login based management" is greyed out if the host is "localhost" or Workaround: add an alias called something else ("dev.local", "localhoerst", whatever) to /etc/hosts. Voila!
dba  mysql  mysqlworkbench  annoyance  workaround  solution 
4 weeks ago by kme
Table comment length in MySQL - Stack Overflow |
Doh! It gets silently truncated after an export / import!

Solution: install MySQL 5.5.something (>3).
MySQL 5.1 CREATE TABLE reference: • Tables up to 60 characters. • Columns up to 255 characters. || MySQL 5.5 CREATE TABLE reference: • Tables up to 2048 characters (60 characters before MySQL 5.5.3). • Columns up to 1024 characters (255 characters before MySQL 5.5.3). – Birchlabs Jan 4 at 19:57
mysql  mysql51  dba  database  annoyance  solution 
4 weeks ago by kme
perl - How to tell CPAN about path to make and cc - Stack Overflow |

In cpan_home/CPAN/ (or via o conf):

<code class="language-perl">'make_arg' => q[CC=/path/to/c-compiler]</code>
cpan  ssl  ssleay  perl  module  compiler  errormessage  solution 
5 weeks ago by kme
-fstack-protector-strong « codeblog |
The Perl module Net::SSLeay requires this feature of GCC 4.9:
There will be a new option in gcc 4.9 named “-fstack-protector-strong“, which offers an improved version of “-fstack-protector” without going all the way to “-fstack-protector-all“. The stack protector feature itself adds a known canary to the stack during function preamble, and checks it when the function returns. If it changed, there was a stack overflow, and the program aborts. This is fine, but figuring out when to include it is the reason behind the various options.
gcc  compiler  security  stackoverflow  stacksmashing  errormessage  solution 
5 weeks ago by kme
python - Flask-Admin default filters - Stack Overflow |
<code class="language-sql">from flask.ext.admin.contrib.sqla.view import ModelView, func

class PaidOrderView(ModelVew):
def get_query(self):
return self.session.query(self.model).filter(self.model.paid==True)

def get_count_query(self):
return self.session.query(func.count('*')).filter(self.model.paid==True)</code>
python  flask  flask-admin  webdevel  sqlalchemy  orm  session  query  solution 
5 weeks ago by kme
MySQL Count distinct values from one column - Stack Overflow |
Have you tried
<code class="language-sql">SELECT COUNT(DISTINCT B) FROM mytable WHERE C = 2;</code>
dba  sql  syntax  mysql  dammitbrain  newbie  solution 
5 weeks ago by kme
Find duplicate records in MySQL - Stack Overflow |
The key is to rewrite this query so that it can be used as a subquery.
<code class="language-sql">
SELECT firstname,
FROM list
FROM list
GROUP BY address
HAVING COUNT(id) > 1) dup
ON list.address = dup.address;

Also useful
<code class="language-sql">SELECT date FROM logs group by date having count(*) >= 2

but note
Be careful with this answer. It returns only one of the duplicates. If you have more than 2 copies of the same record you wont see them all, and after deleting the record returned you will still have duplicates in your table.
dba  sql  mysql  datamunging  duplicates  solution 
5 weeks ago by kme
mysql command for showing current configuration variables - Stack Overflow |
What you are looking for is this:
<code class="language-sql">SHOW VARIABLES;</code>

You can modify it further like any query:
<code class="language-sql">SHOW VARIABLES LIKE '%max%';</code>
dba  mysql  sql  syntax  newbie  dammitbrain  solution 
6 weeks ago by kme
sql - How to get the next auto-increment id in mysql - Stack Overflow |
Two solutions, but only the second works if you just TRUNCATEd the table:

<code class="language-sql">SELECT LAST_INSERT_ID()</code>

<code class="language-sql">
FROM information_schema.tables
WHERE table_name = 'table_name'
AND table_schema = DATABASE( ) ;

-- or if you do not wish to use information_schema you can use this

dba  mysql  sql  syntax  newbie  solution 
6 weeks ago by kme
mysql - How to truncate a foreign key constrained table? - Stack Overflow |
<code class="language-sql">SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;
TRUNCATE table2;


This will handily reset the AUTO_INCREMENT as well, while maintaining the table structure and comments.
mysql  dba  sql  syntax  newbie  solution 
6 weeks ago by kme
Can't change window size on spreadsheets in Excel - Microsoft Community |
Weird fucking feature.
What I found was that a spreadsheet had "Protection" turned on. This was preventing me from being able to resize the window. After I turned "Protection" off I was able to resize.

Tools -> Protection -> Unprotect (could vary)
office  mac  osx  office2011  wtfmicrosoft  solution 
6 weeks ago by kme
mysql - SQL set values of one column equal to values of another column in the same table - Stack Overflow |
Sounds like you're working in just one table so something like this:
<code class="language-sql">
update your_table
set B = A
where B is null</code>
mysql  sql  newbie  syntax  solution 
6 weeks ago by kme
MySQL :: MySQL 5.7 Reference Manual :: 23.2.1 Stored Routine Syntax |
An alternative summary of functions versus procedures:

Inputs: Takes a list of arguments, all are inputs.
Could also get input from running a query?

Outputs: Produces a single return value -- see RETURN clause. Can be any valid MySQL data type.

(Can that return value be a result set? Other docs say that "functions cannot return a result set", but this probably means "cannot return a result set direct to the client", which is something _procedures_ can do. So far as I can tell, functions cannot return a cursor, which would be a related concept.)

Calling method: Can be used where a built-in function like ABS() might be used, such as in an assignment, expression, or where a field value is expected.

Inputs: Takes a list of arguments. Procedure definition specifies whether these arguments are for input and/or output, via IN, OUT or INOUT.

Could also get input from running a query.

Outputs: Unlike a Function, does not produce a return value per se. However, can send values back to caller via OUT or INOUT arguments.

Also, procedures can contain a bare SELECT statement, which sends a result set to the client. A procedure can contain multiple such SELECT statements, if other details enable the client to receive multiple result sets.
mysql  dba  sql  syntax  explained  solution  forthecomments 
6 weeks ago by kme
Writing optional parameters within stored procedures in MySQL? - Stack Overflow |
Optional Parameters are not yet supported on MySQL. I'm suggesting that you pass null value in your parameter and inside your stored procedure has an IF statement.
<code class="language-sql">
(IN param VARCHAR(25))
-- statements ;
ELSE commands
-- statements ;
DELIMITER ;</code>
dba  sql  mysql  syntax  workaround  solution 
6 weeks ago by kme
Find duplicate records in MySQL - Stack Overflow |
<code class="language-sql">SELECT firstname,
FROM list
FROM list
GROUP BY address
HAVING COUNT(id) > 1) dup
ON list.address = dup.address;</code>
dba  sql  duplicates  solution 
6 weeks ago by kme
iOS 11 Smart Punctuation
This is „Intellegente Interpunktion“ in German, which seems like a misnomer, but sure enough, quotation marks are considered "punctuation."
ios  ios11  smartquotes  annoyances  solution 
6 weeks ago by kme
clone - git: fatal: I don't handle protocol '​​http' - Stack Overflow
This is EXACTLY what I did:
This happened to me using msys-git and trying to paste (with ctrl-v and ctrl-shift-v), before realizing they were not valid keyboard shortcuts. Redoing the command and pasting with right-click->paste seemed to work. – Darthfett Apr 5 '16 at 17:58
windows  copypaste  git  errormessage  solution  cygwin  nonprinting 
7 weeks ago by kme
ssl - How to add an enterprise certificate authority (CA) to git on cygwin (and some linux distros) - Stack Overflow
git-remote-https will read the following files for ca certificates:

If you edit these files, they will be overwritten each time the Cygwin setup is run and there is an update for the ca-certificates package.

The correct/proper solution is to add the certificate to the pick up directory and run the pickup script, update-ca-trust:

curl -sL > /etc/pki/ca-trust/source/anchors/ \
&& update-ca-trust
The post install script for the ca-certificates package will automatically rerun the update-ca-trust script on every upgrade. For more information:

man update-ca-trust</blockquote
cacert  certificate  openssl  curl  cygwin  sysadmin  solution 
7 weeks ago by kme
bash - Longest line in a file - Stack Overflow |
GNU coreutils ≥7.4:
<code class="language-bash">wc -L filename</code>

With older GNU coreutils:
<code class="language-bash">cat filename|awk '{print length, $0}'|sort -nr|head -1</code>

My solution previously had been:

<code class="language-bash">
awk '{if(length($2)>longest){longest=length($2)}} END{print longest}' infile
textprocessing  wordcount  shellscripting  solution 
7 weeks ago by kme
php - PCRE is compiled without UTF support - Stack Overflow |
I didn't have this problem at all, but this SO thread has the best google juice for "grep: this version of PCRE is compiled without UTF support".

How I worked around it was to unset the LANG environment variable (mine was "de_DE.UTF-8").
shellscripting  pcre  grep  errormessage  utf8  unicode  workaround  solution 
7 weeks ago by kme
HowTO: Linux Disable a User Account Command - nixCraft |
In this example, local disable a user account for raj user:
<code class="language-bash">
# usermod -L -e 1 raj
linux  accountmanagement  security  sysadmin  usermanagement  solution 
7 weeks ago by kme
How to import CSV file to MySQL table - Stack Overflow |

phpMyAdmin can handle CSV import. Here are the steps:

1. Prepare the CSV file to have the fields in the same order as the MySQL table fields.
2. Remove the header row from the CSV (if any), so that only the data is in the file. (not necessary --Ed.)
3. Go to the phpMyAdmin interface.
4. Select the table in the left menu.
5. Click the import button at the top.
6. Browse to the CSV file.
7. Select the option "CSV using LOAD DATA".
8. Enter "," in the "fields terminated by".
9. Enter the column names in the same order as they are in the database table.
10. Click the go button and you are done.

This is a note that I prepared for my future use, and sharing here if someone else can benefit.
database  dba  mysql  import  automation  csv  tabdelimited  solution  importexport 
7 weeks ago by kme
« earlier      
per page:    204080120160

related tags

(almost)  (sortof)  2darray  2fa  2to3  3dacceleration  3dgraphics  7zip  10.04  10.5  10.7  10.8  10.10  12.04  14.04  16.04  32bit  32lg40  32or64  64bit  1980s  a2ps  a11y  abc  abi  abortabort  abstractclasses  acautionarytale  accdb  acceleration  acceptance  access  accesscontrol  accordion  accounting  accountmanagement  acl  aclocal  acls  acpi  acpidump  activerecord  activestate  activesupport  ad  addon  addons  addressbar  addressbook  adhoc  adium  admin  administration  adobe  adt  advertising  advice  aerosnap  afp  afs  againagainagain  aha  ahk  airbrush  airprint  ajax  alacarte  albumart  algorithm  algorithms  alias  aliases  align  alignment  allocation  almost  alpine  alternatekeymap  alternatekeymaps  alternatives  alternativeto  altertable  altorouter  altsql  amazon  amazonami  ami  amsmath  analysis  analysistoolpak  android  animated  animation  animations  anki  annoyance  annoyances  annoyancesortof  anonymousfunction  anoyyyyyying  ansi  ansible  ansicolor  ansicolors  answer  answered  antialiasing  antispyware  antivirus  apache  apache24  api  apiary  apibreakage  apikey  app  appcache  appindicator  appinfo.ini  apple  applemail  applescript  applicationcache  appstore  apt  apt-get  apt-pinning  aptana  aptanastudio  apt_preferences  arch  archive  archiving  argparse  argumentparsing  arguments  array  arraylist  arrayliteral  arrays  arrayslice  artha  article  asanide  asaservice  asastring  ascii  asciiart  asciitable  ascomparedto  assets  assistivetech  association  associativearray  asus  atlassian  atlernativeto  atoi  atom  audio  audiovideo  aufdeutsch  authentication  authorized_keys  authorship  autocmd  autocomplete  autocompletion  autocorrect  autoenv  autoexec.bat  autoformat  autofs  autohotkey  autoincrement  autoindent  autojump  autokey  automake  automated  automaticupdate  automation  automator  automount  automounter  autopano  autorefresh  autoreload  autorouting  autostart  autotools  autotype  avast  avg  awk  aws  ayfkm  ayfkmm  background  backgroundprocess  backticks  backup  backupandrecovery  backups  badbadbad  badui  baking  barerepository  bartender  basecamp  basename  bash  bashcompletion  bashrc  bash_completion  bash_profile  basicauth  batch  batchconversion  batchfile  batchprocessing  batchprogramming  batchscript  batchscripting  batteriesincluded  battery  bcd  beanshell  bedformat  bedops  bedtools  benchmarking  bestpractice  bestpractices  binaries  binary  bind  bind-address  binutils  bioinformatics  biometric  bios  bitbucket  bitlocker  bitrate  bitshift  bizarre  bjc80  blackmagic  blamethedesigners  blankpage  blkid  blog  blogging  blueprint  bluetooth  bonjour  bookmarkbar  bookmarking  bookmarklet  bookmarklets  bookmarks  boost  boostrap  boot  bootable  bootcamp  bootcd  bootdisk  bootlogging  bootmanager  bootrec.exe  bootstrap  boottoconsole  bootup  booze  boris  bottomposting  bourneshell  bowdlerize  bower  box  box-sizing  boxmodel  braceexpansion  bracematching  branches  branching  breakingchanges  bridge  bridgedethernet  bringbackmarkdown  broadband  browser  browserquirks  browsershots  browsersupport  bsd  btrfs  budgie  buffermanipulation  buffers  bug  build  build-essential  builderror  buildfromsource  buildinginhome  buildinhomedirectory  buildproblems  buildtoolchain  builtdtools  bulkupload  bundleid  bundling  burningquestions  busybox  butnotreally  butwhy  bytestring  bzr  c  c++  c++11  c++14  ca  cacert  cache  cake  calc  calculator  caldav  calendar  callingconventions  camelcase  camino  caniuse  canon  canvas  capacitor  capitalization  capslock  capslockasctrl  capslocktocontrol  carddav  casesensitivity  casting  castore  cat  ccsm  cd  cdma  cdn  cdt  cec  celery  cellarray  cellphone  cellular  censorship  centering  centos  centos6  centos7  cert  certificate  certificates  certificatestore  certs  cflags  cgi  chat  cheatcode  cheatsheat  cheatsheet  checkbox  checker  checksum  childtheme  chmod  chocolate  chomium  chrestomathy  chrome  chromium  cifs  cinnamon  cint  circuit  circularimports  citation  clang  class  classes  classiccomputing  classicgaming  classpath  classvariables  cleanup  clever  cli  click  clickevents  clickhandler  client  cling  clipboard  clipboardmanager  clipboardsharing  cloneurl  cloning  closure  closures  cloudstorage  cluster  clustercomputing  cmake  cmd  cmd.exe  cobalt  cocoa  cocoatouch  code  codecompletion  codegolf  codesharing  codesigning  codingstyle  collaboration  collation  collectionmanagement  collections  color  colorcodes  colorhighlighting  colormap  colors  colorscheme  column  comandline  combinations  command-t  commandline  commandlineargs  commandlineopts  commandprompt  commandt  comment  commentcharacter  comments  commitlog  communication  compared  compilation  compiler  compilererror  compilererrors  compilerflags  compileroptions  compilerwarning  compiz  completion  component  compooser  composekey  composer  comprehensive  compression  concurrency  conditional  conffile  config  configfile  configfiles  configparser  configsetting  configsettings  configuration  configurationutiliity  configurator  configure  conflicts  confluence  conjunctions  connectbot  consideredharmful  console  consolefont  constants  constraint  constructor  contactform  container  content-type  contextmenu  contextualmenu  controlkey  controller  controlpanel  conversion  converter  cookies  cooking  copypasta  copypaste  coredumps  correlation  cors  cover.jpg  cpan  cpanm  cplupslus  cplusplus  cpp  cppflags  crackedscreen  crapcleaner  crash  credentials  creepyurls  crossorigin  crossover  crossplatform  crunchbang  crunchpdf  crypto  cryptography  cs  cscope  csh  csharp  csp  css  css3  csstransitions  cstrings  csv  ctags  ctrl-r  cuda  cups  curl  curses  cursor  cursormotion  cursormovement  customization  customkernel  custompackages  customposttype  customposttypes  cwd  cwl  cxxflags  cya  cycling  cygwin  dammitbrain  dangerwillrobinson  darkmenubar  dash  dashes  data  data-uri  database  dataframe  datamunging  datastructure  datastructures  datatables  datauri  date  dateandtime  dateline  datetime  dav  davmail  dba  dbase  dbms  dbus  dconf  dd  deadkeys  deadlink  debian  debugger  debugging  decoder  defaultpassword  defaultprogram  defaults  defaultswrite  defines  delimited  delimitedtext  delimiter  dell  dependencies  dependencyhell  dependencymanagement  deployment  deprecated  dereference  design  desktop  desktopcustomization  desktoplauncher  desktopsession  desktoptweaks  dessert  destroyinghistory  detection  deutsch  deutschland  devel  developer  development  devhelp  devops  devpts  devtools  dia  diagram  dialog  dict  dictation  dictionary  diff  differ  dig  digitaleditions  digraph  dircolors  directory  disasterrecovery  disk  diskimage  diskmanagement  diskspace  diskusage  diskutil  diskutility  display  distribution  distros  diy  django  dll  dllhell  dm  dmg  dns  doc  dock  dockapp  docker  docset  docsets  docstring  documentation  docx  dom  dos  dosbox  dotfile  dotfiles  dotnet  dotprofile  downgrade  download  downloader  downsample  downwithopc  doxygen  dpkg  draganddrop  dragondictate  dreamhost  drivemapping  driver  drivers  drm  dropbox  dropdownterminal  drracket  ds  dualboot  dualmonitor  duh  dumbass  dupfinder  duplicatefilefinder  duplicatefinder  duplicates  duplicity  dvd  dyld  dynamicloader  ebook  ec2  eclectic  eclipse  ecryptfs  edid  editing  editor  education  egit  elcapitan  elementary  elementaryos  elementhiding  elf  elixir  elt  emacs  email  embed  emoji  emoticons  emulation  emulator  encoding  encodings  encryption  english  entrez  enum  environment  environmentvariable  environmentvariables  epiphany  epoch  eps  epub  equation  equations  erb  erromessage  error  errorhandling  errormesage  errormessage  errrormessage  es5  escaping  eset  essential  eutils  evaluation  eventhandling  eventlistener  events  evernote  ews  excel  exception  exceptionhandling  exceptions  exchange  exitcode  exitstatus  explained  explorer  export  exporter  exports  ext2  extendedattributes  extension  extensions  extern  extjs4  extractor  eyecandy  faenza  fail  fail2ban  faq  faradaycage  favicon  favorites  fdf  featurerequest  fedora  feepingcreaturitis  festival  fieldcodes  fileassociation  fileencoding  fileextension  fileformat  filehandle  fileio  filemanagement  filemanager  filename  fileopensaveas  fileoperations  filepermissions  filesharing  filesystem  filesystemaccess  filesystems  filetype  filter-branch  filtering  finance  find  findandreplace  finder  findingthings  findutils  fingerprint  fingerprintreader  fingerprints  fip  firefox  firefoxos  firewall  firmware  fish  fixedinupstream  fixedwidth  fixup  flash  flashcards  flashdrive  flashplugin  flask  flask-admin  flask-sqlalchemy  flask-wtf  flask_restful  flask_restless  floats  flour  flowchart  flowcontrol  fnkey  foistware  folder  folding  font  fontfamily  fontreplacement  fonts  fontsize  forcedupdate  fordummies  foreignkey  forensics  forgotpassword  fork  forking  forloop  format  formats  formatstrings  formatting  formdata  formfields  formprocessing  forms  formula  forreference  forthecomments  forwarding  foundasolutionanyway  fp  framebufferconsole  framework  freebsd  freedos  freemind  freenx  freeware  freya  fromsource  frustration  fsck  fstab  ftfy  ftp  fuckfuckfuck  fuckina  fuckinga  fuckitunes  fuckyeah  fullscreen  function  functionkeys  functionpointers  functions  functionscope  funnycharacters  fuse  fuzzyfinder  g++  g4  gallery  gaming  gatekeeper  gcc  gconftool  gdb  gdrive  geary  gee  geforcemx440  gem  gemfile  generator  genomebrowser  geo  geocoding  geolocation  geos  geoworks  geshi  gesture  gestures  getopt  gettingstarted  getty  gfm  ghostscript  gif  gimp  git  git-alias  git-branch  git-diff  git-fu  git-ls-tree  git-push  git-remote  git-reset  gitattributes  gitdiff  gitfu  githacks  githooks  github  gitignore  gitlab  gl  glib  glibc  globalmenu  globals  gloobus  gloobus-preview  gloobuspreview  glyphicons  gmail  gmailimaptimestampproblem  gnome  gnome-keyring  gnome-terminal  gnome2  gnome3  gnu  gnuautotools  gnucc  gnumeric  gnuplot  gnustow  go  gobject  godaddy  goldendict  goodexplanation  google  googleauthenticator  googlecalendar  googledrive  googlemaps  googlesheets  gotcha  gotchas  gpg  gplusplus  gpu  grammar  graphics  graphing  graphire  graphire1  graphirebt  greasemonkey  greedymethod  grep  grive  groff  group  groupmembership  grub  grub2  gsettings  gsm  gtk  gtk-can-change-accels  gtk3  guard  guestadditions  gui  guide  guile  gunicorn  gutenprint  hack  hacking  hacks  hadoop  hammer  hammerstorage  handlebars  harddisk  hardlinks  hardstatus  hardware  hash  hashes  hashing  hashtables  haskell  hawaiian  hazel  hci  hdd  hddactivity  hddindicator  hdid  hdmi  headache  header  headless  headphones  headset  help  helper  heredoc  hex  hexdigit  hexeditor  hfs  hiberation  hiberfil.sys  hibernate  hibernation  hiddenfiles  hidpi  highlighter  hires  hiresconsole  history  historyapi  historyexpansion  historysearch  hn1200  homefolderinstallation  hook  hooks  hosting  hostkeyfingerprint  hostkeyverification  hostonlynetwork  hotbackup  hotfix  hotkey  hotkeys  housekeeping  hover  howmicrosoftruinseverything  howto  hp  hpc  hplip  htaccess  html  html5  htmlcollection  htmlentities  http  httpd  httpproxy  https  hugin  hugo  humanreadable  humor  hyperlink  hyperlinks  hyphenation  i18n  i386  ibm  ibmpower  ibrokeit  ibus  ical  ich9  icon  icons  id3  ide  idea  idevice  idiom  idle  ie  ie6  ie7  ie8  ieee  ifixedit  iframe  iframes  ifttt  ignore  iguess  iife  image  imagecapture  imagecorrection  imagemagick  imageprocessing  images  imagesave  imap  imbd  import  importer  importexport  imports  in  incantation  include  includes  indendation  indentation  index  indexing  indian  indicator  indicator-synapse  indicatorapplet  inheritance  inifile  init  initclt  initfile  initialization  initramfs  initscript  initsystem  inject  inkscape  inline-block  innerjoin  inotify  input  inputdevice  inputmethod  inputoutput  inspiron2330  installation  installedprograms  installer  installingipaswithoutitunes  instapaper  integration  intellij  intellisense  interactive  interactivemode  internationalcalling  internetexplorer  internetradio  intputoutput  intranet  introspection  io  ioapic  ioerror  ios  ios11  iostream  ipa  ipad  iphone  ipod  ipodtouch  iptables  ipv6  ipython  irb  ish  isitup  iso  iso8601  issuetracker  issuetracking  iterable  iteration  iterator  iteritems  iterm  itertools  itunes  jar  jarbundler  java  java7  javadoc  javascript  javasript  jdk  jekyll  jessie  jinja  jinja2  jira  journalism  jpg  jq  jquery  jre  jsl  json  jsonify  juniper  junipervpn  junos  junospulse  jvm  kebabcase  keepass  keepasshelper  keepassx  kernel  key  keybinding  keybindings  keyboard  keyboardlayout  keyboardlayouts  keyboardshortcut  keyboardshortcuts  keychain  keyconfig  keyfingerprint  keyfingerprints  keymanagement  keymap  keymapping  keymappings  keyrepeat  keyring  keys  keyserver  keysigning  keystrokelauncher  keyverification  kmers  known_hosts  labcomputer  lambdafunctions  lang  language  latex  launchctl  launchd  launcher  launchservices  launchy  layout  ldap  ldapsearch  ldconfig  ldd  ldflags  ldif  lenovo  leopard  less  lettercase  lg  libc  libedit  libmysqlclient  libraries  library  librarypath  libreoffice  libstdc++  libxml2  license  licensekey  licensing  lightbox  lightdm  lightning  lighttable  lightweight  likeamac  likedebian  likedos  likegit  likelinux  likelsf  likeperl  likerails  likesql  likeunix  likewindows  linearalgebra  linebreak  linecontinuation  linecontinuationcharacter  linedrawcharacters  lineends  linespoints  linker  links  lint  linter  linuminut  linux  linuxhasthis  linuxmint  linuxminut  lion  liquid  lisp  list  listcomp  listprocessing  lists  listserv  livecd  livereload  liveusb  lms  local::lib  locale  localinstall  localinstallation  LocalSettings.php  localstorage  location  locationaware  lockfile  lockscreen  logfile  logfiles  logging  login  loginscreen  loginscript  logitech  logrotated  logrotation  logs  loki  loops  ls  lsf  lsf8.3  lsof  lucid  luna  lvm  lxml  lync  mac  macbookair  macmenu  macos  macports  macro  macros  mactex  macvim  magic  magickeys  magictrackpad  mail  mailconversion  mailinglist  mailman  mailspool  mailuseragents  maintenance  make  makefile  makefiles  malware  malwarebytes  mamp  man  management  manifest  manpage  manpages  manual  manytomany  map  mapping  maps  margin  mariadb  markdown  marked  marks  markup  marlin  mars  massstorage  masterpassword  match  materialdesign  math  mathjax  mathml  mathmode  mathworks  matlab  maverick  mavericks  max  maximus  maybe  mbox  mbr  mdb  mdns  me302  media  mediaquery  mediawiki  meltdown  memopad  memorymanagement  memoryusage  menu  menuaccels  menubar  menueditor  menuextra  menus  merge  merging  messagebox  metacity  metadata  metaprogramming  metrics  mex  mfa  mfc  microsoft  midi  midori  migration  mimimalist  mindmap  minification  mint  mint15  mintty  misery  missinglibraries  missinglibrary  mit-scheme  mitm  mixins  mla  mlm  mlu  mobile  mockup  model  modifyhd  module  modules  mod_rewrite  mod_wsgi  monitor  monitoring  monolog  monospace  monospacedfont  mosh  motoroladroid  mount  mountainlion  mouse  mouseevents  move  movein  mozilla  mp3  mp3tag  mpi  msclient  msmtp  msoffice  mspaint  msword  msysgit  mta  mua  multidimensionalarrays  multiline  multilinestrings  multipagetiff  multipleaccounts  multipleexchangeaccounts  multipleinheritance  multipleprofiles  multiplexer  multiplexor  multiprocess  multithreading  multitouch  music  mutt  myshare  mysql  mysql51  mysql55  mysql56  mysql57  mysqlworkbench  mystery  mysterymeat  mystuff  nalternativeto  namedtuple  nameresolution  nameservice  namespaces  nano  nas  naturalscrolling  nautilus  ncbi  nchoosek  ncr  needshelp  nemo  nepomuk  nerdtree  netbeans  netcat  network  networkconnect  networkdrive  networkfilesystem  networking  networklocations  networkmanager  newbie  neweditor  newline  newlines  newtabpage  newthinkpadkeyboard  nfs  nfs4  nfs4_setfacl  nfsv4  nginx  ngrams  nightly  node  nodejs  nodelist  noerrormessage  nofuckinguninstaller  nognomedeps  nohddled  nojquery  nomachine  nomenclature  non-free  nonadministrator  nonbreaking  nonfree  nongreedy  nonhideous  nonobvious  nonprintable  nonprinting  nonroot  nopeyoucant  normaldistribution  normalforms  noscript  nosleep  notepad++  notification  notificationarea  notifications  notify-send  nottheproblemihad  npm  npr  nsswitch  nth-child  numbers  numpy  nvalt  nvidia  nx  objects  ocr  octave  octopress  oem  office  office265  office2011  officemac2011  offline  offlineimap  ohsothatswhy  okina  okinakahako  oldrelease  oldversion  olivia  omfg  oneliner  oneliners  onlinehelp  onlinestorage  onreadystatechange  oo  oop  oops  open  opencv  openfiles  openldap  openmpi  openoffice  opensource  openssh  openssl  openwith  opposites  optimization  orm  os  osc  osd  osupgrade  osx  osxdefaults  outlook  outlookwebaccess  overlay  ovf  owa  owncloud  oxygen  package  package.json  packagemanagement  packagemanager  packagemangement  packages  packaging  packrat  pacman  pageant  pageborder  pager  painttools  palette  panda  pandas  pandoc  panel  panelindicator  panorama  panoramic  pantheon  paperless  parallelcomputing  paralleltousb  paranoia  parser  parsing  partial  partition  partitioning  partitiontable  parts  passbyreference  passenger  passwd  password  passwordless  passwordlesslogin  passwordmanager  passwordprompt  passwords  paste  patch  path  pathext  pathfinder  pathname  pathvariable  patternmatching  pcre  pcspeaker  pdf  pear  peewee  pep8  percentencoding  perceptron  performance  perl  perl5  PERL5LIB  perl516  perlcritic  perldata  perldoc  perlpod  permissions  permutations  pgp  phantom  phone  php  php-xml  php54  php56  phpbb  phpdoc  phpmyadmin  phpunit  pidgin  pinboard  pinchtozoom  pip  pipeline  pipes  pki  placeholder  plaintext  platform  platformdetection  playlist  playstore  plist  plotting  plugin  pluginreg.dat  plugins  plumbing  plusaddressing  png  pod  podcast  pointers  policykit  polkit  polyfill  poodle  popclip  popup  portableapps  portforwarding  positioning  positivelookbehind  posix  postfix  postgres  postmaster  postscript  power  powerbook  powerbutton  powermanagement  powerpc  powerpoint  powersave  powershell  powesave  ppa  pr  pre  precise  precommit  prepositions  preprocessor  prettycolors  prettyprettycolors  prettyprint  prettyprinting  preview  primarykey  primarykeys  print  printer  printersharing  printf  printing  priorknowledge  prismjs  privacy  privatekey  probability  procedure  procedures  process  processcontrol  processmanagement  processmonitoring  processsubstitution  processusbstitution  productivity  programing  programming  prompt  promptstring  proof  propertylist  protocolrelativeurls  prototype  provisioning  proxy  proxying  ps1  psc2210  pst  pthreads  ptmx  ptpython  pubkey  publickey  publickeyauthentication  publickkeyauthentication  public_html  publishing  pulseaudio  putty  puzzle  pxeboot  pycharm  pyspark  python  python2  python2.2  python3  python26  python27  pythonfu  pythonic  qmake  qt  quakeconsole  quaketerminal  quantifier  queestion  query  queryselector  querystring  question  questions  quickcursor  quickedit  quicklook  quickref  quickreference  quicksilver  quirk  quirks  quora  quota  quoting  r  r00ting  racket  rails  rake  ramdisk  random  rant  rawdiskimage  rbenv  rc  rcfile  rcfiles  rdp  reader  readlater  readline  readme  readynas  rebase  recipe  recommendation  recovery  recoverycd  redhat  redirect  redirection  reference  refgene  reflection  reflow  refresh  regedit  regex  regexp  registeredfiletypes  registers  registry  registryhack  relations  relationship  releasemanagement  remap  remapcapslocktoctrl  remote  remoteaccess  remoteadministration  remotedesktop  remotefilesystem  remotefilesystems  remotes  remotetracking  removablestorage  rename  repair  repairs  repeatrate  repl  repo  report  reporting  repos  repository  request  requests  rescuecd  research  reset  resize  resolution  rest  retail  retext  returnvalue  revealcodes  revealjs  reverting  revisioncontrol  rewriterule  rewriting  rewritinghistory  rfc822  rhel  rightmousebuttonresize  rmagick  roaming  root  rootcertificates  rot13  roundcube  routing  rpm  rshiny  rstudio  rsync  rtf  ruble  ruby  ruby-ldap  ruby1.8  rubygem  rubygems  rubyonrails  ruler  rundll32  runlevel  runlevels  rvm  safemode  samba  sampelcode  samplecode  sampleconfig  samplerate  samsung  sanitization  sass  savewebpagetopdf  saving  scan  scandisk  scanning  scheduledtask  schema  scheme  scl  scm  scope  scraping  screen  screencapture  screencast  screencasting  screenrecording  screensaver  screenscraper  screenscraping  screensharing  screenshot  screenshots  script  scripting  scripts  scrolling  scrolllock  sdk  searchandindex  searchandreplace  searchengine  searching  secondarymailbox  secretsocieties  security  sed  select  select2  selectdistinct  selectivesync  selector  selectors  selenium  selfsigned  selinux  semicolons  sendlater  sendto  sendtomenu  sendtotoys  sentencecase  serialization  server  serverpush  service  servicecodes  services  session  sessions  setterm  settheory  settings  setup  setuptools  sftp  sha  sha1  sharedaddressbook  sharedfolder  sharedhosting  sharedlibraries  sharedlibrary  sharedmailbox  sharelibraries  shasum  shebang  shell  shellfunctions  shellprogramming  shellscript  shellscripting  shellscriptping  shim  shiny  shortcut  shortcutkey  shortcutkeys  shortcuts  shortlink  shorturl  shroudedexe  shutter  sidekiq  sighie  sighjava  signals  signature  simplenote  simplenoteapp  simplink  simulator  sinatra  sinewaves  singlepixelgiftrick  singleusermode  sip  sizeof  size_t  skitch  skype  slapd  sleep  slices  slimdevices  sloc  slqite  slurm  slurmdbd  smartgit  smartquotes  smb  smbclient  smtp  snapshots  sni  snippet  snippets  snp  snps  snv  so  softlink  software  softwaredistribution  softwareupdate  solarized  solution  solutionagain  sony  sort  sorting  sortof  soucecontrol  sounds  source  sourcecodehosting  sourcecontrol  sourcepackage  sourcetree  sourcevsexecute  spaces  spacing  spark  spec  specialcharacter  specialcharacters  specification  spectre  speech  spice  splits  splitview  spotlight  spreadsheet  sprintf  spypot  sql  sqlalchemy  sqlite  sqlite3  squeezebox  squeezeplay  squid  srpm  srs  ssd  ssh  ssh-agent  ssh-copy-id  sshconfig  sshfs  sshkeys  sshtunnelling  sshtunnels  ssl  ssl3.0  ssleay  st3  stackexchange  stackoverflow  stacksmashing  stacktrace  standards  starch  starting  startup  startupitems  stash  static  staticconstint  statichtml  staticip  statistics  stats  stderr  stdin  stdout  stl  stockicon  stockicons  storage  stow  strace  straightup  streaming  streams  stresstest  strftime  string  stringformatting  stringhandling  stringmanip  stringmanipulation  stringprocessing  strings  stringstream  struct  style  styleguide  stylesheet  sublimetext  submodule  subprocess  subprocesscommunication  subscript  substitute  subversion  sudo  suggestions  sunjava  super  supervisor  svg  svn  swap  swapcapslockandctrl  swapfile  swatches  syadmin  symantecendpointprotection  symbol  symbols  symfony  symlink  symlinks  synapse  syncclient  synchronization  synchronous  synergy  syntax  syntaxhighlighter  syntaxhighlighting  syntaxhighllighting  syntevo  sysadmin  sysctl  syslog  sysop  sysresccd  system  systemcall  systemd  systemmaintenance  systemmonitoring  systemrecovery  systemrestore  systray  sysvinit  t369  tabcompletion  tabdelimited  table  tableofcontents  tables  tablet  tabstop  tagbrowser  taggedrelease  tags  tangent  tangentline  taptodrag  tar  taskbar  tcl  tcltk  tdd  tempfiles  template  templates  templatetoolkit  templating  termcap  terminal  terminalemulator  terminalmultiplexor  terminfo  terminology  termtype  ternary  ternaryoperator  test  testing  tex  texprocessing  text-overflow  textediting  texteditor  texter  textflow  textformatting  textmate  textprocessing  textselection  texttospeech  textwrapping  tftp  thejoysof  theme  theming  thinkpad  thirdparty  thread  threads  threadsafe  thumbnail  thunderbird  tidy  time  timeanddate  timemachine  timestamp  timestamps  timezone  timing  timit  tipandtricks  tips  tipsandtricks  tipsantricks  tires  titlecase  tk  tkinter  tls  tmux  toc  todo  tomato  tomight  toohelpful  toolbarscripts  toolchain  tooltips  topposting  touchevents  tput  tr  trac  trackchanges  tracking  trackingbranch  trackpad  trailingslash  transition  transitions  transparency  transport  trayicon  tree  tricks  trim  tropes  troubleshooting  tsv  ttk  tts  tty  tui  tunneling  tuples  tupleunpacking  tutorial  tv  tw  tweaks  twig  twitter  twofingerscrolling  typeahead  typedef  types  typesetting  typesettings  typo  typography  ua  ubee  ubuntu  ucsc  udev  ugh  ui  ulimit  undo  undobutton  unicode  uninstall  uninstallation  uninstaller  unittesting  unittests  unity  unix  unlocking  unp  unpacker  unstable  update  updatecheck  updates  upgrade  upgradehell  upgrading  upstart  uriencoding  url  urldecode  urlencode  urlencoding  urlhandler  urlrewriting  urls  urlshortener  usb  useful  user  useraccounts  useragent  userContent.css  userhelp  userinput  usermanagement  userscript  userstyle  utf  utf8  utility  uuencode  uuid  vagrant  vaio  vala  validation  validator  vanillajs  variable  variables  vba  vbox  vbscript  vcard  vcs  vector  vectors  veewee  vendordirectory  version  versioncontrol  versioninfo  versioning  vesafb  vgaconsole  vgcjs110j  vhost  vi  video  videoediting  view  viewer  vikeybindings  vikeys  vim  vim-surround  vimdiff  vimode  vimrc  virtual  virtualbox  virtualdisk  virtualdisks  virtualenv  virtualgl  virtualhost  virtualhosts  virtualization  virtualizationadnemulation  virtualizationandemulation  vista  visualization  visualstyle  vlc  vm  vmdk  vmm  vmware  vnc  vpn  vrapper  vscode  vt  vue  vue-resource  vue-select  vuejs  vulnerability  vx8550  w520  w530  wacom  wallpaper  wallpapers  warnings  warranty  watchthisspace  weather  weatherstations  web  web2py  webapp  webbrowser  webdav  webdesign  webdevel  webdwevel  webextension  webfont  webhosting  webkit  webmaster  webpack  webscraper  webscraping  webserver  websvn  weirdness  werkzeug  wget  wheelie  whenthingsgowrong  whentroublestrikes  wherefrom  whereis  which  whitespace  wholedriveencryption  wifi  wifidirect  wiki  wikilinks  wikipedia  wikitext  wildcard  win7  win8  win32  window  windowmaker  windowmanagement  windowmanager  windows  windowsize  windowskey  windowsonly  windowssucks  windowsupdate  wine  wingpanel  winhelp  winrar  winscp  winxp  winxpsp2  wireless  with  wm  word  word-wrap  word:mac  wordcount  wordpress  wordwrap  wordwrapping  workaround  workbench  worklog  worksok  wrapping  writeroom  writing  wrongforsolong  wsgi  wsh  wsus  wtf  wtfmicrosoft  wtforms  x  x11  x509  xattr  xbindkeys  xclip  xcode  xconsole  xdebug  xdg  xdg-desktop  xdg-desktop-icon  xdg-mime  xdg-open  xdm  xdotool  xenial  xfce  xhr  xml  xmllint  xmlstarlet  xp  xpath  xpath2  xprop  xserver  xsl  xslt  xterm  xterm-256  xterm-256color  xubuntu  xw4400  xwindows  yaml  yarn  yarrr  yosemite  youcantdothat  yum  zeal  zealdocs  zepto  zeptojs  zip  zoom  zotero  zsh 

Copy this bookmark: