linux-journal.blogspot.com

mysql-tips.blogspot.com

MySQL Tips: ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

http://mysql-tips.blogspot.com/2005/05/error-1075-42000-incorrect-table.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Friday, May 13, 2005. ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key. If in Mysql get the message "ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key" when trying to drop a primary key, then do the following:. Alter table your table change the column the column int unsigned;. Thanks for the tip!

mysql-tips.blogspot.com

MySQL Tips: Export a table in mysql to a file in csv format example

http://mysql-tips.blogspot.com/2005/04/export-table-in-mysql-to-file-in-csv.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. Export a table in mysql to a file in csv format example. Select * into outfile '/tmp/zips.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'. LINES TERMINATED BY ' n'. Alter table tablename engine=csv. This will also give you same thing. Subscribe to: Post Comments (Atom). Awesome Inc. template. Powered by Blogger.

mysql-tips.blogspot.com

MySQL Tips: MySQL date calculations

http://mysql-tips.blogspot.com/2005/04/mysql-date-calculations.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. Eg 2 days ago till today:. Select domain, count(*) as cnt from referrers where date = current date()-2 group by domain order by cnt;. Date calculations are relatively easy. The first function we're going to look at is the YEAR() function, which returns a year from a given date. For example:. Mysql SELECT YEAR('2003-03-31');. Mysql SELECT YEAR('2003-03-31') 5;. Mysql SELECT YEAR('2003-03-31')-5;. The DAYOF...

mysql-tips.blogspot.com

MySQL Tips: MySQL find duplicate repords example

http://mysql-tips.blogspot.com/2005/04/mysql-find-duplicate-repords-example.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. MySQL find duplicate repords example. Select address, count(address) as cnt. Order by cnt;. David Dashifen Kees said. Beautiful, thank you! Thank you very very much! Very elegant solution . i was looking for something like this . thx. Thank you very much. This is so awesome! Ya very nice easy to undestand. Thanks, great tip! You are a GOD! Awesome tips, thank you. 2005 and still good! Helped a lot, thanks!

mysql-tips.blogspot.com

MySQL Tips: Gauging MySQL performance- examples

http://mysql-tips.blogspot.com/2005/04/gauging-mysql-performance-examples.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. Gauging MySQL performance- examples. Mysql show variables like '%query cache%';. Have query cache YES. Query cache limit 4194304. Query cache size 167772160. Query cache type ON. 4 rows in set (0.01 sec). Mysql show variables like '%query cache%';. Have query cache YES. Query cache limit 4194304. Query cache size 167772160. Query cache type ON. 4 rows in set (0.01 sec). Mysql SHOW STATUS LIKE 'Qcache%';.

mysql-tips.blogspot.com

MySQL Tips: Some built-in MySQL functions

http://mysql-tips.blogspot.com/2005/04/some-built-in-mysql-functions.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. Some built-in MySQL functions. Mysql select version();. 1 row in set (0.00 sec). Mysql select database();. 1 row in set (0.01 sec). Mysql SELECT PASSWORD("mypass");. 1 row in set (0.01 sec). Mysql select md5('test');. 1 row in set (0.02 sec). Subscribe to: Post Comments (Atom). Awesome Inc. template. Powered by Blogger.

mysql-tips.blogspot.com

MySQL Tips: PHPBB Convert poster_ip to real IP address in phpbb_posts table

http://mysql-tips.blogspot.com/2009/01/phpbb-convert-posterip-to-real-ip.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Friday, January 02, 2009. PHPBB Convert poster ip to real IP address in phpbb posts table. SELECT * from nuke phpbb posts where inet ntoa(conv(poster ip, 16, 10) = '255.255.255.255';. SELECT u.username from nuke phpbb posts p, nuke phpbb users u where inet ntoa(conv(p.poster ip, 16, 10) = '207.200.116.10' and p.poster id = u.user id limit 1;. Labels: phpbb poster ip convert ip. Awesome Inc. template. Powered by Blogger.

mysql-tips.blogspot.com

MySQL Tips: Chang the Mysql client prompt

http://mysql-tips.blogspot.com/2005/04/chang-mysql-client-prompt.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. Chang the Mysql client prompt. Changing the Mysql client prompt: (Mysql 4.0.2 and higher). From http:/ dev.mysql.com/doc/mysql/en/mysql Commands.html). Eg "prompt d R m " will show the current database millitary hour minutes. Put in my.cnf. Prompt=" d R m ". This setting should actually come under the [client] section in the cnf file. i.e. Prompt = u@ h d. Subscribe to: Post Comments (Atom).

mysql-tips.blogspot.com

MySQL Tips: MySQL difference between dates in number of days

http://mysql-tips.blogspot.com/2005/04/mysql-difference-between-dates-in.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. MySQL difference between dates in number of days. To get a date difference in days in Mysql version before 4.1 (where you can use the datediff() function instead), do the following to calculate date difference:. Select (TO DAYS(date1)-TO DAYS(date2). Very good functions for difference. SELECT DATEDIFF(2006-07-10,2006-06-01);. Subscribe to: Post Comments (Atom).

mysql-tips.blogspot.com

MySQL Tips: End Query with \G instead of ;

http://mysql-tips.blogspot.com/2005/04/end-query-with-g-instead-of.html

Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks. Sunday, April 17, 2005. End Query with G instead of ;. You can use G instead of ; for tables with lots of fields. Mysql SHOW STATUS LIKE 'Qcache%';. Qcache queries in cache 6990. Qcache lowmem prunes 0. Qcache not cached 621. Qcache free memory 176329432. Qcache free blocks 1. Qcache total blocks 13998. 8 rows in set (0.00 sec). Mysql SHOW STATUS LIKE 'Qcache%' G. 1 row * * * * * * * * * * * * * *. Variable name: Qcache inserts.