gardening | Vagrant Box for PHP web developers | Continuous Deployment library

Need to do it for lower Mysql version like 4.9 to 5.6

I need to copy one table column data to another table but need to apply unique check and in case found duplicate then needs to add suffix to data and continue the update.(Don't want to stop query execution because of duplicate data) .

Let me clarify things:

My first table is tbl_categories:

I am trying to write a function that will return specific elements of a global string variable upon a given parameter. In this scenario, I want it to return the credentials of fictional people. The solution should NOT have to alter anything in the variable.

I have the following code:

I'm aware this question has been asked many times but I can't find the solution to my specific problem. I'm guessing that I need to refactor my code entirely but could use some guidance.

I am practicing OOP in Javascript. I would like to join an array and add an "and" conjunction before the last element. That way [1, 2, 3] ==> "1, 2, and 3".

I have included my code with comments below. As you will see, the current output I'm getting is "1, 2, and, 3". How can I get rid of the extra comma? Am I going about this the wrong way?

I mapped an array of objects and added a button for each object.

How can I make those buttons increase the "points" value (+ 1) on click, but only for the item the button clicked on & store it in the failedArr array.

failedArr array:

I'm trying to map all the "failed subjects and their points" into one array and add a button for each subject that will increase value of points but only for the item clicked.

JSON file:

I am using Antdesign checkBox to make a section of the filters where users can select different parameters to show data.

this post is similar to this: Remove rows from pandas dataframe if string has 'only numbers'

But my difference is that there are rows that contains numbers (e.g. 3.3.2 etc). I want to be able to remove the rows but I am not sure if they are classified as float or string.

Sample data frame:

Desired data frame after removal of rows:

Thank you so much in advance.

Dictionary records: [{'Name': 'Rural-Lands-Strategy-Final-v2', 'Folder Location': 'Files\\Cootamundra-Gundagai', 'Coded Text': 'Action 3.3. On farm trials Allow for trials of small scale agriculture without development consent provided environmental and amenity impacts do not give rise for concern for Council and other agencies. The scale and timeframe must also be agreed to in writing. These uses and circumstances would need to be listed in Schedule 2 of the LEP.', 'Document Title': 'Rural Lands Strategy', 'Council Name': 'Cootamundra-Gundagai', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Economic Development', 'Topic': 'Local food producers'}, {'Name': 'The_Hills_Shire_Council_Annual_Report_2018_-2019', 'Folder Location': 'Files\\The Hills Shire', 'Coded Text': 'We embed sustainability principles into all areas of our work. This includes sustainable planning, transport, design, food production,', 'Document Title': '2019 THE HILLS SHIRE COUNCIL \nANNUAL REPORT \n2018-19 1 THSC', 'Council Name': 'The Hills Shire', 'State': 'NSW', 'Type of council': 'Metropolitan', 'Domain': 'Sustainability and environment', 'Topic': 'Sustainable food production'}, {'Name': 'TSC10479_Statutory_Annual_Report_2018_2019', 'Folder Location': 'Files\\Tweed', 'Coded Text': 'Home Expo \nIn September 2018, more than 600 people attended the sixth annual Tweed Shire Sustainable Living Home Expo held at Kingscliff TAFE. \nNinety per cent of attendees who were surveyed at the expo identified actions they intended to take following the event to improve sustainability at home. Planned actions included steps to reduce waste, increase energy efficiency, improve biodiversity, grow backyard food gardens and save water. At the expo, Mayor of Tweed, Katie Milne launched a $60,000 Tweed Shire Innovative Solutions Grants Program to encourage and support individuals, businesses, schools, organisations and community groups to develop innovative solutions to a range of sustainability challenges in the Tweed. On 16 September 2018, Sustainable House Day was held across Australia, and for the first time, the event included an open house in the Tweed. More than 100 people visited Elwood Farm in Limpinwood to marvel at the sustainable features home designers and owners Len and Robyn incorporated into their sustainable dream home.', 'Document Title': 'Annual Report 2018–2019', 'Council Name': 'Tweed', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Health and wellbeing - Education campaigns and events', 'Topic': 'Festivals with interactive education'}, {'Name': 'Brewarrina Child Care Centre policies', 'Folder Location': 'Files\\Brewarrina', 'Coded Text': 'educate children about diversity eg different skin colours, different abilities, different foods', 'Document Title': 'Brewarrina Child Care Centre', 'Council Name': 'Brewarrina', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Health and wellbeing - Education campaigns and events', 'Topic': 'School and childcare settings'}, {'Name': 'Annual-Report-201819_Byron', 'Folder Location': 'Files\\Byron', 'Coded Text': 'Refill Here Drinking Fountain Program', 'Document Title': 'Annual Report', 'Council Name': 'Byron', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Health and wellbeing', 'Topic': 'Drinking water access'}, {'Name': 'housing-strategy_Sutherland', 'Folder Location': 'Files\\Sutherland Shire', 'Coded Text': 'Sutherland centre is an appropriate location to increase residential density so that more people can benefit from being within walking distance to the station, shops and services. Sutherland is already a favoured housing choice for young people as it is a relatively affordable location that offers excellent public transport to jobs in the city. The housing strategy aims to further increase the number of small dwellings in the centre.', 'Document Title': 'HOUSING STRATEGY', 'Council Name': 'Sutherland Shire', 'State': 'NSW', 'Type of council': 'Metropolitan', 'Domain': 'Social and housing policy', 'Topic': 'Affordable housing'}, {'Name': 'mwrc-adopted-operational-plan-2019-20-sm', 'Folder Location': 'Files\\Mid-Western Regional', 'Coded Text': 'TIMEFRAME RESPONSIBILITY 30/06/2021 Review and release land for development as required Suitable land available 30/06/2020 Strategic Planning 30/06/2020 Strategic Planning 30/06/2020', 'Document Title': 'DELIVERY PROGRAM 2017/18 – 2020/21 OPERATIONAL PLAN 2019/20', 'Council Name': 'Mid-Western Regional', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Social and housing policy', 'Topic': 'Affordable housing'}, {'Name': 'Delivery_Program_2018-2021_Jan_2019v2', 'Folder Location': 'Files\\North Sydney', 'Coded Text': 'Support community in the development of community gardens, rooftop and hard surface greening', 'Document Title': 'DELIVERY PROGRAM 2018/19-2020/21', 'Council Name': 'North Sydney', 'State': 'NSW', 'Type of council': 'Metropolitan', 'Domain': 'Sustainability and environment', 'Topic': 'Food gardening'}, {'Name': 'Economic Development Plan PDF - 2015-2020_0', 'Folder Location': 'Files\\Bellingen', 'Coded Text': 'Participate in the Annual Mid North Coast Food Forum in partnership with other LGAs to enhance Industry development and commercial opportunities', 'Document Title': 'Economic Development and Tourism Plan 2015 - 2020', 'Council Name': 'Bellingen', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Economic Development', 'Topic': 'Local food initiatives'}, {'Name': 'QPRC_Tourism_Plan-_2017-2025', 'Folder Location': 'Files\\Queanbeyan-Palerang', 'Coded Text': 'Work with local wineries and produce suppliers to increase the presence and promotion of local wines and seasonal produce available in restaurants and cafes within the region and in Canberra', 'Document Title': 'QUEANBEYAN-PALERANG REGIONAL COUNCIL \nTOURISM PLAN 2017–2025: Supporting the Visitor Economy', 'Council Name': 'Queanbeyan-Palerang', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Sustainability and environment', 'Topic': 'Food chain connections'}]

I'm trying to create a menu that will let user try again until they enter a valid selection which is (1-5). If user enters something else, I want it to show a error message and keep letting them try again. Clearly my problem here is in my while loop, but I'm not sure how to solve this bug. Can someone help me to restructure this code, thank you.