Queries and scraping to tables
Posted: Wed Oct 16, 2019 4:58 am
I have a couple of questions about queries.
1. I want to enter data into a text field on a website. The data is stored in the database as three separate columns - Column1, Column2, and Column3. I need to add them all together into a string so that it reads (Column1 + " " + Column2 + " " Column3) and then enter that into a search field on a website. There will be multiple rows in the table. Once the scraper has completed the scraping for each row, I want to set a flag that denotes it has been scraped. I will be adding to this table manually on a regular basis. I want to scrape for each row that does not have this flag set. When I scrape, I want to add data to this table or have it related to the table. How do I do this?
2. How do I find the syntax for queries? For example, I am trying to do this and I keep getting an error:
SELECT * FROM tablename ORDER BY column DESC LIMIT 1
Is there somewhere I can see the exact syntax for different types of queries?
1. I want to enter data into a text field on a website. The data is stored in the database as three separate columns - Column1, Column2, and Column3. I need to add them all together into a string so that it reads (Column1 + " " + Column2 + " " Column3) and then enter that into a search field on a website. There will be multiple rows in the table. Once the scraper has completed the scraping for each row, I want to set a flag that denotes it has been scraped. I will be adding to this table manually on a regular basis. I want to scrape for each row that does not have this flag set. When I scrape, I want to add data to this table or have it related to the table. How do I do this?
2. How do I find the syntax for queries? For example, I am trying to do this and I keep getting an error:
SELECT * FROM tablename ORDER BY column DESC LIMIT 1
Is there somewhere I can see the exact syntax for different types of queries?