Database - Read For Learn

#1214 – The used table type doesn’t support FULLTEXT indexes

I’m getting an error saying that the table type doesn’t support FULLTEXT indices. How can I achieve this? Here’s my table: *

Get the new record primary key ID from MySQL insert query?

You need to use the LAST_INSERT_ID() function: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id Eg: This will get you back the PRIMARY KEY value of the last row that you inserted: The ID that was generated is maintained in the server on a per-connection basis. This means that the value returned by the function to a given client is the first … Read more

what is the difference between triggers, assertions and checks (in database)

Triggers – a trigger is a piece of SQL to execute either before or after an update, insert, or delete in a database. An example of a trigger in plain English might be something like: before updating a customer record, save a copy of the current record. Which would look something like: The difference between … Read more

How to create a foreign key in phpmyadmin

You can do it the old fashioned way… with an SQL statement that looks something like this This assumes the keys already exist in the relevant table

‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)

The error is self-explanatory – you cannot issue a CREATE PROCEDURE statement unless it’s the only statement in the batch. In SSMS the GO keyword splits the statement into separate batches, so you need to add one after the statement before the CREATE PROCEDURE:

Can I use multiple “with”?

Try: And yes, you can reference common table expression inside common table expression definition. Even recursively. Which leads to some very neat tricks.

Hibernate dialect for Oracle Database 11g?

Use the Oracle 10g dialect. Also Hibernate 3.3.2+ is required for recent JDBC drivers (the internal class structure changed – symptoms will be whining about an abstract class). Dialect of Oracle 11g is same as Oracle 10g (org.hibernate.dialect.Oracle10gDialect). Source: http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/session-configuration.html#configuration-optional-dialects