Hey Python Coders, I have 2 Mysql tables dumped on my local Pc that are .sql files. Let resume this two tables name is: Table A and Table B A= have Userid with some data. B= have same UserId as table A with some data. So i want a script to grab me a column of data from Table B By using Userid from Table A That Mean All Userid from Table
I have 73 SQL files with size is 9 GB , These files needs to be import to database , actually these files are exported by different ways. What fix is ? some file contain delete command before inset and another don't have some file have id and another dose not have fix mean union the style of files My need is insert these files in one datab...
Need a Java program that can be ran as a cron job and update MySQL table with data from two JSON files (https, publicly available): 1) Loop through my table (4 rows only for now) 2) Read JSON URL from json_url field for each item 3) Access JSON and find corresponding tag ("tag":"BTC") 4) Collect 6 values from JSON for each item and update my table
...will be asked for registration. First name, last name, email and phone number. (These will be stored in MySQL) *The system will check if there is an active quiz, which is enabled or disabled through admin control panel. (You can use 1/0 on SQL) *If active, the system will begin to show the quiz questions, answer options, and store their answers
...an external mysql database. Services: 1. Create a login form based on CPF (Brazil's ID) and birth date. Remember that this information are located inside an external database. 2. After the login, a printable membership card with the name and customer code may appear on screen. I already have the php files to connect with sql database. So
I have a MySQL table with information of people profile. I have a MySQL table with business letter templates. I have a MS SQL table with information related with MySQL tables. I already have a php script, when user selects a row in a bootstrap front end, generates 1 PDF for each row selected, doing a data merge between 3 tables. Problem to
Simple Python Project with inserting CSV files into a DB (DB Model/SQL provided - MySQL) and applying provided (detailed) algorithm description to data for generating result values and storing them in a database as well. The detailed spec will be provided to qualified developers.
I have a script [url removed, login to view] that runs every 5min to update currency rates via API into mySQL db and to generate static file [url removed, login to view] with rates in this folder /widget/[url removed, login to view] for some reason, its updating SQL DB but not generating file, all files permissions are correct just the script needs adjustment. NOTE: I need to ...
...need a SQL database running on mysql that I can populate tables from Excel. Each table will be 1 tab on an Excel file. When a tab is uploaded to the SQL database it is to replace all data within that SQL table. This needs to be password protected with an admin level user. The second half of the project is I need to be able to add to Excel files a tab
...load two files into a MySQL db. The deliverables for this project are (i) detailed specific instructions for performing the data conversion/loading; (ii) a SQL file I can import, which contains schema definition and all data from the Excel files; (iii) help/support if needed loading the data, so I can work with it in SQL on my local MySQL server (window...
...a python 2.7 script - using pyparsing module to scan mysql source files. Those Mysql files may containing multiple SQLs statements and comments. The coding style can be different, the only assumption is that the developers of those scripts tried to make it compatible with mysql , Pyparsing script needs to detect: 1. if there
i have one music web site. i stored my sql data in single table. some artist data has two names with comma seperated. am planning to group distinct values with count. I have small knowledge about mysql, sqlite so tried but failed. can any one give that command in mysql. thank you. example id | name | singers | music-dir | ----|------
Hey, Error after restoring the .sql database (Check MySQL ERROR [url removed, login to view] + Error when trying to access the website (check attached files) Website: [url removed, login to view] Ecommerce Magento . Server: Localhost via UNIX socket • Server type: MySQL • Server version: [url removed, login to view] - MySQL Community Server...
...to fix a website scrapper that no longer works because the website changed. Also add some extra functionality. The program runs from the command line in Java 1.4 on top of mySQL 3. The program logs into [url removed, login to view] and browses through product categories to find each product page. Then it inserts/updates product data to the database. There
...development of application on Cloudera or Hortonworks platform. Should implement complex algorithms in a scalable fashion. Core data processing skills are highly important with SQL tools like HIVE/Impala/LLAP Should be able to write MapReduce jobs or Spark jobs for implementation. Ability to write Java based middle layer orchestration between various
I am looking for a freelancer to help me with my project. The skills required are...looking for a freelancer to help me with my project. The skills required are Link Building, MySQL, SQL and Statistics. I am happy to pay a fixed priced and my budget is ₱10000 - ₱30000 PHP. I have not provided a detailed description and have not uploaded any files.