| Xgc | UltraVi01: If you want to actually change the table data, use an UPDATE statement. |
| gverig | Question... is there any reason to not use auto_increment and instead have a separate table with a counter row? First time I saw this I thought designer was a moron, now I see this for the second time and this is in IBM Websphere... Any thoughts? |
| Xgc | UltraVi01: UPDATE tblname SET field=CONCAT(field,'.jpg') WHERE field NOT LIKE '%.jpg'; |
| UltraVi01 | I'll give that a try thank you very much |
| Xgc | UltraVi01: That will change the table data in the database. Is that what you want? |
| UltraVi01 | well i'd rather create a new table with the .jpg added but i can't get that to work |
| Xgc | UltraVi01: CREATE TABLE tblname2 LIKE tblname1; INSERT ... SELECT ...; |
| miracee | gverig: what do you want? the numbers of rows or an unique row id? gverig: auto_increment didn't count the rows |
| Xgc | gverig: That might be used in an application that needs to port to many different databases. gverig; There are so many different (database specific) ways to provide that functionality, some applications just create their own mechanism using common features. |
| Sashi | anyone know if you can split MySQL Dbs across multiple HDS? |
| seekwill | Sashi: Yes. Symlinking works. |
| Sashi | how? |
| seekwill | Sashi: I even believe you can specify the path in the MyISAM table definition |
| action | seekwill like symlinks |
| seekwill | like symlinks |
| Sashi | hmm but symlinking isnt really on different hds thou its more like.. a shortcut isnt it |
| seekwill | It's a shortcut to the file on a different harddrive. |
| Sashi | ah i see now |
| seekwill | !man create table |
| the_wench | see http://dev.mysql.com/doc/refman/5.0/en/create-table.html |
| Sashi | seekwill: but its a innodb file |
| seekwill | Look at the "DATA DIRECTORY" and "INDEX DIRECTORY" On that page |
| Sashi | would that work with innodb? |
| seekwill | Read it... |
| Sashi | nvm not for innodb |
| seekwill | oh darn Sashi: InnoDB has an option to use one file per table. Maybe that will help? |
| Sashi | what about different DBs on different HDs with InnoDB? symlink? |
| seekwill | No |