composite Keys

Hi, does MySQL support composite keys? I have a table 'Group_Map' This has 3 fields contact_id (primary key in another table) group_id (candidate key in another table) user_id (primary key in another table) is it possible / advisable to create and maintain a composite key for this table?

operators in mysql

Hi, can operators be used in MySQL e.g. a table Table X with column A, column B column C All three are floats can I use select (A-B) from X where or will I have to so the A-B calculation in my application code instead? Also can I use select C from X where Then update X set C = (ret

database dump query

Hi, anyone know what happens if, while I am doing a database dump, someone logs into the database and updates records, what records are trapped in the dump, or can the dump proceed under this circumstance...in other words must I knock all users off the database before the dump is done? Many than

mysqldump command error

I have read the documentation on the MySQLDump, but have been unable to launch a mysql dump. Is the dump performed while logged on to the database that you want to dump, or do you log onto the machine where the database is and specify which database you want to dump?. I have looked at and applied

elegant backup

I did a back up of a database (datbase_1),generated the dump file from database_1 I then created a new database database_2 and imported the dump file from database_1 into database_2 I then copied all the data files (located at mysql\data\database_2) from database_2 to database_1 Restarted databa

ibdata1 size

HI, the ibdata1file in mysql\data has reached a size of 10Mb in just over a week, the database I have set up is quite limited, only 7 tables with no more than 12 records in any one table (only evaluating database models on MySQL at the moment). I have done 4 MySQL dumps and some inserts / updates

RE: question on autoincrement

similar-ish to setting your sequence in oracle try this: The create table statement below will start the auto increment at 1 CREATE TABLE TableX ( X_primary_key INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, X_col1 VARCHAR(20) NOT NULL, X_col2 VARCHAR(40) NOT NULL, X_col3 VARCHAR(10) NOT NU

opinion please

I am going to have a web hosted MySQL database. It will hopefully have 100+ users. I was thinking of having one database to store all records for all users. I would store a user_id against records where appropriate to relate them to a particular user. The database will have a contacts table, users

alter table query

I have a table that has a column : session_id INTEGER UNSIGNED NOT NULL, I now want to store a hexadecimal value in this column instead. the column already contains values for some records.can I alter the data type of this column (make it a varchar) without loosing the data already stored? o

where clause query

does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as used in oracle. select * from tableX where tableX_id IN ('1', '2', '3') i.e. if I have a comma delimited list of values for a certain field on a table...I can search for all records that have the values in my comma delim

timestamps and timezones

I see that LOCALTIMESTAMP and LOCALTIMESTAMP() are synonyms for NOW() when I use now() I get the database time but I have a webhost based in US (Pacific Time), however most database events will be generated from BST and this is the time zone I want to use to populate audit trail tables etc. I c

mysql web host

Hi, I know this may not strictly be within the remit of this mailing list but. I am having problems with my web host, I need to use Innodb tables, however my web host will not allow these table types (because of the obvious extra overhead), can anybody out there recommend/currently use a

store file in MySQL database

Hi, I want to store a .txt file in a table in a MySQL database, typically what is the best type of data type/ column to use for this. The .txt will not exceed 100K. Thanks Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

triggers

Hi Are there any plans to have triggers introduced into MySQL? Regards Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]