Mysql – easiest way to retrieve one column’s values using SubSonic (Column isn’t primary)

activerecordMySQLsubsonicsubsonic3

I'm using AcriveRecord in SubSonic 3.0.0.3 with MySql.
Is there some easy way to perform something like "SELECT CustomerAddress FROM customers" rather than .All() which performs "SELECT * FROM customers"? And how to get distinct values?

Best Answer

var qry= from c in Customer.All()
         select new {
            c.CustomerAddress
         }

Related Solutions

Mysql – Select all columns except one in MySQL

Actually there is a way, you need to have permissions of course for doing this ...

SET @sql = CONCAT('SELECT ', (SELECT REPLACE(GROUP_CONCAT(COLUMN_NAME), '<columns_to_omit>,', '') FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '<table>' AND TABLE_SCHEMA = '<database>'), ' FROM <table>');

PREPARE stmt1 FROM @sql;
EXECUTE stmt1;

Replacing <table>, <database> and <columns_to_omit>

MySQL – force not to use cache for testing speed of query

Try using the SQL_NO_CACHE (MySQL 5.7) option in your query. (MySQL 5.6 users click HERE )

eg.

SELECT SQL_NO_CACHE * FROM TABLE

This will stop MySQL caching the results, however be aware that other OS and disk caches may also impact performance. These are harder to get around.

Best Answer

Related Solutions

Mysql – Select all columns except one in MySQL

MySQL – force not to use cache for testing speed of query

Related Topic