Fix mysql query error jobs

Filtro

Minhas pesquisas recentes
Filtrar por:
Orçamento
para
para
para
Tipo
Habilidades
Idiomas
    Estado do Trabalho
    6,005 fix mysql query error trabalhos encontrados, preços em EUR

    Precisamos de um especialista em SQL e Query em SQL. Temos um site desenvolvido em PHP (sem framework) onde ele realiza algumas querys em SQL. Entretanto, os bancos são BEM pesados (cada banco tem em torno de 500mb, com 2 a 3 milhões de linhas) e isso está tornando o site um pouco lento. Precisamos otimizar essas querys e o banco de dados, seja na utilizaçã...

    €148 (Avg Bid)
    €148 Média
    17 ofertas

    ...pontuação deles. A pontuação deles é feita assim: 1 ponto por entrega e são retirados pontos caso haja algum desvio de conduta Precisamos de um calculo automático disso em uma query Informação do folheteamento fica em 2 tabelas no BD 1 Informação das entregas fica em 1 tabela no BD 2 informaç&atil...

    €16 (Avg Bid)
    €16 Média
    13 ofertas

    SELECT distinct [MISTERCHEFNET].[dbo].[Lojas].[Nome Loja] as 'Loja' ,c.[Código Vendedor] as 'Código Entregador' ,a.[Nome Funcionário] as 'Entregador' ,c.[Data Caixa] ,c.[Data/Hora Vencimento] ,(c.[Tempo Total Entrega] - c.[Tempo Preparo]) as 'Tempo Entrega' ,c.[Tempo Preparo] ,c.[Tempo Total E...

    €23 (Avg Bid)
    €23 Média
    6 ofertas

    Fix SQL Query Issue. What to fix: Need to fetch those records / rows that contains all keywords in any column in Name, Descr or OtherDesc Columns. See txt file for details. Important Note: Please read the txt file and prepare your queries if any before posting, otherwise the bid will be rejected.

    €21 (Avg Bid)
    €21 Média
    21 ofertas

    Need help in select query in MS Access

    €2 / hr (Avg Bid)
    €2 / hr Média
    10 ofertas

    Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When

    €16 (Avg Bid)
    €16 Média
    12 ofertas

    Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When

    €17 (Avg Bid)
    €17 Média
    6 ofertas

    The solution I am after requires a data engineering development which should be able to query a postgreSQL database of 20 million records (2 crores). In the ideal scenario, the query should return 100,000 records under 5 seconds. I am looking for someone who is experienced in Apache Spark and able to show a proof of concept before developing a full

    €227 (Avg Bid)
    €227 Média
    9 ofertas

    When the checkout function is used i get the error WARNING : Error while sending QUERY packet. PID in /ur/www/users/xtremezepc/[login to view URL] on line 1924 This is causing high load times when i try to check out. there are sleeping queries being created. Need fixed NOW.

    €96 (Avg Bid)
    €96 Média
    25 ofertas

    Using REACT, we want to pull in API results into HTML. We want to use a query string parameter to determine which results to pull using the API call and then display results. The goal is to have the query string parameter from the following URL pull into the API: [login to view URL] The “3828840” is the result ID that will

    €162 (Avg Bid)
    €162 Média
    16 ofertas

    ...[login to view URL] ) - Application algorithm: 1. Run a query every 30 seconds, read the records of a table with a control field = 0 2. If there are records, create two text files in a shared folder. o First file must contain some values retrieved from the query just executed. Name of file: [login to view URL] o Second File is standard (it

    €168 (Avg Bid)
    €168 Média
    6 ofertas

    We have a dealer website with a login and search ability, we want to be able to have the same search ability that is always up to date to the host site minus one column of the search results.

    €93 (Avg Bid)
    €93 Média
    26 ofertas

    I am looking for a product that can a.) receive texts and phone calls with an automated attendant b.) query a database and acknowledge accuracy then c.) send a call or text to another user. I will also require a simple database containing names, addresses and contact information. I would prefer to work with someone with which I can meet face to

    €532 (Avg Bid)
    €532 Média
    3 ofertas

    1. The program will follow XML stream where a query will be made. 2. The query interval must be able to be determined 3. The program must work as a service (and I want to test it on command prompt or other way) 4. XML is situated in a path or address like [login to view URL] (it can also be on a different pc like 10.10.10.1234:5656 / xxxxxxxxcurrent

    €943 (Avg Bid)
    €943 Média
    27 ofertas
    create mysql query Encerrado left

    I have a small database with 4 tables. Need mysql query to get correct data from tables. Table structure will be discussed but basically it is feed, user, school_profile, job

    €20 (Avg Bid)
    €20 Média
    41 ofertas
    Create SQL query Encerrado left

    We need an SQL query built for a hotel group. This query will be run at any date in time, to pull historical, future or combination of both to show what segmentation is on the books [to include revenue, room nights & average daily rate] We will run the query and then the attached file is how we want the data to be exported from the Property Management

    €612 (Avg Bid)
    €612 Média
    80 ofertas

    ...making some queries work. This first project is for a table that I tried to put together myself but I just do not know SQL. I have pieces but not the whole. Will lead to more query projects. Hoping to find a someone that knows Open Dental tables and can accurately build reports. Sample Open Dental Queries: [login to view URL]

    SQL
    €10 / hr (Avg Bid)
    €10 / hr Média
    55 ofertas

    Hello, I need easy access query support, I have the set of data which is in Totals Select Query. There are bunch of users with 1 line per user and 5 attributes in column. I would like to have 5 lines per every user with those attributes in rows

    €22 (Avg Bid)
    €22 Média
    7 ofertas

    I need a lightweight applicatio...= , < , >, <> user defined criteria. There are 4 components to the application- 1. DB connections 2. The monitor - The monitor will be a collection of sql query, schedule to run the query, contact to alert if condition is met 3. Logs showing history of when monitors are run and results. txt file based logs are ok

    €137 (Avg Bid)
    €137 Média
    41 ofertas

    Part A and B Part-A. Basic SQL Dataset: ComputerStore The schema is as follows: ComputerStore manufacturers code, name products code, name, price, manufacturer The manufacturers table stores information about computer parts manufacturers as the manufacturer code and manufacturer name. The products table stores information about product as a product code, product name, product’s price a...

    €17 (Avg Bid)
    €17 Média
    1 ofertas

    Looking for parttime help of person with 1+ year Query Surge skills.

    SQL
    €10 / hr (Avg Bid)
    €10 / hr Média
    9 ofertas

    [login to view URL] Is the website. Using the API key the data gets extracted every 12 hours and then it goes into database. The website should offer the functionality where i could pick the day intervals to see the change in the ranking of coins etc so the coloums on the front end would reflect the time interval i select . I could be a combination of time intervals Change in Ranking (1D,3D,7D,...

    €85 (Avg Bid)
    €85 Média
    4 ofertas

    Modify existing query to filter some results. I have a table that collects information about telecom top-ups . I need to filter out the numbers that have recharged their balance one time for a value of 150.

    €22 (Avg Bid)
    €22 Média
    40 ofertas

    I Need help mysql query optimization

    €22 (Avg Bid)
    €22 Média
    26 ofertas

    Modify existing query to filter some results. I have a table that collects information about telecom top-ups . I need to filter out the numbers that have recharged their balance one time for a value of 150.

    €24 (Avg Bid)
    €24 Média
    10 ofertas

    Need Import Forum Tables into Kunena 2.04 (Joomla FOrum Extension) with a MySQL/PHP Query or with Kunena Importer. the process complete not properly

    €47 (Avg Bid)
    €47 Média
    8 ofertas

    Need an Excel expert to help us with some data analysis using power query. Please respond only if you have experience with M & DAX.

    €145 (Avg Bid)
    €145 Média
    9 ofertas

    ...Combine 5 Excel WorkSheets across 100 WorkBooks that we are trying to solve with automation and the use of the Power Query Append Command. Do not respond to this project unless you can show us some actual examples of your Excel Power Query Workbooks which are working correctly. Every 2 weeks we get between 75 and 100 individual WorkBooks named after

    €119 (Avg Bid)
    €119 Média
    26 ofertas

    I am building a database for a preschool and need to calculate the children’s ages in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes.

    €55 (Avg Bid)
    €55 Média
    25 ofertas

    We maintain approximately 100 databases in SQL 2008. We need to bill each month based on the number of records added to each database. We have been doing this ma...language I understand. I will need to be able to make changes down the road as we modify our process, add/remove county databases etc. This has to be accomplished in SQL Server query.

    €130 (Avg Bid)
    €130 Média
    11 ofertas

    This query working SELECT DATE_FORMAT(oo.date_added, '%m/%d/%Y') as Date, ot.order_id, round([login to view URL],2) as total, round(SUM([login to view URL]*[login to view URL]),2) AS weight, round(SUM([login to view URL]*p.cost_sk),2) AS product_cost, (Select round(SUM([login to view URL]),2) from oc_order_total ot1 where [login to view URL] like 'tax' and ot1.or...

    €23 (Avg Bid)
    €23 Média
    11 ofertas

    Hello, I need to modify Powershell SQL query to retrieve multiple drive mappings. RIght now it maps drive fine only if user belongs to one group. But if user belongs to multiple groups mapping gets messed up.

    €123 (Avg Bid)
    €123 Média
    13 ofertas

    Need sql query to search database and copy random value to write row value to adjacent db column.

    €21 (Avg Bid)
    €21 Média
    26 ofertas
    Build Postgres Query Encerrado left

    I have a Postgres table with over 90 million records and trying to build a particular query in the most efficient way. PostgreSQL experience is mandatory however Python and Django skills will be advantageous. It's probably less than one hours work and urgent. So I will be choosing some one who is currently online within the next 1 hour! PS: L

    €27 (Avg Bid)
    €27 Média
    3 ofertas

    My Codeigniter web application is powered by 2 separate MySQL databases. I need a query that will query both databases individually on demand, on the fly, for each each user request, and combine the results programmatically.

    €22 (Avg Bid)
    €22 Média
    16 ofertas

    I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required) for this.

    €19 (Avg Bid)
    €19 Média
    17 ofertas

    Hi, I need some SQL query line work outsourced for my company. Must be done right away.

    €24 (Avg Bid)
    €24 Média
    6 ofertas

    1 step : need help creating ajax query to send and receive json data with multiple data 2nd step : need help to create php script that receive data send using ajax query and call another php script 3rd step : call another php script to perform specific function from another folder 4th stpe: send output back to web page 5th step : need to make sure

    €22 (Avg Bid)
    €22 Média
    7 ofertas

    Hello, I run a Wordpress store with Woocommerce. I want to display a top 10 sales charts of "recent" sales on a page. I'm looking for a custom script / query to display a vertical list of the 10 products that sold the most copies in the last 30 days (like a current top sales charts). I would like to have it usable via a shortcode, so that I can display

    €55 (Avg Bid)
    €55 Média
    6 ofertas

    ...need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field. Any amount of text could exist before or after the pattern that's shown. I should be able to add Where clauses to the query to filter the dataset that's used for the query. Example:

    SQL
    €88 (Avg Bid)
    €88 Média
    27 ofertas

    BIDS OVER $100 WON'T BE HIRED. VIDEO INSTRUCTIONS = [login to view URL]

    €71 (Avg Bid)
    €71 Média
    34 ofertas

    I am looking for googlesheets integration with the eventbrite api. I would like to be able to run a query like this: [login to view URL] and have the results returned into a googlesheet with each event

    €157 (Avg Bid)
    €157 Média
    10 ofertas

    Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €10 / hr (Avg Bid)
    €10 / hr Média
    28 ofertas

    Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €5 / hr (Avg Bid)
    €5 / hr Média
    11 ofertas

    Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €5 / hr (Avg Bid)
    €5 / hr Média
    35 ofertas
    SQL Query History Encerrado left

    need to find out how to view sql query history that shows who ran the query, how many records affected, where it was run from etc..

    €37 (Avg Bid)
    €37 Média
    19 ofertas

    I need some changes to an existing website. I already have a design, I just need you to build it. I would like a query display on a page that shows current unpaid customers.

    €79 (Avg Bid)
    €79 Média
    16 ofertas

    I need a query to activate "Status Stock" In stock on all my products Type: Configurable Product Issue: There was a load of products but the Options Status Stock is Out Of Stock and it display the products on the front "Out Of Stock" even when the variables has stock on it.

    €46 / hr (Avg Bid)
    €46 / hr Média
    26 ofertas

    I am looking for someone who can create a form with multiple inputs ...a column in a table. - the values for the drop downs will also be from a column in a database table. Once the form is created, it will need to work as a search "system" to query a table in the database and display a table with the returned values. Using AJAX, PHP, JavaScript etc!

    €24 (Avg Bid)
    €24 Média
    23 ofertas