text:
Q: Multiple unique entries on table update mysql Right now I have a table with an auto increment id number, a name, and a definition
I am updating the table with values from another table using
INSERT INTO words(id, word, definition) SELECT id, word, definition FROM temp
ON DUPLICATE KEY UPDATE words.word = temp.word, words.definition=temp.definition;

The table temp has the same exact column layout as the table I am using, and it works fine except when I delete an entry from the middle of temp and then update my main table.
For example,
temp
id  word definition
1   bob   is a cat
2   sam   is a dog
3   doug  is a monk
4   croe  is a bird

table main is set to that
Then I remove row 2 from temp
temp
    id  word definition
    1   bob   is a cat
    2   doug  is a monk
    3   croe  is a bird

and then update main table
main
id  word definition
1   bob   is a cat
2   sam   is a dog
3   croe  is a bird
4   croe  is a bird

because temp only has 3 rows now, but main HAD 4, the 4th row isn't deleted. I tried to fix this by making word a unique column, and now I get the error that there is a duplicate entry for key 'word'.
So how do I fix this?

A: From the MySQL manual,

In general, you should try to avoid using an ON DUPLICATE KEY UPDATE
  clause on tables with multiple unique indexes.

so, what you could do is make word your primary key, and get rid of the id column. That should do the trick :)
Your query then becomes
INSERT INTO words(word, definition) SELECT word, definition FROM temp
ON DUPLICATE KEY UPDATE words.word = temp.word, words.definition=temp.definition;

If you need arbitrary sorting, I would create an additional table
CREATE TABLE word_order (VARCHAR(30) PRIMARY KEY, sort_order INT)

and then when you run your queries
SELECT words.word,
       words.definition
FROM words
JOIN word_order
ON words.word = word_order.word
ORDER BY word_order.sort_order

Your INSERTS become a little more complicated though, you'd have to run multiple inserts. See sql - insert into multiple tables in one query.
Also, this CodeProject article has some more ideas on the topic.

redpajama_set_name: RedPajamaStackExchange


With exactly one month until the start of the semester, the Life Science Institutes have shown no signs of a summer lull. A number of our faculty have been seen in the news (listed below), with exciting developments in their research, new grants, or commercialization. Additionally, give our strength in imaging, please take a look at the upcoming NIH workshop (Aug 23-24) on AI in Medical Imaging. Registration for the workshop is open.
Thanks to all the groups who submitted proposals to PIDD's programmatic area RFA. We received over 20 applications and the Institute is working with both internal and external reviewers to identify the most meritorious projects.
Dear PI4D members and friends, we are excited to let you know that we have finally made the move to the Hall for Discovery and Learning Research. The official headquarters of PI4D is now located on the fourth floor in DLR 425 (207 S. Martin Jischke Drive, West Lafayette, Indiana 47907-1971). We are also delighted to welcome the eventual arrival of Rob Stahelin (MCMP), Doug LaCount (MCMP), Mohamed Seleem (CPB) and Graham Cooks (Chem), along with their research groups. I am also excited to welcome Rainer Fischer from the Indiana Bioscience Research Institute to locate his Purdue operations in the DLR. Rainer was recently appointed as the Purdue University President's Fellow in the Life Sciences and we are thrilled to work with him in joint initiatives. I can't wait to see our labs filled with investigators excited to push the limits and make great discoveries through their pursuit of bringing translatable biomedical solutions for diseases that plague humanity.
In recognition of his contributions to the field of Parasitology, Dr. Dennis Minchella was the latest recipient of the Distinguished Service Award given by the American Society of Parasitologists. Dr. Minchella marks the eleventh recipient of the award in society history, joining the company of an author of the textbook 'Foundations of Parasitology' and a Nobel Prize winner the discovery of the anthelminthic drug ivermectin, among others. Congratulations to Dr. Minchella for this well-deserved award!
SIERRA Club Team – Zane Baird (IBRI); Christina Ferreira (Purdue); Michael Pugia (IBRI); Zehui Cao (IBRI) and Gerald Denys (IU). Precision diagnostics for difficult to treat urinary tract infections through the development of a mass spectrometry-based technique to identify molecular signatures of antibiotic resistant bacteria.
IU CPR Team – Jack Schneider (IUSM); Christopher Emery (IUSM); Luna Lu (Purdue); Aline Elquist (Purdue); Thomas Davis (IUPUI); Michelle Zimmerman (IUPUI). Developing a rapid antimicrobial susceptibility testing device based on piezoelectric sensors for clinical laboratory pathology applications.
Supersoakers Team – Robert Bacallao (IUSM); AMI Labs (Purdue); Center for Algorithms and Machine Learning (IU-Bloomington) Diagnosing and treating acute kidney injury through the development of controlled infusion technology to restore renal function.
Winning Team –Jackeline Franco (Purdue); Valentina Pirro (Purdue); Pamela Thomas (Notre Dame); Harm HogenEsch (Purdue); Paulo Gomes (Purdue). Design and development of a specialized sampling kit for molecular diagnosis of atopic dermatitis for veterinary and human clinical applications.
Sponsors of the event were: Purdue Institute of Inflammation, Immunology and Infectious Disease; Chemistry, College of Science, Purdue University; Clinical and Translational Sciences Institute; College of Engineering, Purdue University; College of Pharmacy, Purdue University; College of Veterinary Medicine, Purdue University; Indiana Biosciences Research Institute; Indiana University – Bloomington; School of Medicine, Indiana University; and University of Notre Dame.
Thank you to, Dr. DiMarchi, all who attended, the teams that were formed and those who sponsored the event. The group consensus was there should be several mixers and another competition. Special thanks to Melanie Lindsay, Becky Fulk, and Cindy Roberts for all their hard work in organizing this event.
Greetings to the PIIN community!
Dr. Pedro Irazoqui (BME, ECE) has stepped down from PIIN's leadership team to assume the role of interim head for the School of Electrical and Computer Engineering. Pedro has been instrumental in guiding us since PIIN's inauguration in the Fall of 2015 and we are deeply grateful for his service to the Purdue neuroscience community. His passion and expertise have ensured that PIIN lives up to its motto of being a place "where science meets engineering".
PIIN's administrative staff have been busy preparing the space within the newly renovated 3rd floor of DLR in Discovery Park for occupation in the late summer and fall. We will soon be welcoming the lab of Dr. Aaron Bowman who joins Purdue as the new head of the School of Health Sciences. His research on neurotoxicology and neurodegeneration uses animal models and human induced pluripotent stem cells. The expertise and proximity of Dr. Bowman to the new Neuroscience Cell Engineering Core will enhance its utility. To create an interdisciplinary working group with overlapping research interests, DLR will also house the labs of Dr. Chris Rochet (MCMP), Dr. Jason Cannon (Health Sciences) and Dr. Yang Yang (MCMP). Additional research space is being reserved for new faculty hires.
We wish to officially welcome Dr. Sebastien Helie to PIIN's leadership team. Dr. Helie is an Associate Professor of Psychological Sciences and an Associate Professor of Speech, Language, and Hearing Sciences (by courtesy) at Purdue University. He serves as the Associate Director of the Purdue Life Science MRI Facility, and as Co-director of the Center for Research on Brain, Behavior, and NeuroRehabilition (CEREBBRAL). His research interests include computational cognitive neuroscience, cognitive neuroscience, categorization, automaticity, rule learning, sequence learning, skill acquisition, intuition in decision-making, and creative problem solving. He is a senior member of the International Neural Networks Society (INNS) and was awarded the 2012 INNS Young Investigator Award. Dr. Helie serves on the editorial boards of Neural Networks, Frontiers in Human Neuroscience, Cognitive Systems Research, and The Quantitative Methods in Psychology. His research is currently funded by the National Science Foundation and the National Institutes of Health.
Travel Grant Winners: The winners of this cycle of PIIN-sponsored travel grants represent 5 different colleges at Purdue, and thus showcase the breadth of our membership. We are particularly pleased to support those selected for oral presentations at major conferences, and those who are presenting at the Society for Neuroscience Annual Meeting. Congratulations!
June 6 - August 1:Neuronetworking Seminar Series meets on Wednesdays at 4:00-5:30pm (except July 4th). REGISTRATION IS REQUIRED. Please join us for the talks, followed by a light dinner and conversation with fellow PIIN members.
We have released our Internal Funding Pilot Grants Calendar for the upcoming school year. It can be found on our websites internal funding opportunities page, via the "Master Pilot Grants Calendar FY18-19" link.
Please join us Thursday, August 23rd from 11:30 am – 1:30 pm for the "Hammer Down Cancer Luncheon", taking place at McGraw's Steak Chop & Fish House. Tickets are available for purchase here.
We are pleased to announce that Regenstrief Center research scientist and PI Md. Muniril-Haque received NIH funding for mobile-based care for children with Autism Spectrum Disorder (ASD). The technology, called mCARE, is an evidence-based and data-driven remote behavioral monitoring platform for the care practitioners of children with ASD. mCARE will be tested with caregivers of 300 children with ASD in Bangladesh for one year. The children will be selected from four reputed ASD care institutions in Bangladesh.
Venture capitalist Milad Alucozai, founding partner at Good AI Capital, will hold the position of visiting scholar at the Regenstrief Center for the 2018-2019 academic year. Good AI Capital is a San Francisco-based venture fund that focuses on early stage investments in AI companies. Milad, a Purdue alum, will help grow capabilities for the Center in AI and data science in healthcare. His appointment will also help to develop and enhance the Center's entrepreneurial ecosystem.
Finally, a special thanks to Jenna Moretti for updating the RCHE website.


text:
Home \ Programs \ AAU Academy \ Genius of Prague
AAU Academy LovePrague Course
Genius of Prague
Explore Prague through the lens of Music, Architecture, Literature, and Film, and get a glimpse of some extraordinary artists who shaped history.
30 Years of Education
Schedule and Course Content
Track LovePrague
Instructor Multiple
Date February 2 - 23, 2021
Format Four-week course
Delivery On campus / in city
Price 6,000 CZK
AAU Academy Brochure
Please submit your details in order to receive the AAU Academy Bochure via email.
Four aspects of Prague introduced by four experts in four sessions.
Join author and musician Pavla Jonssonova to learn about Czech musical greats in Prague Soundscapes, and art historian Marek Cerveny to get insight into Modern Prague Architecture, focusing on Art Nouveau, Cubism and Constructivism.
Professor Richard Stock will introduce Franz Kafka's works and ''his'' Prague at the turn of the 20th century, and actor and producer Joe Weintraub will round off the course with a glimpse into the cinematic genius of Milos Forman and perhaps inspire participants to create their own films using the beautiful backdrop provided by the City of a Hundred Spires.
Delve deeper into Prague's history with academic insight through experiential classes
Meet the great names and understand the styles that helped shape Prague from a city on the periphery of an Empire to the bustling capital of an independent Republic.
This is an active learning course involving dialogue and experiential learning around the city. It is an academic course and the lecturers will provide insights from research, historical accounts, and lead participants while exploring real sites around the city.
Each session is 3 hours long. Sessions 1 and 2 will be conducted by walking around Prague, thus good shoes and some refreshment (water etc.) recommended. A coffee break in a café is included, with free coffee or soft drink for each participant. Sessions 3 and 4 will be combine in-class lecture and a walk to relevant places in the city.
For a detailed course schedule and content, please download the Course Outline.
Session 1: Music
Prague Soundscapes (Pavla Jonssonova)
After meeting at Výtoň tram station. Participants will then head over to the cemetery of the Czech greats, where we will pay our respects to the best Czech composers Bedřich Smetana, Antonín Dvořák, opera diva Emmy Destinn and country music star Waldemar Matuška. Then we take the metro to Dvořák´s museum. Our final stop will be at Reduta jazz club, where president Clinton performed for Václav Havel.
A copy of Prague Soundscapes by Zuzana Jurková will be provided for all participants to complete the walk with readings.
Výtoň tram stop (by Naplavka)
Map: https://goo.gl/maps/tidCPFUgFVdRV1oj7
Session 2: Architecture
Modern Prague – Art Nouveau, Cubism and Constructivism (Marek Červený)
The Architecture session will start with a short introduction to the position of Prague, its population, and the complicated artistic situation at the end of 19th century. After that we will proceed into the New Town where most of the famous examples of Modern architecture can be found. We will discuss how the National Revival movement reflected its ideas in architecture and how the younger generations of artists rebelled against this "old fashioned" tradition replacing the traditional and national, with cosmopolitan and modern turning their attention first to nature, and then to geometry. We will explain such structures as the National Theatre, Palacký Monument, Municipal house, examples of Cubist architecture, the Bank of Czechoslovak Legions and many more covering the period between 1880s and late 1920s.
Park Národního Probuzení on the Smetanovo nábřeží between National Theatre and Charles Bridge
Map: https://goo.gl/maps/yWmQVXxttEq2SqmX8
Session 3: Literature
Walk with Kafka (Richard Stock)
Week 3 will introduce participants to Franz Kafka and his fiction. This three-hour session will begin with a short introductory workshop on Franz Kafka and his works. Participants will learn about Kafka as well as read and discuss one of his short stories. This one-hour classroom portion will prepare everyone to go out into Prague and see Kafka-relevant sites for the remaining two hours. Commentary will be provided while viewing most of the places Kafka lived in Prague and the two major monuments to Kafka in the center of Prague. The walking part of the tour starts at AAU and ends near the Narodni trida metro station and tram stop. Since much of the architecture in Prague was present in Kafka's time, and also since Kafka loved to walk Prague's streets, the walk gives a feeling for who Kafka was, where his stories come from, and what Prague was like 100 years ago.
In this session we will explore together the following:
Why is Palach a hero in the Czech consciousness?
What is the role of responsibility in the face of repressive systems like communism?
What did Palach's short life ignite in students and adults in the Velvet Revolution and today?
AAU Campus, Letenska 5
Map: https://goo.gl/maps/uppjN5e5Y2B9B4q78
Session 4: Film
Cinematic Prague (Joseph Weintraub)
In our film session, we will be led by actor, instructor, and producer Joe Weintraub, who will take us on a historical and socio-political journey through the lens of a cinematic Prague. We will learn about the films made in, about, and around the "city of a hundred spires." We will also discover a bit about the filmmaking process by preparing for our own filmmaker's excursion through the city. So join us as we look at Prague through the cinematic perspective. Who knows, maybe you'll be the next Miloš Forman!
Handouts will be provided at the start of class.
AAU Classroom
Pavla Jonssonova, Ph.D
AAU Academy Instructor, LovePrague Courses
AAU Senior Lecturer
Pavla Jonssonová specializes in contemporary culture and subcultures. Her publications include three monographs Women, Music, Creativity: from Hildegard to Cosey Fanni Tutti in English, Devět z české hudební alternativy osmdesátých let (Czech Music Alternative of the 1980s) (English version pending) and Růžové vrány. Muzikantky 21. Století (Interviews with twenty Czech women musicians), numerous articles, interviews, poetry, and translations. Since 1980 she has performed in various rock bands e.g. Plyn, Dybbuk, Zuby nehty, who produced numerous albums and a film for television. Currently, she plays the bass for Malé zuby. She is a member of a civic association Puppets in Hospitals who perform for sick children.
Mgr. Marek Červený
AAU Lecturer
Marek studied at Charles University where he obtained his master's degree at the Department of Art History of the Faculty of Arts. He worked as an assistant to Prof. David Holeton (Charles University), Prof. Nicholas Sawicki (Lehigh University) and for the Cahen Archives, Canada. His own research focuses on modern Czech art, official art commissions and funeral art. He also works as a private tour guide.
Richard Stock, Ph.D
CEA Center Director
Originally from the Chicago area, Rick has lived in or near Prague since 1998 with his wife and three daughters. Rick is the Center Director at CEA. He's taught in study abroad programs in Prague and served as Academic Director at CIEE Prague. He also directed the creation of a new M.A. program at CERGE-EI for European students. Rick holds a Ph.D. from Charles University in Prague, an M.A. in Literature and Theory from the University of Illinois, and an M.A. in the Teaching of English as a Foreign Language from the University of Reading in the U.K. His teaching and research at the university level focuses on American Literature and Literary Theory. He also teaches a course on the Prague writer Franz Kafka aimed at American study-abroad students. Rick studied Teacher Education as an undergraduate and is deeply interested in teaching, education, and learning.
Joseph Weintraub, M.A.
Mr. Weintraub has been living in Prague for several years, teaching a variety of subjects from business to politics to humanities. His academic background is in Linguistics. He also works in the film industry as a Dialogue Coach, actor, and producer.
See what our students have to say
My Prague Experience
We do almost all of our projects in small international teams, and we work together like we would in a business company and synergize our different ideas. There's flexibilities to meet with teachers outside of class, and ask them questions, not just specifically things we learn in the class.
Business Administration, United States of America
AAU makes networking incredibly easy to do. I was able to participate in various events that don't necessarily connect to my coursework like conferences, literature festivals, debates, lectures, etc. When I was President of the Diplomatic Club, AAU helped me get in touch with event-organizers, which, for example, allowed us to host an event during the Festival of Democracy organized by the famous Forum 2000 conference.
Anastasia Mezenina
Business Administration, Russian Federation
Dana Aleksic
External Outreach Manager dana.aleksic@aauni.edu
Eva Rivera, Ph.D.
Vice-President for Institutional Advancement eva.rivera@aauni.edu
Rebecca Newhouse Admissions Counselor rebecca.newhouse@aauni.edu
Clea Boban Admissions Counselor clea.boban@aauni.edu

redpajama_set_name: RedPajamaCommonCrawl