Sql mysqlPekerjaan

This is a simple, small job. I have a MySQL database that runs a schedule. The schedule works from the recurrence column, with seven numbers (0 or 1). These numbers represent the days of the week (Monday to Sunday). 1s will trigger an event, 0s will not. For example, if the recurrence column has 1000000, the task will only trigger on a Monday. 1100100 will trigger on Mondays, Tuesdays and Fridays There are also fields for start date and end dates. I would like to view on a website what events in the schedule are coming up next. The events in the schedule also have a start and end date. I would also like to be able to add / edit information through the website. Uploaded SQL code. Example table Recurrence Startdate Enddate Descrption 1000000...

There are issues with the automated update of Personal User data in our MySQL database. The ideal candidate for this job is one who: 1. Has outstanding proficiency in MySQL and database management. 2. Has competencies in managing and rectifying update issues, especially within automated systems. 3. Understands data entries associated with user's personal details. In this task, you'll be tasked to diagnose and fix the problem to ensure accurate and prompt updating of data. Past experience dealing with similar issues will be an added advantage.

...Familiarity or experience with Avalara Tax API would be beneficial. • Meticulous attention to detail. Unfortunately the previous freelancer was not well fit for this type of project and was not able to properly transmit the data from the POS to avalara as he did not have the proper understanding of POS systems and invoicing. There are multiple ways of approaching this project as I have access to the SQL database, and the API endpoints along with the API documentation....

I am on the hunt for an expert full-stack developer/network admin with good communication skills and who enjoys teaching others, to provide me step-by-step walk-through tutorials for various aspects of network admin and coding tasks that I need to get done for my own personal projects. To put it simply, I'm an amateur network admin/web dev with a lot of "surface-leve...in explaining complex information in easy-to-understand language is a must, as the end goal is to enhance my foundational and advanced skills in network administration and coding. Looking forward to your proposals! Below is a list of the tech stack I'm currently working with: Web Management: ISPmanager, cPanel, CyberPanel SaaS Platform: Laravel, PHP, WordPress, Javascript, HTML, CSS Databases: MySQL ...

...datos sean recogidos en power query ( aqui pido recomendacion si es mejor otra herramienta), después sean limpiados ( no se aqui si con dax )y unidos a través de python o power query si es necesario y traspasar los datos a power bi . La idea no es que tu hagas todo esto , sino que me tutorices y guies dándome clases . Necesito especializarme en todas estas herramientas ( Power Query , Power BI, SQL, data cleaning python) y terminar mi proyecto Pagaría por hora de clase que nos vinieran bien a ambos claro y ES IMPRESCINDIBLE que sea alguien que hable español porfa . Mil graciiias...

...be able to RSVP. - Chat: Those who use the app should be able to exchange messages with one another. - Toolbox and Rent: More specific details will follow regarding the functionalities these sections should possess. - Push Notifications and Ads: Incorporate support for push notifications and advertisements. - SQL Integration: The application should integrate with our SQL database for smooth data exchange. Ideal Expertise: - Experience developing iOS and Android apps. - Knowledge of SQL and how to integrate it into mobile applications. - Experience building a web interface that syncs with a mobile application. - Graphic design experience for logo and splash screen implementation. - App developers with a background in ad integration and capability to enable push no...

Please see the attached screenshot. I have a stack of sortable <div>s which are pulled from a MySQL database. They are ordered from 1, 2, 3 onwards based on the ID number in the database. I would like to make it so that when you drag and drop the <div>, it updates the MySQL database with the new orders of the <div>s. This is basically a quick jQuery function with Ajax. Opportunities for further projects if well suited.

I need an experienced MySQL developer to upgrade my website's database from MySQL 5.7 to MySQL 8.0. The database is relatively small, less than 1GB. Currently, when we move the site from a server running MySQL 5.7 to a server with MySQL 8.0, the site no longer loads the items from the database. Ideal Skills: - Strong MySQL experience, particularly with versions 5.7 and 8.0 - While I'm not currently interested in any specific features of MySQL 8.0, the new version must be fully functional, and all website features should perform as expected after the upgrade.

HI i have my backend admin called STORE MANAGER Once a STORE MANAGER logs in their STORES_ID is registered and the data and options on the screen will be connected to the STORES_ID i need all the mysql queries and joins updated to include the STORES_ID so only the correct data shows currently all data is showing i also need certain links and navigation links removed or hidden from sidebar when stores_id > 0. NO TIME WASTER ONGOING WORK FOR RIGHT CANDIDATE WILL NEED TO SPEAK TO ME ON A CALL AND VIDEO CONFERENCE SO I CAN SHOW U THE SYSTEM

I'm looking for a seasoned PHP developer to help edit my codes i have one session variable called STORES_ID which i need to make sure is being registered on login. because then this STORES_ID will be used in different mysql queries on different pages. im not even sure if its getting calles or registered and i tried to echo it but running into problems with syntax or output PLEASE HELP ME SOLVE THIS We need to make sure STORES_ID or $manager_stores_id is being passed when the user has successfully logged in if it has value 0 then this is the MASTER ADMIN or SUPER ADMIN (all privileges) if it has value > 0 e.g 1 then this is a STORE MANAGER stores_id and so they wont have access to all data. HELP!!!! U CAN SOLVE IN REAL TIME ON MY SCREEN NO TIME WASTERS

I need 1 professionel user for Sap Business and I can start use SAP. We have 6.000 types stock and we want transfer to SAP with excel

Can I ask you also fro Ubuntu-mysql-apache-SNMP-zabbix6.0 combination on WSL2 also?

Aigentless is a prop tech startup hoping to revolutionize the rental leasing pro...technical documentation * Test software to ensure functionality and efficiency * Use SDK to build functional mobile app for touring interface Key requirements: * Mastery of frontend languages and libraries (e.g., HTML/CSS, JavaScript) * Mastery of backend languages and libraries (Python strongly preferred) and JavaScript frameworks (e.g., React, Node.js) * Mastery of databases (e.g., MongoDB, MySQL) Timeline: * 4-6 weeks to develop a minimum viable product (“MVP”) that can be demonstrated to early adopters (we already have a pipeline of property managers who are willing to test out our software). * We will detail the specific features/functionality required for the MVP if there i...

...am experiencing an unauthorized error in Power BI Pro. Specifically, a 401 error presents itself when trying to retrieve the Embed URL. The environment we use is a hybrid, suggesting that the problem could stem from multiple sources. Our current data sources are SQL Server and various cloud services. The ideal candidate for this assignment should: - Have excellent knowledge of Power BI Pro, its use in a hybrid environment and experience with troubleshooting authorization errors. - Possess strong technical insight into SQL Server and cloud services. - Provide a clear and concise resolution to the error, and possibly be prepared to respond to any related issues that could arise after the execution. Overall, the project's main objective is to rectify the 401 e...

I'm looking for an expert in PHP and MySQL to create a detailed audit trail. This trail needs to capture changes for both text and numeric fields. Purpose is to record the old data and new data for each modification. Key features: - Ability to view a detailed history of all changes - Implementing user identification tracking for each field Your experience with similar projects will be crucial for the success of this task. Good understanding of data privacy and security is needed. If you're precise and detail-oriented, please bid here.

I'm in need of a SQL expert to help import my CSV files into any SQL program. Once the files have been uploaded, the task will involve deleting all duplicated data. Since the format of the CSV files is unknown, the ability to work with different possible formats, such as comma-separated, tab-separated, or space-separated values, will be beneficial. After this process, the final data will be reviewed with Python for testing purposes. Ideal candidate for this job: - Has previous experience with SQL and file conversion - Understands data cleaning: particularly in removing duplicate entries - Possesses basic Python skills for testing purposes pls don't apply if you don't have previous experience in similar projects

As the client, I need assistance in creating a PHP website. However, I have not yet specified the required features, the information freelancers should include in their application, or the website's intended purpose. Key Requirements: - Familiarity with PHP and MySQL - Versatility in dealing with various website types and functionalities, as the specifics are currently undecided - Eagerness to adapt to new requests and changes Ideal Application: Freelancers interested in this project should lay out their experience and past work, particularly in PHP. Please submit a detailed proposal for the project, even though the requirements are currently vague, I am open to suggestions.

Silakan Daftar atau Login tuntuk melihat rincian.

...fields to assist us in handling our expansive course catalog. We offer a wide array of IT courses from Web and App Development, SEO, Digital Marketing, to Graphic Designing, AI, Machine Learning, Basic Computer literacy, Advanced Excel, and languages such as Java, Python, SQL, AWS, and more. Our goal extends beyond providing these courses. We're also involved in website and app development, digital marketing and graphic design services, implementation of AI and Machine Learning solutions, and development of Java, Python, SQL, AWS applications. Our target audience is broad, as our services cater to students, professionals, small to large businesses, individuals who seek personal development, across non-profit organizations, government organizations and everything in b...

...components: 1) Mobile App development (Android and iPhone packages): using Flutter language. 2) Backend development: using JavaScript or Python. The backend should be built as a microservice architecture to be able to handle thousands of requests per minute with ability to scale up and down and ability to have multiple databases read instance. For data storage we need your recommendation to use SQL or/and no-SQL data storage. 3) Web Console Development (Salon Console and Central Console): using HTML5/CSS/JavaScript (NodeJS) 4) Simple Website to present our service to the public: using HTML5/CSS/JavaScript (NodeJS) The design already made for all the components; PDF-exported Figma design is already shared here: :f:/g/personal/hmohammad_microbeaver_com/EsSZ

Hi, I have read your requirements, I will definitely help you in configurations and setting up the Project as per your requirements. If you can give opportunity then I will do this job for y...aspects. I have experience in cloud hosting like AWS, Azure ,Digital ocean Linode and google hosting. I have expertise in migrating website or applications from one server to another with the lowest possible downtime.I have set up and maintained clusters of DNS server, web servers using Apache / Nginx controlled by a load balancer, Database server configurations and migrations of MySQL, PostgreSQL, Mongo DB, etc. I am always interested in new projects and look forward to discussing how we can work together. I can provide industry reference if needed. ...

I need an expert C# and Powershell programmer to create a utility that transfers Terminal Server Session Logs to a MS SQL database. Data to be moved to SQL Server : - EventRecordID - Date and Time - Guid - User - EventID - Computer - SessionID / Target SessionID - Address - Source Session ID Event Ids RemoteDesktopService - SessionServices - Operational : 21, 23, 24, 25, 39 Last EventRecordID to be stored in Registry or anywhere else so next time fetch data greater then last stored EventRecordID SQL Server 3 Tables need to be updated 1. Rawlogs (above mentioned dump of Logs) 2. LoginandLogout (GUID, Date, User Name, Login Time, Logout Time, Logon Time, Computer, Address, Reason, Status (Approval Pending/Approved)) for each event 3. Total (Date, User Name, ...

...a second-hand item website to life, with a built-in SQL database. Key Features: - A secure login and authentication system based on email and password. The chosen developer should have experience in creating secure systems to prevent unauthorized access. - A second-hand item listing and viewing system. Every item listing should include details like price, a clear description, and the seller's information. As such, a skillful grasp on user interface and experience is crucial. - An intelligent search and filter system that includes keyword search and category filter features. Having prior experience in creating such search mechanisms would be a significant advantage. In summary, I need a freelancer who's adept in website development, SQL databases, has a keen ey...

This document outlines the detailed requirements for the development of a healthcare software solution targeting the Indian market. The proposed software aims to provide teleconsultation, video consultation, appointment booking, Electronic Health Records (EHR), live chat, provider profiles, and patient health history functionalities. The project will be developed using React, Nodejs, MySQL, and will be hosted on AWS. 2. Project Objectives: The primary objectives of the project are as follows: Create a user-friendly platform for patients and healthcare providers. Facilitate seamless teleconsultations and video consultations. Implement an intuitive appointment booking system. Develop a secure EHR platform for efficient health record management. Enable real-time communication throug...

I'm in immediate need of a MySQL expert to assist me with a query. Skills: - Expertise in MySQL - Strong problem-solving skills Only for avaialble freelancers now.

We are looking for an Informatica BDM developer with 7+ yrs of experience, who can support us for 8 hours in a day from Mon - Friday. Title : Informatica BDM Developer Experience : 5 + Yrs 100%Remote Contract : Long term Timings: 10:30 am - 07:30 pm IST Required Skills: Informatica Data Engineering, DIS and MAS • Databricks, Hadoop • Relational SQL and NoSQL databases, including some of the following: Azure Synapse/SQL DW and SQL Database, SQL Server and Oracle • Core cloud services from at least one of the major providers in the market (Azure, AWS, Google) • Agile Methodologies, such as SCRUM • Task tracking tools, such as TFS and JIRA

...with the specific tasks of bug fixing and feature implementation. Here’s what's expected: - Diagnose and troubleshoot bugs throughout the application - Implement new features as per given requirements - Optimize application for maximum speed and scalability - Collaborate with the team to ensure consistent project progression Ideal skills: - Proficient understanding of TypeScript, Node.js, MS SQL, preferably with knowledge in trading and understanding of some basic technical analysis will be added advantage. - Previous experience in bug fixing and feature implementation - Ability to determine causes of operating errors and deciding what to do about it - Strong problem solving and critical thinking skills - able to work via remote anydesk or ultraviewer for entire pro...

Do not write your response using AI or ChatGPT I can not wast my time in reading fancy content. I require an experienced developer with expertise in PHP, JavaScript, and MySQL. working on my project for long term basis, ideal candidate should work delicately on my project for 4 to 6 months and deliver on time. Moonlighting candidates please excuse and Only individual freelancer contact me. The ideal freelancer should learn our existing CMS system and debug existing skills faster and deliver at good velocity and have proven experience in code performance optimization. PHP, JavaScript, and MySQL proficiency is a must. For the right candidate this could become longterm project .

Come do some interesting GIS programing. *** Please no AI responses. *** Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programmin...

We need a new API that will efficiently request and retrieve customer data from our MySQL database. The API development should be done using PHP. API should contain 2 query parameters: data_serie device_serial It should return a value. Quite simple, as it could reuse some code.

...the goal of improving accessibility. Key tasks include: - Refactoring and retaining all current MS Access functionalities, including data entry, reporting, and existing VBA codes - Ensuring the transition to the web app seamlessly retains the functionality and usability of the current system Please note, real-time data synchronization with the original MS Access project will not be required (mysql or alternative option for online data) Key Skills: - Proficiency in MS Access, VBA, and coding for web apps - Prior experience in similar migration projects - Strong communication skills, as you may need to ask for further details about some functionalities. I look forward to your bid. Important note: the database include a vba code to interact with lpsolver which is also a must...

i need editing done to the products of an ecommerce website that I need brought out. Some insights into the requirements: **Functional Improvements:** - Dialing up the capabilities of the existing data management feature in CodeIgniter. Ideal skills and experience for this project: - Deep-seated knowledge of CodeIgniter and Figma. - Extensive experience in website functionality enhancement. ...to the products of an ecommerce website that I need brought out. Some insights into the requirements: **Functional Improvements:** - Dialing up the capabilities of the existing data management feature in CodeIgniter. Ideal skills and experience for this project: - Deep-seated knowledge of CodeIgniter and Figma. - Extensive experience in website functionality enhancement. - strong skills in ...

I'm looking for a ...in Classic ASP to assist me in setting up hosting and database connection for my site. Key Responsibilities: - Help set up the hosting for the Classic ASP site. - Enable database connection and ensure its performing optimally. What I Expect from you: - Proven experience of working with Classic ASP. - Keen attention to detail. - Strong understanding of database management and setup, including SQL. - Good problem-solving skills. - Exceptional communication skills. Note: No specific functionalities or pages need to be created or handled. The sole focus of this project is on setting up hosting and database connection. Please ensure to include a detailed proposal indicating your approach to these tasks, alongside examples of past work and experiences, in yo...

I have an issue on my WordPress website where with each page load, several queries are being sent to a page that does not exist. When you delete the nav menu, this issue goes away. However, when you create the menu again, the issue returns. I need help troubleshooting this, because we obviously need a nav menu - but the constant duplicate queries to a page that doesn't exist are hurting our performance.

I need a proficient developer t...Contractor Payment: It should have an option to calculate biweekly payment, paid directly to contractor, no need an integrated system, just inform them how their payments calulated and accumulate there year to date amount for annual reporting. User Authentication: The authentication must be managed via an email and password system. Ideal Skills: - Proficiency in web-based app development - Access / MySQL data base - Experience in integrating timesheet and payment calculation - Expertise in implementing secure email/password user authentication systems - Knowledge in data management, reporting and analytics This project requires keen attention to detail, reliability, and timeliness. Previous experience in similar projects would be a significant ...

Our proyect in laravel, is a games site, whe have games now, but want add more. 1) proyect is in laravel (php 7.4 - mysql ). 2) whe have docs for api, and example request/response. Contact me whit u proposal.

...this project is to include features that handle billing and database assignment. There will be the need to implement a simple system that assigns a billing plan and a database to each company using the system. This code already exists in the current functioning ASP.Net project. Proficiency in both C# and Angular is required, alongside experience with Bootstrap 5.x, and a solid understanding of SQL Server database operations and Identity user management functionalities. The successful freelancer should have proven experience in handling similar conversion tasks and a portfolio showing completion of similar projects. This project includes converting ASP.Net controllers to WebApi controllers (ApiController) for use as endpoints by the new Angular code. All logic currently functio...

...software with a MySQL backend. The software will be incredibly simple: 1. One interface for inputting a handful of fields. After submission, all data will need to go into a MySQL database table. The data in the database will be encrypted and can only be decoded using a decryption key provided in a link. The link will then be provided to view the submission, which the user can copy (to send to someone else). 2. One interface for viewing a submission. This interface will require the decryption key or else an error message will be displayed. This page must be really well formatted -- an example will be provided. 3. On the back-end, we also need some clean-up tasks: Data stored in MySQL must be purged based on expiration dates sent during a submission. Also, data st...

As a project owner, I am facing issues with SQL Server connection in my windows server. Whenever I am trying to connect, it is showing error messages. The application's behavior leads me to believe that there is a problem with the database connection. Interestingly, I haven't tested if other applications or utilities can access this database. The application works well in development, and I can connect to a copy of the database as expected. This task will require: • Proficiency in SQL Server • Experience with windows server • Diagnostic skills relating to database connectivity issues • Ability to ensure that other applications can smoothly interact with the database The project will be considered successful when the error messages no longer ap...

I need a highly skilled PHP expert to undertake a database integration task with my Aviator Game. The game requires MySQL database inclusion and specific features. Key Duties: - Incorporate MySQL database into Aviator Game - Set up the game as needed Essential Features: - Creation of User profiles within the game - Implementation of Leaderboards system Skills and Experience Required: - Proficiency in PHP language - Extensive experience in MySQL database integration - Familiarity with custom PHP programming - Previous work on website development is a plus - Ability to incorporate new features in existing game platforms.

Project Title: Database Design (Models and DbContext) for Enterprise Inventory and Sales Management Project Overview: The project involves designing a robust .Net core models layer for an enterprise engaged in Inventory Management and Sales Management. The system ...are allocated to different branches, with variations across branches. e. At any given time, only one active batch should be available for selling items in a store. f. Calculate stock levels per item per batch per store. g. Track stock sold, stock available, and calculate profit. h. Capture and manage customer details. i. Store and manage invoice details. Technical Specifications: Utilize SQL to ensure data integrity, security, and efficient querying. Create appropriate relationships between tables for seamless ...

Project Title: Database Design for Enterprise Inventory and Sales Management Project Overview: The project involves designing a robust SQL database system for an enterprise engaged in Inventory Management and Sales Management. The system should efficiently handle inventory tracking, stock management, sales operations, and related functionalities for multiple branches. Requirements: Inventory Management: a. Items are received at a central warehouse from multiple suppliers. b. Items are received in batches, with each batch having different pricing (cost price and MRP). c. Each batch can have multiple offers based on the quantity purchased by the customer. d. Maintain and calculate stock levels for each item per batch. e. Track the in and out transactions of items with date/ti...

I'm in need of an experienced database developer who is well-versed in MySQL. My current project entails: - Reviewing and possibly redesigning our existing database Schema to streamline and optimize our operations. - Implementing strong data encryption mechanisms to fully secure our data. - Setting up reliable backup and recovery options to prevent or reduce potential data losses. - Ensuring that our database is scalable and performance optimized as our user base grows. - Fully integrating the enhanced database with our website. The perfect candidate should have solid background in MySQL database development and schema design, experience with data encryption and setting up backup and recovery systems, proficiency in optimization for better scale and performance, as wel...

...message features like Project and Task. - [ ] 2. Put Shipping Order and all new three modules into "Shipping Documents" in Freight Management, create a submenu "Documents" in Project and put Shipping Order, Booking Information and new three modules into it. - [ ] 3. Once new task is created (saved), it will update the external MySql tables (there are different tables), send the Customer name, Tacking number, Status, etc… data(value) to there creating or updating the mysql database. Also once the task is updated, like Status, it will update the database in the related record. This is for our tracking system. Users do not need to update tracking system separately. They only need to update everything in Odoo system. Similar case in National Skill Co...

I am seeking an experienced operative to swiftly enact a fix on a datatable with inline editing. This project is perfect for someone skilled in managing data tables json Ajax SQL and c#. Seeing as this project is short-term, the readiness to dive right into the issue is highly favored. Also this will be remote

I require an expert in Docker Compose to assist in the setting up of containerized applications with a keen focus on MySQL and Laravel+vue. This task will involve defining services and networks, as well as scaling the application within a container environment. Essential skills and experience required: - Comprehensive knowledge of Docker Compose - Sound understanding of MySQL - Proven experience in Laravel - Familiarity with local development environments Please note, the project will be deployed in a local development environment. By bidding on this project, you affirm your confidence in defining networks and services in Docker Compose, and efficiently scaling containers.

...sources of my interest are platforms like Spark, AWS, Azure, GCP, and Hive. I want to understand effective methods for data extraction from these particular sources. Ideal Skills and Experience: - Expertise in ETL tools for data extraction - Hands-on experience with Spark, AWS, Azure, GCP, Hive - Profound knowledge in data engineering - Experience in career coaching or mentoring will be a bonus - SQL -Python This assistance will give me a competitive edge in my upcoming interviews by providing me with practical skills, knowledge, and confidence in addressing ETL-related questions. So, a mentor with over 10 years of experience in data engineering, particularly in ETL processes and in touch with modern data extraction techniques, would be ideal....

I am in need of an expert Bug Hunter to assist me in identifying and addressing vulnerabilities in some web domain/online services for Key Areas for Exploration: - Cross-site scripting (XSS) - SQL injection - Remote code execution - OAuth redirection issues Ideal Experience and Skills: you MUST have experience and have gotten bounties in the past. I am looking for someone with ative experience. Level of Expertise: I'm specifically interested in freelancers with advanced expertise in bug hunting. I also want you to help me over zoom to achieve my first bug YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN

...am in need of a skilled PHP/MySQL/CSS developer to build a comprehensive Content Management System (CMS). Key functionalities: 1. User Registration and Login - The CMS should allow users to register and login, ensuring secure authentication and data protection. 2. Database Integration - Applicants must be proficient in MySQL as database integration is an essential part of this project. 3. Form Submission Handling - The CMS will require form handling capabilities to enable user interaction. Content Managed: 1. Text Articles - The CMS should handle the organization, storage, and retrieval of text articles. 2. Multimedia - It must also support managing various multimedia components such as images and videos. You should have extensive experience in PHP, MySQL,...

I have recently uninstalled Mariadb 5.5 from my server however, my MySQL database file still exists and have the database in /var/lib/mysql/umedia. . I need that database recovered and sql dump created as soon as possible.