ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF. ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.Constra...

SELECT btype_ind  FROM blog_prop AS bip  WHERE NOT  EXISTS (    SELECT btype_id  FROM blog_type AS bit  WHERE bit.btype_id = bip.btype_id  )  LIMIT 0 , 30     ALTER TABLE blog_prop  ADD CONSTRAINT blog_type_link  FOREIGN KEY (btype_id)...

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...

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...

As a point of reference how to convert a comma delimited file to an SQL insert Assuming your data is the following 'key','value','0' 'key','value','1' In notepad++ the syntax for search and replace would be as follows: search: ('[^']+','[^']+','[^']+') replace: (\1) syntax varies d...