Write mysql database jobs

I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries. Work Expectations: - Writing proficient data definition SQL queries. - Extensive knowledge of MySQL. Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i SELECT COUNT(*) FROM ( SELECT CASE WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1) WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1) END AS srce_syst_paty_i, * FROM dev_enr.cpln_svrq_paty_detl WHERE day = '02' AND month = '06' AND year = 2023 ) src INNER JOIN ( SELE...

I'm seeking a professional to optimize my Airtable database. I need help in two specific areas: 1. Automation Workflows: - Successful at setting up automated processes in Airtable. - Ability to setup data synchronization across multiple bases. - Familiar with triggering actions based on various conditions. 2. Links between Airtable and Various Platforms: - Previous experience in linking Airtable with Google Sheets, Dropbox, and Microsoft Excel. - Understanding of how to tackle data integration issues. The ideal candidate has a solid understanding of Airtable, experience with automation workflows, data synchronization, and is comfortable integrating multiple platforms.

...amount ever given, i.e., the Highest Previous Contribution (HPC). APPLICATION OBJECTIVE The Direct Mail Segmenter (aka The Segmenter) is an application that will be used to segment the My Faith Votes (MFV) database of donors (aka House File) for direct postal mailings. Each donor will be assigned a segment code, and specific segments will be selected for a mailing (aka Campaign). APPLICATION REQUIREMENTS SEGMENTATION CODING The Application will not require a User Interface (UI) but will run autonomously on a scheduled basis, likely daily. Errors in execution of the Application such as database connection, file access errors, etc. should be reported by email to a hard coded email address. The Application is to code all donors in the table with a Segment Code. A person mig...

...Zoom screensharing only. This is long term project lasting for years. Must have good skills in Javascript, PHP, Mysql/Nosql database and API integrations. As the person in charge of this project, I am seeking a skilled PHP/Javascript developer to handle various tasks, including: - Database integration: I anticipate needing to ingest, organize, and manipulate data regularly. Therefore, you'll need strong database skills with a focus on integration points between the site and the back-end databases. - Custom coding: We anticipate some unique challenges in the development of our website that will call for custom codes. You should be a problem-solver who can think on their feet and write custom code as required. For this project, knowledge in Java...

...creating the user interface components and ensuring a responsive design. Knowledge of React.js is recommended for dynamic updates and interactive features. Backend Development: Experience with Node.js and is necessary for building the server-side logic and RESTful API endpoints to handle user requests and data manipulation. Database Management: Skills in working with MySQL for storing and retrieving trade data are essential. Understanding database schema design, querying, and optimization techniques is necessary for efficient data management. Authentication and Security: Familiarity with JSON Web Tokens (JWT) for user authentication and implementing secure authentication mechanisms to protect user data is required. Real-time Updates: Knowledge of WebSockets for...

i have a mysql query i need to add some JOIN or WHERE / AND condition i tried but not working help call first to show the issue then once i award u u will work in real time live must be done realtime live

I'm in immediate need of a skilled php mysql html5 javascript developer to finalize two forms for my php script. The purpose of these forms is for invoice information capture. Ideal Skills: - Proficiency in PHP, MySQL, HTML5, and JavaScript - Experience in form creation and data management - Quick turnaround time Please note, as this is urgent, I need the project completed ASAP. Looking forward to your bids.

I need someone to write app store description of my app. I will provide more details about the app. You will need to write Long Description and Short Description for the app. *******PRICE NOT NEGOTIABLE PLEASE PLEASE*******

I'm in need of an expert who can assist me in replicating my entire SQL database. This task is primarily aimed at data distribution between 2-3servers on Different IPs Ideal Skills and Experience: - Strong experience with SQL databases - Proficient in various SQL replication methods - Previous experience with large scale data replication - Detail-oriented and capable of ensuring data accuracy - Sound knowledge of data distribution techniques Please bid if you meet these requirements and are confident you can effectively assist with this project.

Fair Playfields is a web-based sports match management system designed to streamline the organization and coordination of sports events, like football. The platform aims to provide a user-friendly interface for players, organizers, and administrators to ma...resolving queries. Performance Tracking: Develop a performance tracking system to record player statistics, match results, and personal ratings. Allow players to view their performance history and compare their stats with other players. Technology Stack: Backend: PHP (Laravel framework preferred) Frontend: HTML, CSS, JavaScript (with a modern frontend framework such as React or Vue.js) Database: MySQL Authentication: JSON Web Tokens (JWT) or OAuth for secure user authentication Version Control: Git for code management ...

I'm in need of a SQL expert who can assist with some tasks on my MySQL database management system. The exact tasks are still being finalized, but it is essential that you have a wide range of skills and expertise in the field. Here's a potential list of tasks you might be working on: - Query optimization - Database design - Data migration Ideal Skills: - Extensive understanding of SQL and MySQL - Previous experience with query optimization, database design, and data migration - Strong problem-solving ability When applying, please ensure you include details of your past work. I'm keen to see examples of SQL tasks you've successfully completed, specifically in MySQL. Please be as comprehensive as you can be in your applicati...

Does anyone have a license for Stellar Repair for MySQL (Version 8+). I need you to recover a DB for one time use. Please start with "stellar" to be considered

I need an individual proficient in Linux-based Python and Selenium for a data mining project of moderate complexity. The task at hand is scraping websites and databases, require someone capable of designing meticulous, effective data extraction mechanisms. Ideal Skills & Experience: * Proficiency in Linux, Python, and Selenium. * Proven track record in web and database scraping. * Ability to handle tasks of moderate complexity. Freelancer Application: Please include your experience with similar projects. Demonstrate instances where you’ve employed Python and Selenium for data mining tasks, particularly with websites and databases. Highlight any challenges you met and how you overcame them. We have a code prepared that has to be tweeked for new website.

I am seeking an experienced HTML5 (or REACT) and JavaScript developer to create a user registration, login (with change and forget password) system and one special form for my project. It should be simple, clean, and user-friendly. Your respons...clean, and user-friendly. Your responsibilities will include: - Creating a user registration and login interface. - Implementing change and retrieve password functionalities. - Designing a special form with moderate complexity, including validation and rules. - Designing MySQL database structure - APIs to communicate between UI and MySQL database The ideal freelancer for this project should have extensive experience in: - HTML and JavaScript programming. - Developing user-focused interface designs. - MySQL...

I have a similar project that I could use your help on. We need to sync QBO customer records into MySQL. Is that something you'd be interested in helping with as well?

I own a Python script that I want to transf...Python script that I want to transform into a SaaS-based web application. I am seeking a Django developer with experience in user authentication, authorization, and MySQL database integration. The finalized application should offer these capabilities: - User Authentication & Authorization: The platform needs to include secure access for both admin and subscriber roles. Admin users should have higher privileges compared to subscriber users. - Database Integration: The application should be integrated with a MySQL database to manage and store user data. The ideal freelancer should have a solid understanding of Python, Django, MySQL, and user access control mechanisms. Experience in creating SaaS ap...

I'm on a search for an expert freelancer capable in data scraping, particularly from an Excel database to LinkedIn. Outlined below are the significant requirements for this project: - Source data extraction: Skillfully extract Names, Email Addresses, Job Titles, and LinkedIn URLs from an Excel database. - Detailed profiling: Leverage both extracted data and set criteria including Location, Industry, and Experience Level, to find the relevant LinkedIn profiles. - Volume handling: There are over 500 entries in the database that need to be processed, hence experience in handling large volumes of data is necessary. The ideal freelancer for this job should have experience in data scraping, Excel, and LinkedIn search. They should also have a knack for detail, be pro...

...construct a database to manage a diverse set of data, potentially including but not limited to customer information, inventory management and sales tracking. The freelancer would ideally have experience in design and ER diagram, to ensure a smooth flow of data and efficient retrieval process. Key Job Requirements: - Proven experience in the designing and implementing of a comprehensive database - Knowledge of dyanmiq or mongoDB - The ability to produce detailed project proposals When applying, please provide a detailed project proposal including an overview of the project, your proposed approach to the project, timeframe and budget estimates. I am looking for an innovative thinker with a problem-solving approach, excellent communication skills, and a strong track recor...

...projects. Knowledgeable in database design, cloud services, and implementing secure, scalable solutions. Must have previously worked on freelancer marketplace, e-learning or similar platforms. Key Task Include: - Frontend function is to be as much as close to fiverr. - Backend Development: My current script requires a variety of customizations. - Customizing Design: I desire a more unique look that separates my marketplace from others. - Enhancing User Profiles: Users should have more detailed, functional profile spaces. Web: Seller: Admin: Ideal freelancer should have knowledge and experience in advanced search functionality techniques and user authentication systems, full stack developer, PHP, mysql, backend php, laravel

..."Cannot establish database connection" issue on my AWS EC2 Linux based Wordpress site and I need your expertise to solve it. There have been no recent changes to my EC2 instance's settings or WordPress plugins, and the database credentials in my WordPress configuration file have been checked and verified. Error is Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /opt/bitnami/apps/wordpress/htdocs/wp-includes/ on line 1987 No such file or directory Ideal Candidate should: - Possess knowledge and experience working with AWS EC2 Linux Instances and SQL databases. - Be well-versed in troubleshooting Wordpress database connection errors. - Be detail-oriented, reliable, and efficient. Your job is to diagnose the problems leadin...

...proficient in HTML/CSS/JavaScript, PHP/Python/Ruby, MySQL/PostgreSQL/MongoDB. It's a feat if you've dabbled in the realms of DevOps Engineering and API Development. Create a secured, scalable and user-friendly Pentesting platform where users can register, authenticate, and scan their websites for active/live IP, website, hostname, server, workstation or laptop. The platform will interact with OpenVAS for scanning and then filter and present the reports in an accessible manner within the user's account. The scanning operations are managed through a RESTful API hosted on a VM. Ideal Skills: - Expertise in HTML/CSS/JavaScript - Proficiency in backend languages such as PHP, Python, Ruby - Familiarity with database technologies like MySQL, PostgreSQL, ...

Thank you for looking into my project. I'm in urgent need of an expert PHP and SQL Developer who can assist me with my PHP code file. You...I'm in urgent need of an expert PHP and SQL Developer who can assist me with my PHP code file. Your primary task would be: - Extract the UPDATE queries from my existing PHP code file. Create the sql quart form the pho file. The freelancer I am looking for ideally has: - A strong background in PHP and SQL - Extensive experience extracting and optimizing SQL queries - A deep understanding of MySQL databases Please submit your proposal detailing your experience with the tasks listed above and how you plan to accomplish it. Your ability to communicate clearly and effectively will play a factor in who gets awarded this job. Looking f...

I need an expert who's able to decrypt an old .accdb MS Access database for which the encryption key was lost. The database contains precious client information and business transaction data that I want to incorporate into our current database. Here are more specifics of the task: • Database Conversion: The old database structure and relationships are somewhat important, so would ideally be maintained during the conversion process. However, some changes can be considered if necessary for integration. • Data Integration: Both client information and business transaction data from the old database should be incorporated into the current one. As a preference, if the data can comfortably fit, have it provided in an Excel spreadsheet. ...

...transportation reality. Both reports should include data about the Monthly fee collection. The successful freelancer will ensure that this information is accurately recorded and retrievable in a breeze. I require this project's completion ASAP, so a demonstrated ability to deliver on tight schedules will be a major advantage. The ideal freelancer should have significant experience with PHP, MySQL, and particularly the CodeIgniter framework. Please place your bid only if you think you can flawlessly handle this project's requirements. I look forward to reviewing your proposal....

I am looking to build a basic level RDF graph database that will primarily handle numerical data. This means the project will require the establishment of few relationships and entities. Key tasks: - Designing the structure for the RDF graph database - Implementing the basic level graph with less entities and few relationships - Setting up the database to effectively manage and process numerical data Ideal Skills and Experience: - Strong understanding and experience of RDF graph databases - Proficiency in Python for application - Ability to handle numerical data efficiently - Experience in developing basic level graph databases with few relations and less entities Those bidding should have a good work ethic and excellent communication skills, as I value updates and ...

I'm in search of a seasoned Laravel/Vue Developer for a custom application project. This project requires both full time and part-time developers, and specifically those with a minimum of three years experience. Key Responsibilities and Experience: - Expertise in Laravel, Vue3, MySql, MariaDB, Linux - Capability to implement user authentication - Experience with payment gateway integration - Ability to implement real-time chat functionality - Proficiency in working with MariaDB The developers should be able to leverage these skills and others necessary to create a custom application. Only individuals with proven track records in meeting these specifications should apply. I look forward to seeing your proposals and discussing the project further. Please provide your quote, 1)...

Working as an Software Development Intern at Simplyphi. skills used: mysql, xml, .net, c#

I am in need of a talented developer who can design and build a RESTful API with a focus on several specific functionalities. As the ideal candidate, you are skilled in multiple programming languages (Python, Java, JavaScript) and databases (MySQL, PostgreSQL, MongoDB), in order to deliver the best fitting solution to our needs. The central features that the API should possess include: - User authentication: An integral feature to ensure only verified users gain access - Data encryption: To secure the data and safeguard privacy - File upload/download: This functionality will aid in seamless data transition The idea of the job is to create an interface with our internal système to the format data in a simple an easy to understand format for the web. To do so we ex...

Specifically, this project will involve: - Designing and implementing highly performant APIs in Node.js - Utilizing MongoDB to store and retrieve data - Ensuring secure and reliable connections between the server and the client Ideal Freelancer Skills and Experience: - Significant experience in API development - Extensive knowledge of Node.js and MongoDB - Proven track record in developing secure, reliable, and efficient systems - Good understanding of software architecture and design principles Please note, this project is not merely about getting the job done. It is crucial that the implemented solution is optimized, maintainable, and robust. Therefore, a clear demonstration of your expertise in Node.js API development and MongoDB will naturally make your bid stand out.

I have a SWIFTUI file created in Xcode. The purpose of the file is to click on an annotation displayed on the map (already done), and then when clicking on the info, a detailed view appears (already done also). This works. The problem i'm having is that it seems like it works for ONE (1) annotation, but not the others. And sometimes picks up random data. Looks like the declaration isn't made in the right place, but cannot find out where. Essentially i would need the detailed view, to be a UIView opening a URL with the variable (ie : location name) passed to the link. I have attached the JSON file and the Swift file as well. Thanks

Required skilled developer who specializes in payment gateway integration. Our tech stack is pHP, CI and MySQL - Implement Braintree Drop-In formobile app and website to accept online payments - Safeguard the site access to ensure users' financial information are securely transacted - Design an intuitive and user-friendly process Time is of essence and require this to be designed and completed within 3 day of award with testing to follow and bug-fixing. You will design and submit each of the 3 scenarios and testing will start for each use case as its completed.

As an avid reader of technical blogs, I'm looking for a skilled writer to construct an informative and comprehensible step-by-step tutorial on how to use our Python-based command line tool. This blog post should doubly serve as a practical user guide. Here's what I envision you covering in the blog post: • The initial setup and installation of the tool - Give precise instructions on how to get the tool up and running, ensuring that even beginners can follow. • Common uses and functionalities - Unravel the multiple ways to use our tool. I am particularly interested in the following features: - User authentication and authorization: Break down how to securely authenticate and authorize users via our tool. - File manipulation and processing: Explain the func...

I need a program which when I receive a new email, will scan for a word after a colon, copy this word and paste and enter on another specific portion of my screen instantly. (the coordinates of the screen portion will stay constant). Specific portion is a search bar in one of the program. So that should paste the word in the search bar, and clicks enter. In that time when the email comes in, it should work instantly. And that time, I might be doing other tasks in my computer too. Also I am using outlook for receiving emails. Ping me with a plan if you can do this.

## Automated / copy - paste bids will...## Open for freelancers from INDIA only ## Fullstack MERN Developer Mid-Level (5-7 years) Requirements:  Experience with front-end code in HTML5, CSS3, JavaScript, ReactJS or similar.  Experience in frameworks such as , NestJS, or proven ability to learn on the job.  Exposure to collaboration tools like GitHub, JIRA, Confluence.  Understanding of Sql and NoSql Databases i.e., MySQL, Mongo DB etc.  Proven track record of building scalable, high-quality software solutions.  Experience of working at a product-oriented company.  Thorough understanding of agile software development methodology, and ability of proactively manage task, projects and issues.  Experience with Elasticsearch, Redis, Memcached will be a plus

...FluentNHibernate MySql Server WCF Services GItHUB for source control Azure hosting on dedicated server. The website consists of a client accessible website for sales, support and information. Also a backend admin section where customer accounts are Services are also used for secure communication with Windows Client Software. We require an experienced full stack developer with experience in the above technologies to - Upgrade the various components in the projects from NuGet to the more recent versions of the frameworks e.g. .Net, Nhibernate, etc etc - Upgrade to MySQL 8 - Set up a working Development Server on Microsoft Azure with Visual Studio, IIS Web Server, MySQL Database and required configurations - Set up a working Test Server on Microsoft Azure w...

I am looking for an experienced Full Stack developer who can create an e-commerce like site based on Node.js backend and React.js frontend with database as MySQL (I am ok with Laravel backend but if you can commit website speed) with all standard security features and with some custom features. Specifically, the custom feature I want is a customized "add to cart" feature that allows multiple users to buy together for a group deal. Key features you will need to implement include but are not limited to: - Need Mobile phone and website both views. - SEO friendly URLs - Easy One page checkout process - User and Vendors login using a phone number and OTP - Payment gateway integration - Admin dashboard --( Full privilege) - Supervisor dashboard --( Limited privi...

...framework, such as Laravel, Django, or Ruby on Rails, to create the backend of your website and handle the logic, data, and security. You will also need to choose a database, such as MySQL, PostgreSQL, or MongoDB, to store and manage your data. • A web design framework, such as Bootstrap, Tailwind, or Materialize, to create the frontend of your website and handle the layout, style, and interactivity. You will also need to use HTML, CSS, and JavaScript to create the web pages and elements. • A data integration platform, such as Hevo Data, , or Zapier, to connect and sync data from various sources and load it to your database or the destination of your choice. You will also need to use APIs, such as Google Analytics API, Facebook Ads API, or Google Sheet...

I'm currently seeking a technical leader with a diverse set of skills that include web development, mobile app development, and database management. The main goal of this project is to manage and optimize a MySQL database. Your tasks will include but are not limited to: - Optimize MySQL database to improve efficiency and speed - Develop and troubleshoot mobile apps - Craft beautiful and responsive web interfaces Ideal candidates are those with extensive experience in: * Web and mobile app development, particularly in fluid, responsive designs * MySQL database management and optimization * Interest in leading technical projects. This role requires a self-starter who can collaborate with my team, manage projects independently, and ...

...experiencing some issues. I'm faced with a persistent database connection error that I can't troubleshoot. Without recent updates or modifications to stimulate this problem, I'm at a loss. Some details concerning the project: * The error revolves around the database connection * I have not checked my database credentials in my WordPress configuration file * So far, no recently updated plugins, WordPress updates or modifications to the MySQL database seem to have caused the issue * I'm seeking someone with extensive knowledge of AWS, Wordpress and MySQL to solve this The ideal candidate for this project would have: * Proven experience in troubleshooting and resolving database connection errors * Extensive expertise in...

Quick Job to organizer 25 data entries Name Title Location Research Focus Contact Email

We are looking to hire a self-motivated and disciplined Freelancer. Freelancers are required to complete assignments that meet prescribed specifications. In this position, you will also be required to keep a record of hours worked, and to submit your tax returns on time. To ensure success as a freelancer, you should possess excellent organizational, time management, and communication skills. Ultimately, a top-notch Freelancer will be able to complete assignments with minimal supervision.

I'm currently dealing with a PHP and MySQL errors in 2 different files that urgently needs to be resolved. - In the first file, I get the following error message: Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 8192 bytes) in ........ on line 71 - In the second file, i get a timeout error message sometimes, but not always. The content takes very long to load though. The problem requires an experienced PHP developer with strong diagnostic skills, who is not averse to confronting an undefined problem. As the issue and error message arising from running the PHP code are uncertain, applicants should be: - Highly proficient in dissecting PHP errors and MySQL queries - Capable of troubleshooting and fixing a range of PHP errors, such as Pa...

I'm seeking a highly skilled database administrator to perform a significant Oracle to MySQL database migration. My existing database is extensive, well above 10GB, and encompasses structural components including schemas, data, stored procedures and triggers. Key elements of the project include: 1. Migrating Schema/Data: Careful movement of all schema definitions and data is essential to ensuring seamless transition without loss. 2. Transferring Stored Procedures: Stored procedures currently in place within the Oracle database will need to be assessed and recreated effectively in the MySQL environment. 3. Triggers Implementation: All triggers in use within your Oracle setup will also require migration. While the size of this project is...

I need a serious PHP developer to do some work on my SMF 2.0(.17) Forum Software. The URL of the website is If you are not familiar with SMF you can find an unaltered Stock Version to download here: ;filename= But please note: MY SITE IS HEAVILY CUSTOMIZED. That is why I need a seasoned PHP developer. I do not wish to waste your time nor do I wish you to waste mine. Therefore: 1. This project is for expirienced PHP developers only! This software is written in PLAIN PHP. NO FRAMEWORK! If you are a WordPress, Magento etc. developer then this is most likely NOT your cup of tea, you have no clue of how a message board / forum works then this is not your project. 3. No coders from India please. My expirience with Indian coders was bad 99% the time and I am not on a trip to look for th...

I need display to my database the ACF Repetater fields that i create. It is a accordion.

...can develop a Client Management System (CMS) website using WordPress. This website is not just about being visually appealing, it also needs to cater to my specific business needs. This website should have a database where the following information on my clients can be stored: - Contact details - Purchase history - Client preferences The primary goal here is to have a system that allows for easy tracking and access of my client's information all from one platform. Ideal Skills: - Advanced knowledge in WordPress development - Proven experience in CMS development - Experience in database creation and management - An understanding of UI/UX principles - Ability to deliver in a timely manner Essentially, I am looking for a quick turnaround on this project without com...

I require an experienced MySQL expert to help with data recovery. My database, which primarily held transactional data, has become corrupted, and unfortunately, I don't have a backup. Specific requirements are: • Expertise in MySQL data recovery, especially with transactional databases. • Demonstrated experience handling corrupted databases. • Must possess solid problem-solving skills to determine the source and extent of the corruption. • Ability to take immediate action is essential as the data is quite critical. Please note that this is an urgent request so the ideal candidate should be ready to start immediately and provide regular updates.

...candidate should have a minimum of 8 years of hands-on experience in JavaScript and a strong proficiency in the following technologies: NWJS, NodeJS (backend) JS, TypeScript, HTML, CSS, JQuery, MYSQL, WordPress, and AWS. The candidate should possess excellent communication skills, both written and verbal, and be capable of working with minimal supervision. Responsibilities: -- Develop and maintain robust and scalable SaaS and desktop applications using NWJS, NodeJS, JavaScript, TypeScript, HTML, CSS, and JQuery. -- Ensure the technical feasibility of UI/UX designs and implement them accordingly. -- Work with MYSQL databases to handle data storage, retrieval, and manipulation. -- Utilize AWS services for deploying and maintaining applications in the cloud. -- Manage and e...

...Asset management and tracking Description: We are seeking an experienced developer with a proven track record to create ERP, CRM, and Asset Management software. This project requires expertise in database management, user interface design, and system integration. The ideal candidate will have prior experience in developing similar solutions and a portfolio showcasing their work. Requirements: Proven experience in developing ERP, CRM, and/or Asset Management software. Proficiency in relevant programming languages (e.g., Java, Python, C#). Strong understanding of database management systems (e.g., MySQL, MongoDB). Ability to design intuitive user interfaces. Experience with system integration and API development. Excellent communication skills and ability to work c...

Project Overview High quality web scraping script required to scrape data and images off specific webpages & store data of each listing & new listings in our existing MySQL DB. The script essentially monitors for new listings on various pages & scrapes this data. Then we also need 2 simple API endpoints that output data from the table in simple application/json format.