Alter database schema mysqlcông việc

As a growing organization, we are seeking skilled administrators to join our team. We are looking for passionate individuals in three specializations - office administrators, HR administrators and database administrators. The ideal candidates should possess the following: - Strong communication skills, - Proficiency in Microsoft Office Suite, and - Experience with database management. Applications should include: - A cover letter explaining why you're the right administrator for us, - Educational certificates to validate your qualifications, and of course, - A detailed CV showcasing your previous experiences. Looking forward to receiving your applications and potentially welcoming you to our driven team. Apply now and make a difference!

need Simple live chat system between 2 users, no designing needed. 1. login using php 2. show list of users fetched from db 3. on clicking a user, initiate chat (if the other user not blocked the requested user) 4. the chat should be live, realtime. and the data to be stored in mysql db 5. option to block user should use php as backend and bootstrap as front end . you can use firebase budget AUD 50 and should be done today please don't bid and ask for more time and money

I'm looking for a database design expert to help me create a new database. The specifics are a bit unclear at this stage, so I'll rely on your expertise to help me determine the best database type and functionality. Key Responsibilities: - Partner with me to decide on the most suitable database type, considering the intended purpose - Design the database from scratch, ensuring it's optimized for efficient storage, retrieval, and maintenance - Implement any necessary functionality to support the database's purpose Ideal Freelancer: - Proven experience in database design, particularly in creating new databases - Strong knowledge of various database types (relational, NoSQL, object-oriented) - Ability to collaborate and c...

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with ...

need Simple live chat system between 2 users, no designing needed. 1. login using php 2. show list of users fetched from db 3. on clicking a user, initiate chat (if the other user not blocked the requested user) 4. the chat should be live, realtime. and the data to be stored in mysql db 5. option to block user should use php as backend and bootstrap as front end . you can use firebase budget AUD 50 and should be done today please don't bid and ask for more time and money

...internal business tool/website. A very BASIC MS SQL schema will be provided for Functionality to interact with. The project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be possible to simply use that and make the 'users' logging in / connecting to the database more more explan...

Looking to implement an Elasticsearch Cluster primarily for improved data management and search ability for my app. The system must cater to handling and analyzing large amounts of structured data. Ideal Skills and Experience: - Strong Elasticsearch expertise - The system should integrate efficiently with both Logstash and MySQL. - Previous experience in cluster management - Proficient in tweaking and optimizing performance of cluster and data management

...customer service aspect of my business and to take charge of a small database (containing up to 1,000 records). Key responsibilities will include: - Customer Service: Responding to client enquiries, resolving user issues, and maintaining high customer satisfaction levels. - Database Management: Handling information pertinent to the customer service role, conducting regular updates, ensuring record accuracy, managing data privacy, and maintaining overall data integrity. The ideal candidate would have: - Prior experience in a customer service position, demonstrating excellent communication and problem-solving skills. - Proficiency in database management, more specifically with small scale databases. Knowledge of database software will be an added advantage....

We have an internal database with about 2000 European investor profiles from the last 20 years. I'm looking for a skilled developer to integrate OpenAI GPT to allow users to search for suitable investors in our database without needing to input a specific format, but normal text. the GPT then translates this text into a format of our database and based on a matching / scoring algorithm will select the best 10 investors for our set of 2000. The user should be able to go on our website. ask a question leave an email and get an answer with the top 10 list as an email attachment. That person needs to leave his contact details which will be automatically added to our Zoho CRM with a trigger action to setup a call for one of our sales people. Key Project Details: - ...

Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

...expert to assist in configuring a Linux VPS. The main purpose of this server is for database management specifically using MySQL. Key Tasks: - Configure a Linux (Ubuntu) VPS with optimal settings for database management. - Install MySQL and ensure it's fully functional. - Implement necessary security measures to safeguard the server and database. - Documentation of the process and any configurations made. The ideal freelancer for this project should have: - Proficiency in Linux (Ubuntu) server configuration. - Advanced knowledge of MySQL and its management. - Proven experience in setting up servers for database management. - Capable of implementing robust security measures to safeguard the server and database. - Ability ...

Seeking an expert to restore my website stored on an AWS server. The main goal is to recover lost data; specifically, substantial MySQL database information which unfortunately went missing. Key Skills and Experience: - Experience with AWS and MySQL is critical. - Proven track record of effective database recovery. - Proficient in database management and data retrieval. If you are adept in these areas and can ensure a successful recovery of my data, I would be interested in discussing further.

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

...interchangeability between server and users. Key responsibilities will include the development of all server-side logic, definition, and maintenance of the MYSQL database. This role also requires the optimization of the system for speed and scalability, as well as the integration of user-facing elements developed by front-end developers. The ideal candidate would have: - Solid PHP development experience. - Proficiency in MySQL databases and related operations. - Experience with User Management functionalities. - Expertise in Content Management operations. - Prior experience with Real-Time Data Processing. Your primary focus will be on: - Creating database schemas that represent and support business processes. - Implementing User Management and Content Man...

Please read carefully the full project before bidding. I consider and read all bids and bidders. Don't waste my time with a fake bid to get me to message you (I will ignore your bid). This is a seed project with the potential of an ongoing projects. I have questions within the description to make sure it is fully read. Please answer the...effective) - Share a plan to develop and build the website using these AI powered (no code) I'm in need of a competent full stack web developer with a background (experience) in web development and integration. I prefer someone who keeps track and knowledge of recent advancement on using AI solutions (no code). Knowledge in JavaScript Node.js, Python, proficient in working with databases (e.g., MySQL, MongoDB) and APIs. Is there an AI so...

...been retired and the new owners have changed Pixelmon Generation to a 1.20.1 mod as a sidemod as cobblemon. I would like to update the world save in an -as is- state. All of the blocks should have equivalents on both, including block states or orientations so I would expect this to be translated. As Generations is currently in Beta, this posting may require follow up should the developers further alter their source. However the current scope only exists for 3 goals: 1) Creation of a sidemod for the ~250 blocks removed by BiomeOPleanty mod 2) Creation of a string mapping between the existing world download blocks to all of the equivalent blocks including those in the sidemod and Pixelmon mod and translate the world file to a 1.20.1 world 3)Package all required mods to run, and ...

I am in search of a skilled backend developer with proficiency in Python, for a project that necessitates a relational database system for user authentication and authorization. Key Requirements: - Proficiency in Python: The project is built on Python, so the ideal candidate should have a strong command of this language. - Experience with Relational Databases: I am looking for someone with a background in working with relational database systems such as MySQL or PostgreSQL. - Security Conscious: Given the focus on user authentication and authorization, a strong understanding of security principles and best practices is essential. Additional Skills (preferred but not mandatory): - Experience with NoSQL or Cloud-based databases could be a plus, as these might be integr...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

Hi, I'm looking somone to edit my websoftware developped in php/mysql : Add : - field to attach a file per client - add account expiration date - Email notification - Link vehicles by API with our geolocation system

I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.

...own and clients sites who can help me with the following tasks: - Conduct an in-depth audit of my website's on-page SEO, identifying any issues that could be impacting our search engine rankings. - Implement fixes and improvements, with the aim of boosting our organic traffic and keyword rankings. - Optimize my website's service area URLs to enhance local search visibility. - Incorporate local schema markup to further improve our local SEO performance. Do not waste your time offering millions of pointless backlinks, do not waste our time with milestones, it's hourly work, if wanted milestones we would have done milestone projects! You will be hired hourly as and when we need work done. If work is good we have plenty of GMB work done. If you have citations local f...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I am in need of a MySQL expert to develop advanced queries for my database management tasks. Key Responsibilities: - Writing new queries: You'll be responsible for designing and implementing new, advanced MySQL queries. - Query Optimization: While the focus is on writing new queries, any optimization suggestions to existing queries are welcome. Ideal Skills: - Proficiency in MySQL: You should have advanced knowledge of MySQL language and its various functions. - Query Optimization: Experience in query optimization will be beneficial. This project is suitable for a MySQL developer with a proven track record in creating complex, high-performance database queries. It's important that you're able to work efficiently and effecti...

I'm seeking a proficient Full Stack Java Developer to create a web application. Even though I haven't specified the use of certain frameworks, familiarity with Spring Boot, Hibernate, and Angular will be useful. Your primary role will focus on: - Developing a highly responsive web application from scratch. - Implementing MySQL as the preferred database management system. Candidates who have prior experience in full-stack development and database management using MySQL are highly desirable. This is a project that demands robust technical skills, so a sound understanding of various Java frameworks and web application development is essential.

I need a skilled Java developer specializing in back-end development who can use MySQL as their database technology. The main task for the developer is to work on API development, ensuring the smooth transaction of data between the server and our end users. Ideal Skills and Experience: - Proficient in Java and backend development - Extensive experience with MySQL database technologies - Experience in API development and management

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Window...

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

I will be choosing someone one hour from now. Answer me this questions: Are you available immediately? We have a demo tomorrow 9am EST What is your experience with PHP? What AI tools do you use to make your devleopment faster? Are you comfortable working hourly?

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 th...

...category of "Lifestyle" & "Games", " If X does not hit, Choose Y at unit 1, 2, 3 and its all part of the algorithm that is built in and its a static algorithm. It does not change, there is no artificial intelligence in the app, mind you its designed in 2010s. - This makes it easy to work with as there should be no complex coding and there is no requirement for the chosen candidate /freelancer to alter the code. Now the issue / hurdle: - We do not have the open source to this IPA file and that is something that is lost including previous calculations/strategies (math's) used in the app and designed for the app. - We require you to also which is part of the job requirement to reverse engineer the file to compile the code / source. Key project r...

...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?: ?

I'm in need of a versatile software that can record video from endoscope cameras and facilitate the creation of a database from each video. Key requirements: - It should be compatible with Windows and Mac operating systems. - I prefer storing the database locally on the same device. - The software must support video formats AVI and MP4, which are the formats the endoscope cameras I use record in. The ideal freelancer for this project should have experience with: - Developing video recording software - Implementing database management systems - Proficiency in working across Windows and Mac operating systems - Knowledge of AVI and MP4 video formats Please submit your proposal with relevant experience and a clear explanation of how you plan to approach this proj...

WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.

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 o...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

Please fix my task that we spoke about

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 ...

...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 commented. Per...

...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

...development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experience in creating forms in MS Access - Ability to understan...

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 in need of a CodeIgniter expert to create a script that will automate the import of product images to our database. The images are currently broken and I need 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 w...

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...

I am urgently in need of a competent SEO specialist with experience in Linux. SEO would need installed onto server, knowledge in Maria DB, MySQL would also be an advantage im sure the website runs on apache Areas of expertise should include on-page optimization and in-depth keyword research. The primary goals of the campaign include: - Boosting search engine rankings - Raising the bar of organic traffic - Enhancing website visibility - Alt images Interested parties should demonstrate a strong background in these skills and be able to get started on the project immediately. Your quick and positive impact on our ranking and visibility is our priority.

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...

More detai...using that database. This isis for your reference : We operate a LPG gas agency, where customers exchange their empty cylinders for filled ones. However, sometimes we give out filled cylinders before receiving the empty ones back, resulting in two separate inventories: one for filled cylinders from our dealer, and another for empty cylinders returned by customers. To streamline 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 Arch...

Hi, we are a nonprofit based in Brazil. I am seeking a freelancer with outstanding research and data management skills to compile a list of geographical location of (environment and social) projects supported by a set list of 300 UK foundations (attached). Key Responsibilities: - I am only interested Foundations that provided grants to Brazilian organizations in the past 3 years (so the final list will be considerably shorter) - For these, I would need to know what are the themes covered by the foundation (for those grants but also beyond) - For some of these (that we will select later), I would need the email of the grants manager in charge (process wise, if it is easier to get te email of this entire subset, that’s ok) If a list of themes can be provided before hand, we can...