Skip to content

icefront.info

  • Graphics
  • Web Development
  • Windows
  • Stock

Category: MySQL

Return MySQL query as a single string

January 23, 2013 icefront

I was playing with some statistics and wanted to display some queries as a single, comma-delimited text. Why one may need this? Since the result of the queries can be concatenated in an endless ways by (eg. PHP) code… The answer: to have one-line query returning directly the string – eg. for statistical purposes only. […]

Read More
MySQLLeave a comment

MySQL: Select field, replace text from another table

October 1, 2012 icefront

I have two tables, “products” and “brands”. In the “products” table, the product’s name is in the “name” field. The product’s brand is represented by the # (diez) character. To know which is the brand, there’s a “brand_id” field. So far we have: products table: id: int name: varchar brand_id: int brands table: id: int […]

Read More
MySQLLeave a comment

Recent Posts

  • Explode empty string returns one-element array
  • Always ask before running this file
  • Batch convert files to LZW TIFF
  • Set up a FTP server (pure-ftpd-mysql)
  • Monitor adjustment charts

Recent Comments

  • icefront on Set up a FTP server (pure-ftpd-mysql)
  • Csaba Bocskai on Set up a FTP server (pure-ftpd-mysql)

Archives

  • December 2014
  • July 2013
  • May 2013
  • April 2013
  • February 2013
  • January 2013
  • October 2012
  • September 2012

Categories

  • Debian
  • Graphics
  • HTML, CSS Tricks & Solutions
  • MySQL
  • PHP
  • Stock
  • Web Development
  • Windows

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Theme of 96 THEME.