Viewing posts for the category MySQL

Finding Parsing Domain from Email in MySQL

Posted by: scoopseven in MySQL 16 years, 1 month ago
SELECT SUBSTRING_INDEX(Email, '@', -1), COUNT(SUBSTRING_INDEX(Email, '@', -1)) AS numDomain

read more / 0 comments

MySQL Duplicates

Posted by: scoopseven in MySQL 16 years, 3 months ago
#find duplicates

read more / 0 comments

From ODBC To JDBC

Posted by: scoopseven in MySQL 16 years, 6 months ago
Dear JDBC,

read more / 0 comments

mySQL caching

Posted by: scoopseven in MySQL 16 years, 6 months ago
Here are a couple of sql statements to view your cache settings on a mySQL server. More on what they mean later (or at least a link).

read more / 0 comments

SQL Fun

Posted by: scoopseven in Database MySQL 17 years, 6 months ago
select a.*, ba.column1, bb.column1

read more / 0 comments

Recent Tweets

Recent Posts

Archive

2013
2012
2011
2010
2009
2008
2007
2006

Categories

Authors

Feeds

RSS / Atom