Mysql sql syntaxpekerjaan

As a PHP and MySQL expert, your task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data ...

As an established business relying heavily on a comprehensive tech stack, I'm in ne...need of a seasoned .NET developer for a variety of tasks. Key responsibilities include: - Review and optimization of existing front-end, back-end, and database systems - Ongoing maintenance, troubleshooting, and improvements to enhance system performance Ideal candidates for this project should have prior experience with: - Front-end development utilizing HTML/CSS - Backend technologies such as SQL Server and Entity Framework - A strong grasp of the .NET framework This role is crucial to the successful functioning of our systems, so a proactive, detail-oriented approach and excellent problem-solving skills are must-haves. Your ability to communicate issues and improvements clearly is also ...

...Plataforma Sistema de Pujas Consideraciones Adicionales: Ya contamos con logotipo, colores, tipografia. Los pagos de los estudiantes seran cobrados en una cuenta comun por transferencia bancaria, por lo tanto no se requeire un sistema de pagos aun. Tecnologías Recomendadas: Al ser el primer proyecto que envio a cotizar no conosco de tecnologias pero si quisiera que se realize en HTML,CSS, JAVASCRIPT MySQL y PHP para el Chat interno. abierto a recomendaciones No estoy considerando el hosting y otras asuntos por lo tanto espero sugerencias. Deseo que el sistema sea inspirado en aqui comparto una grabacion breve que hize para que entiedan mejor de lo que deseo cotizar: Video demostrativo?: ?

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. The...

...clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meaningful performance insights. * Analysis reports with visualizations focused on: * Player performance over time * Our strengths and weaknesses * How we compare to top teams * Map rotation analysis with suggested changes * Final presentation summarizing key findings & action plan. **Required Skills** * Expert SQL and querying, especially Google BigQuery. * Strong analytical skills with statistics experience. * Passionate about PUBG Mobile - understand gameplay and competitive scene. * Ability to turn...

I'm in need of a detail-oriented editor and designer to polish and enhance my children's book. Key Requirements: - Proofreading and Grammar Correction: The text should be meticulously checked for errors and polished for clarity. - Formatting and Layout Design: I'm looking for someone who can enhance the book's layout, making it more engaging and appealing for young readers. The primar...readers. The primary goal of this project is to enhance the readability and coherency of the book, making it more enjoyable and impactful for its target audience. Ideal candidates for this project will have: - Prior experience with editing children's books or similar texts. - A strong eye for detail and a knack for creative design. - Excellent English skills and a keen understa...

I require a freelancer skilled in MacOS and command line operations to assist me with the installation of a Foodomaa extended license script on my localhost. The purpose of this installation is to allow for extension development. The selected freelancer must have: - Proficiency in MacOS - Fam...command line interface operations - Previous experience in handling Foodomaa scripts This task will involve installation and ensuring that the script functions as required on my MacOS localhost environment. Your responsibility will not only be limited to the installation but includes providing documentation on the process to help other team members understand any modifications made. Skill in PHP, MySQL, admin panel setup, and understanding of web server would be a bonus. Looking forward to ...

I am looking for a PERL, HTMX, MYSQL programmer who can help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML interface, based on Perl, HTML, HTMX to this table. I need to be able to search, add, edit and delete entries as well as combine two entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and ...

...several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, Node, Express, React Native Frontend: React (website), Node + Express (APIs on server), React Native (mobile apps on iOS & Android), Bootstrap (making UI web responsive) Backend: Node.js (latest version), Express, MySQL Deployment: Simple to...

READ FIRST: ONLY HOURLY CONTRACTS, no fixed rate because I have multiple bug fixes on trello and I need someone to start immedaitely. We have demo tomorrow. I want someone to work the next 8-10 hours on time tracker (no manual hours). Important, I need someone immediately

I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.

I'm seeking a professional who can help me craft a comprehensive 2000 word report on Database Management Systems (DBMS). The report needs to cover the key concepts of DBMS, including E-R Diagrams, Normalization (3NF), and crucial SQL queries. The report should be well-researched, well-structured, and free of any plagiarism. I also need a PowerPoint presentation to be created, consisting of 15 slides based on the content of the report.

I am seeking an experienced PHP and MySQL specialist to integrate the Push Notifications API of the OneSignal system into my website. Your primary role will include: - Seamless incorporation of the API to enable us to send notifications to our users. - Alerts settings that will notify our visitors of newly published articles. - Extending these notifications to the NEWS section of our site. Proficiency in PHP, MySQL, OneSignal API, and a clear understanding of push notifications systems will be fundamental for this task. Experience in seamless third-party API integrations to a website would be highly preferred.

I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.

I am in need of a CodeIgniter expert to create a ...them to be updated using the provided file names and images in the folder. Key Requirements: - Develop a CodeIgniter script that will automate the import of images - Utilize the provided file names and image folder to update broken images for products - Script should run via command line for a one-time application Ideal Skills: - Proficient in CodeIgniter framework - Strong knowledge of PHP and MySQL - Experience with image processing and automation - Comfortable with command line execution This project is a one-time task required to fix current image issues. The task should not require a user interface as it will be run via command line for this specific purpose. Your expertise in CodeIgniter and image processing will be great...

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose Scenario...

We're looking to integrate a Python script into our MySQL database to perform data analysis.: - Primary Task: The script's main responsibility will be to filter our data based on specific conditions. - Data Interactions: The script will predominantly be running operations on numerical and textual data. We're interested in candidates with a strong background in data analysis using Python and MySQL. Expertise in scripting languages, especially Python, is vital. Familiarity with MySQL is crucial as well - you should be comfortable working with numerical and text data within these databases. Efficiency, accuracy, and attention to detail are key for this task.

I require a skilled developer to address my Breakdance Builder issue urgently. Here are the specifics: - I am currently unable to retrieve specific content using the existing query to get taxonomy (Meta Box) content...content in Breakdance Builder. - I prefer the method of rewriting the query from scratch. This way, we can avoid any potential issues within the existing query and ensure the accurate retrieval of specific content. Time is of the essence for this project, so I need someone who can commit to completing it ASAP. Ideal Experience: - Proficiency in Breakdance Builder - Strong background in PHP and MySQL - Previous experience with Meta Box - The ability to work quickly and efficiently Please get in touch if you have the necessary skills and can commit to this project im...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

More details: We are making some changes to this dashboard tool : We need to make two changes in the product in above link. This is a code for dashboard tool, we just need to create two separate databases and a few UI changes to create buttons for using that database. This...process, I propose adding a tab or checkbox in our Point of Sale (POS) system when selling the product, prompting the staff to confirm whether the empty cylinder has been received. If yes, it should update the Empty Cylinder stock; if no, it should not. Database management, Creating Two New database and a button in a dashboard., Need someone Who understand complex Backend Architecture in php & Mysql.

We are in the initial stages of launching an exciting e-commerce project aimed at enhance the online shopping experience. Technical Aspects of the Project: - Development of a browser...development with JavaScript, HTML, CSS, and modern frameworks (React, Angular, Vue.js). - Proficiency in backend programming, particularly with Node.js or Python. - Strong understanding of RESTful API design and development. - Experience working with cloud services (AWS, Azure, Google Cloud). - Skills in data analysis and machine learning are a plus. - Proficiency in database management, especially SQL and NoSQL databases. If you are passionate about technical innovation and want to be part of a team striving to change e-commerce, please announce your interest and state previous experience wihtin ...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks ...Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task for 1 Hour, If you Completed ON TIME means we will give you the Project. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

Immediate need for a developer who can assist internal team complete short assignments of LMS (Learning Management System) development. Should be competent in jQuery and Laravel for a project built on MySQL database.

...custom button rather than the native link of the accordion. If I post an offer for a hotel, that offer should only be visible for that specific hotel. However, at the moment, it is shown in all hotels, even though I select the hotel to associate these offers with from a select box in the control panel during the posting phase. This involves creating custom queries for WordPress. I usually use PHP/MySQL, but for this new version of the site, I am using WordPress. The total budget is 15 USD it's not a demanding job for an expert. I am attaching images to clarify what I am talking about. You can see button "dettagli offerta" and i want to use this for open and close the accordion where there are offers details This offer are for 1 hotel, but the same offers now sho...

...Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projects is a definite ...

...6 shop, we are facing a problem with the importing process of pictures submitted via XML; the image files are also hosted on the same server. The current script only imports a few images at random, and most of the images are not imported at all, without generating any errors. The import script runs until the end but skips most of the pictures. Skill requirements: good knowledge of Shopware 6, mySQL, PHP, Smyfony !!! it's an urgent project so pls. don't bid if you haven't got enough time (max. 2 days). If you have questions pls. don't hesitate to ask, i'll provide all the infos u need. !!! IMPORTANT !!! Please don't give a quote if you don't have enough capacity, the project should begin immediately. Please don't give a quote if you'...

I have purchased a VPS from hostinger. Now, It supports Linux. I am looking for a proficient Linux expert who can assist me with installing software packages on my VPS. I want to install PhpMyAdmin, MySQL, Laravel, Email Server, DB Performance Tools and Server Performance Tools, React, others. Key requirements: - Proficient in Linux system administration - Experienced in VPS management - Capable of installing software packages effectively Project will be considered as complete only once it is working fine. You need to perform it on our machine as we will share our screen with you as we need to document all steps. Kindly mention your bid and time required while biding. Also, mention which Linux Version is preferable as per your expereince.

I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.

Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this project....

whell... i have a laravel dashboard, PHP 7.4 laravel 7, MYSQL, repocitory on github (private)... i need continue working on it, but my normal freelancer is bussy right now... so open vacant... Please let me know u questiongs. Br. Im prefer spanish lang for choise my freelancer, but all are whelcome...

We are seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance a...seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance and scalability. MYSQL...

...ideal candidate will have expertise in Laravel, MySQL, and Firebase technologies. Responsibilities: Customize the school SaaS ERP control panel to integrate WhatsApp and inbox SMS APIs. Develop a dynamic frontend interface for easy navigation and user interaction. Implement backend functionalities to manage message sending, delivery, and history tracking. Ensure smooth integration with existing databases and systems. Create a secure authentication system for users accessing the platform. Test the system thoroughly to identify and fix any bugs or issues. Provide documentation and training materials for administrators on how to use the new features. Requirements: Proven experience in web development using Laravel framework. Proficiency in MySQL database management. Famil...

...static in-line string. // Here we give our audiotestsrc a name, so we can retrieve that element // from the resulting pipeline. pipeline, err := ( "audiotestsrc name=src ! audio/x-raw,format=S16LE,channels=1 ! fakesink", ) if err != nil { return err } // Get the audiotestsrc element from the pipeline that GStreamer // created for us while parsing the launch syntax above. // // TODO: There are some discrepancies still between methods that check the nil // value and return an error, versus those that will instead just return nil. // Need to settle on one way or the other. src, err := ("src") if err != nil { return err } // Get the audiotestsrc's src-pad. srcPad := ("src") if srcPad == nil { return errors

...functionality to preview and download existing quotes via the web and mobile applications. Additionally, assisting the client in installing the latest version on their local host to facilitate their participation in the testing process. Project 2: Software Enhancement and Bug Resolution Our second project is a comprehensive web-based software developed using HTML, Bootstrap, PHP, Laravel, and MySQL. We are not aiming to completely redesign the system but to improve upon the initial version, which encountered several bugs post-launch. We have initiated the development of a new version, currently 40% complete, that restructures and refines the existing tables and functionalities. Unfortunately, our lead developer is currently unable to continue due to health issues. We are seeking...

Looking for php/mysql developer to integrate discount coupon backend into admin panel. Straight forward. The admin panel is already working with a mobile app. We need to add that functionalitiy so we can later integrate it on mobile app

Sila Dafter atau Log masuk untuk melihat butiran.

E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

I'm looking for a talented, experienced React JS and Laravel developer to join my t...need to be proficient in React JS, with the ability to create attractive, responsive user interfaces. - Back-end development: Strong Laravel skills are essential. You'll be responsible for building and maintaining the core functionality of our platform. - Bug fixing: You should have a keen eye for detail and be able to identify and resolve bugs in both the front-end and back-end. - Experience with mySQL is a must. In your application, please include your relevant experience in React JS and Laravel. I'm looking for someone with a proven track record in both technologies. Communication is key, so we'll be using instant messaging as our primary form of contact. I look forward ...

I'm looking to create an application using NoCode developmen...credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Please contact to get more deta...

I want to... Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when applying to be considered, too many bots applying. Failure to do this step, you will not be contacted ⭐⭐...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Ex...experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, a...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

We are seeking a skilled and experienced java developer to create a custom JMeter backend listener that can send real-time test results directly to a PostgreSQL database. This project aims to enhance our testing capabilities by enabling seamless integration of JMeter results into our PostgreSQL environment, similar to existing solutions for MySQL like the one found at "" Requirements: Proven experience with Java programming and JMeter test development. Strong knowledge of PostgreSQL and experience in integrating it with Java applications. Familiarity with the JMeter API and backend listener framework

I'm in need of a skilled developer proficient in MySql, Php, HTML and Css, who can add a functional back office and payment system to my existing website. Key Requirements: - Your primary task will involve adding a back office and payment system that will be database-driven. - The system should include user management capabilities, payment processing functionality, and robust sales and customer record tracking. - Specific features for user management include: user registration, login, and profile management. - For the payment system, you'll need to integrate a payment gateway, provide for invoice generation, and ensure that the system maintains comprehensive transaction history tracking. The website is already designed, so your task will be to add the necessary function...

Básicamente quiero que me ayuden a crear la base de datos para un gimnasio en SQL server

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.