MySQL table names into stored procedures and functions

relevance: [3.06]

2011-01-17

As an aid memoir; Firstly, to create stored procedures in MySQL you need to temporarily change the line delimiter so you can add code with normal delimiters without delimiting what you're currently doing. Secondly, in order to use variables passed into a procedure you need to concatenate into a...

MySQL full indexed text search - just like a real database!!

relevance: [2.99]

2009-03-24

As of My Sql 3.something you can now add text indexes to your columns and do full text searches with relevance ranking! text indexes are fantastic and allow more efficient searching and categorisation of text. The relevance ranking feature is rather good too and gives you a much better idea of how y...

MySql code - left join group by

relevance: [1.63]

2007-08-06

SELECT * FROM holiday_dates LEFT JOIN holiday_rentals ON holiday_rentals.week = holiday_dates.week AND holiday_rentals.house_id = 3 GROUP BY holiday_dates.week...

MYSQL UNION SELECT NULL

relevance: [1.43]

2007-08-27

SELECT * FROM crh_houses LEFT JOIN crh_p_tags ON crh_houses.house_id = crh_p_tags.house_id WHERE crh_houses.house_id = 3 UNION DISTINCT SELECT *,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL FROM crh_p_tags WHERE crh_p_tag...

Setting up JBOSS Seam

relevance: [0.92]

2007-11-30

from a command prompt/shell within the jboss-seam directory type the following: [path...]\jboss-seam-2.0.0.GA>seam setup Buildfile: [path...]\jboss-seam-2.0.0.GA\seam-gen\build.xml init: setup: [echo] Welcome to seam-gen :-) [input] Enter your Java project workspace (the directory th...