#mysql - Thu 17 May 2007 between 00:01 and 00:28

NY Lost Funds



XgcUltraVi01: If you want to actually change the table data, use an UPDATE statement.
gverigQuestion... 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?
XgcUltraVi01: UPDATE tblname SET field=CONCAT(field,'.jpg') WHERE field NOT LIKE '%.jpg';
UltraVi01I'll give that a try
thank you very much
XgcUltraVi01: That will change the table data in the database. Is that what you want?
UltraVi01well i'd rather create a new table with the .jpg added
but i can't get that to work
XgcUltraVi01: CREATE TABLE tblname2 LIKE tblname1; INSERT ... SELECT ...;
miraceegverig: what do you want? the numbers of rows or an unique row id?
gverig: auto_increment didn't count the rows
Xgcgverig: 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.
Sashianyone know
if you can split MySQL Dbs across multiple HDS?
seekwillSashi: Yes. Symlinking works.
Sashihow?
seekwillSashi: I even believe you can specify the path in the MyISAM table definition
actionseekwill like symlinks
seekwilllike symlinks
Sashihmm
but symlinking
isnt really on different hds thou
its more like.. a shortcut isnt it
seekwillIt's a shortcut to the file on a different harddrive.
Sashiah i see now
seekwill!man create table
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/create-table.html
Sashiseekwill: but
its a innodb file
seekwillLook at the "DATA DIRECTORY" and "INDEX DIRECTORY"
On that page
Sashiwould that work with innodb?
seekwillRead it...
Sashinvm
not for innodb
seekwilloh darn
Sashi: InnoDB has an option to use one file per table. Maybe that will help?
Sashiwhat about different DBs on different HDs with InnoDB?
symlink?
seekwillNo

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds