Top "Mysql" questions

How do I add two count(*) results together on two different tables?

I have two tables: Toys and Games. +--------------------+------------------+ | Field | Type | +--------------------+------------------+ | toy_id | int(10) unsigned | | little_kid_id | …

mysql count sum

What's the difference between using INDEX vs KEY in MySQL?

I know how to use INDEX as in the following code. And I know how to use foreign key and …

mysql indexing key

What is InnoDB and MyISAM in MySQL?

What is InnoDB and MyISAM in MySQL ?

mysql innodb myisam

What does SQL Select symbol || mean?

What does || do in SQL? SELECT 'a' || ',' || 'b' AS letter

mysql sql oracle ansi-sql

What is a table prefix?

What is a table prefix, and what are their advantages and disadvantages? This is in relation to MySQL.

mysql database database-design prefix

Is the primary key automatically indexed in MySQL?

Do you need to explicitly create an index, or is it implicit when defining the primary key? Is the answer …

mysql database indexing key

Update mysql table with data from another table

Is it possible to run an UPDATE command on mysql 5.0 with a sub select. The command I would like to …

mysql sql-update

How to raise an error within a MySQL function

I've created a MySQL function and would like to raise an error if the values passed for the parameters are …

mysql function exception stored-procedures

MySql views performance

If you are going down the road of using views, how can you ensure good performance? Or is it better …

mysql database performance optimization views

Last index of a given substring in MySQL

We can find the index of the first occurrence of a given substring in MySQL using the INSTR() function as …

mysql string lastindexof