Commands tagged table sorted by votes

Commands tagged table (3)

sorted by

while dumping database if you see following error/warning than you have to repair broken tables/rows Show Sample Output

mysqlcheck --repair --all-databases -u root -p<PASSWORD>

aysadk · 2020-10-30 11:52:20 202

drop first column of output by piping to this

An advantage is that this doesn't modify remained string at all. One can change {0,1} with {0,n} to drop several columns
This is sample output - yours may be different.
1

perl -pE's/(\S+\s*){0,1}//'

pung96 · 2015-05-09 15:14:58 12
drop first column of output by piping to this

drop first column with perl "$#F" means a index of last column(start from 0). One can easily handle range of columns like "[3..6]"
This is sample output - yours may be different.
0

perl -anE'say join "\t",@F[1..$#F]'

pung96 · 2015-05-09 15:11:23 9

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Check These Out

Dump a web page

Useful to browse dangerous web sites.

Mount an smb share on linux

Mount an smb share with this command. other options -ousername=$USERr,gid=$groupname,scope=rw

Create a single-use TCP (or UDP) proxy

Redirect the local port 2000 to the remote port 3000. The same but UDP: $ nc -u -l -p 2000 -c "nc -u example.org 3000" It may be used to "convert" TCP client to UDP server (or viceversa): $ nc -l -p 2000 -c "nc -u example.org 3000"

Play all the music in a folder, on shuffle

Play files in shuffle mode with bash and mpg123. Why bother using big-as-hell stuff like mplayer? This will play all your music files contained in */* (in my case author/song.format) with bash and mplayer showing a nice output.

Position the cursor under the current directory line

In case you're like me and like your commands to start on clean lines, especially when you're deep into a 10-level directory tree. This can be added to .bashrc.

Send email with curl and gmail

Required curl version >=7.21; using ~/.netrc for authorization

Set laptop display brightness

An alternative which does not require to be root

Convert CSV to JSON

Replace 'csv_file.csv' with your filename.

Find the package that installed a command

Compute the average number of KB per file for each dir

Shorter version using --tag

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)
» commands tagged table

Commands tagged table (3) the last day the last week the last month all time sorted by date votes

What's this?

Check These Out

Stay in the loop…

Commands tagged table (3)

sorted by