HAPPY NEW YEAR

Get row with max(column) in mysql

Get row with max(column) in mysql

problem:

my table is:

user col1 col2 col3

1    1    2    3

1    3    4    5

2    2    3    1

3    1    1    3

3    2    4    6

4    5    1    5

So if I run

# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist

# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist 

phpmyadmin reported the following error

“# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist“

Modify the configuration file config.inc.php phpmyadmin

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

Changed to: $ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

Restart apache, web page log to re-enter, problem solving

Install Skype in Ubuntu 13.04/12.10/12.04/11.10/Linux Mint

Install Skype in Ubuntu 13.04/12.10/12.04/11.10/Linux Mint

Recommended Method (This will install 32bit skype 4.1 without any problem)
To install skype in Ubuntu/Linux Mint open Terminal (Press Ctrl+Alt+T) and copy the following commands in the Terminal:
>> For 32Bit
Terminal Commands:
#wget -O skype-NoobsLab.deb http://download.skype.com/linux/skype-ubuntu-lucid_4.2.0.11-1_i386.deb
#sudo dpkg -i skype-NoobsLab.deb
#sudo apt-get -f install;rm skype-NoobsLab.deb