Cirri: Maybe there is a way that does not require external app, seems like there are three tables architecture, domain-architecture linking table without repeats and domain table, maybe if I could figure out how to join them together with repeats.
Clyatt: Reller: Later if you need to SELECT such list in a single column GROUP_CONCAT will do it
Clyatt: Reller: What repeats?
Clyatt: Rumery: Yes all RENAME needs is metadata lock
Puffinburger: Salle, architecture can have the same domain multiple times
Clyatt: Reller: Sounds perfectly normal
Clyatt: Reller: How is that related to the question about the list of values in single column?
Clyatt: Rumery: Do you mind private message?
Clyatt: Reller: Against everything and everyone :
Xue: So , I’ve been giving the glorius task of importing a spreadsheet into a db , problem is the data spans three tables , two of those require the auto increment ID from the the first table. To make it even worse , this info may already be in the db too!
Mericle: Any advice on how a can achieve this?
Decoux: P***word2: update with a join.
Tredinnick: Ooh , I’ve never done that , will google now
Decoux: P***word2: UPDATE t1 JOIN t2 ON t1.col = t2.col SET t1.othercol = t2.othercol WHERE .
Decoux: P***word2: after you insert the raw data
Clyatt: P***word2: Brute force: Import everything in new database and then compare the tables with existing tables to see what you need to UPDATE
Clyatt: P***word2: INSERT . ON DUPLICATE KEY .; can help too
Maschak: I might just write a short piece of code too
Rumery: Thats a solution too, if you feel better at some language which would make it simpler for you
Clyatt: P***word2: You will need a short piece of code in any case to split the data in three tables and decide what to update
Tankard: And i need to clean some of the data too
Imig: P***word2: import a sheet to a temporary table and give an id field to that table
Imig: Then normalize that huge table into smaller ones
Jeanbaptiste: But the ids should not conflict with the existing IDs thats already in the db
Brabham: I think code might be a smarter way , as this would certainly pave the way to an automatice importer
Griffis: As I doubt this would be the last time I would need to do it
Clyatt: P***word2: Depends on how complex the task is
Hachette: Complete noob here needing some help
Go: I made a basic 2 column table name,dob, i want to change the data value type of dob to date format
Rumery: Uriz3n, in what format is it now? and did you already populate it with data?
Willour: I originally entered a value and it converted it to some decimal, I think ive changed its format but the DOB shows as 0000-00-00 00:00:00.0
Maleh: Did I lose the data or is this due to my ALTER change to DATETIME 6
Rumery: If it contained “some decimal” then I would expect the ALTER to lose it if it was not able to convert back which is very probable – it might even give some warnings about it
Decoux: Uriz3n: the datetime format is YYYY-MM-DD HH:MM:SS
Muraoka: I would like it to just be DD-MM-YYYY
Almeida: Ok, and is there a command to show me what I currently have selected?
Clyatt: Uriz3n: SHOW CREATE TABLE your_table;
Clyatt: Uriz3n: MySQL uses ISO format with year first as Decoux told you
Clyatt: Uriz3n: You can always use different format when SELECTing with DATE_FORMAT
Bozell: Hello. Is it possible to LIMIT a JOIN? I have a table customer and a table updates and i want 60 results per customer from updates. any ideas?
Decoux: IsntFunny: yes, with derived tables