IsntFunny: yes, with.

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

Lulas: Uriz3n: See

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