Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    186 bigint jobs found, pricing in USD

    Looking for working basic Flask SQLalchemy CRUD web application to do CRUD openations on this MS SQL Server table: If the code changes (additional fields are added, the database must change accordingly) CREATE TABLE [dbo].['Buchhaltung-A220$']( [ID] [bigint] IDENTITY(1,1) NOT NULL, [Beleg] [nvarchar](255) NULL, [Objekt] [bigint] NULL, [Datum] [datetime] NULL, [Geschaeftsvorfall] [nvarchar](255) NULL, [Kilometer] [float] NULL ) ON [PRIMARY] Flask 3.0 SQLalchemy 2

    $38 (Avg Bid)
    $38 Avg Bid
    12 bids

    We are looking for a PowerApps application, that * has a user frontend, for users to query the database table (Dataverse possibly) for data * has a manager frontend to put data into the database table * has a moderator frontend to query and manage the data in the table (...and output that string to the user * The manager frontend should allow the manager to enter new rows into the table, * the moderator frontend should act in a similar way as the user frontend, with the difference that on the result page, the referenced rows should be changeable / deletable. We currently anticipate the following columns in the database table: * id : bigint, primary-key * name : varchar(500) * reference : bigint -> references id-column * reference_type : varchar(1000) * type : int * comm...

    $808 - $1616
    Featured Sealed
    $808 - $1616
    67 bids

    I have a database with a column that contains timestamps in bigint format. The timestamps are in UTC time zone. I need a piece of code to insert in a SELECT statement in Athena that converts the timestamp data to Thailand/Bangkok time and also converts it into the columns ‘date’ and ‘time’ (based on the Bangkok time). I am a beginner in SQL and can’t figure out how to do this. Small-size database attached.

    $28 (Avg Bid)
    $28 Avg Bid
    13 bids

    I need to create simple website ideally with php. Website will be with 3 pages and social login functionality via discord ( every one who will log via discord need to be added to database as a user ) Page 1 - contains links to page2 and page3 Functionality of page2: User inserting 3 values : Value1 - Range ( this is string of 2 integers like "2345-787879" or single bigint ) - required value2 - ( nvarchar (200) ) - optional Value3 - (nvarchar 200) - optional Value4 in the background is added in MySQL against above records - user discord username used to log in to page ( only users from specific server can log in to the main website) Inserts limited to 1 per 10 seconds - no duplicated entries allowed. After user press insert the above values are inserted in to mssql data...

    $220 (Avg Bid)
    $220 Avg Bid
    61 bids

    I need report for this sql table the script is CREATE TABLE [dbo].[CrossTable]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [StudentName] [nvarchar](max) NOT NULL, [SubjectName] [nvarchar](max) NOT NULL, [Unit] [float] NOT NULL, [ChapterID] [nvarchar](max) NULL, [Grade] [int] NOT NULL,--round1 [Word] [nvarchar](max) NOT NULL,--round1 [Grade1] [int] NOT NULL,--round2 [Word1] [nvarchar](max) NOT NULL,--round2 [Grade2] [int] NOT NULL,--round3 [Word2] [nvarchar](max) NOT NULL,--round3 [Grade3] [int] NOT NULL,--round4 [Word3] [nvarchar](max) NOT NULL,--round4 the table result will be as in attachment

    $33 (Avg Bid)
    $33 Avg Bid
    9 bids

    ...stored on local folders i.e video & audio. 4. Local storage plugin Ability to store data to a sql lite table, table structure below: readonly databaseCreateTableQuery: string = 'CREATE TABLE IF NOT EXISTS memory( memoryid INTEGER PRIMARY KEY AUTOINCREMENT, id BIGINT, memoryName VARCHAR(100), memoryBody VARCHAR(1000), memoryType VARCHAR(20), videoMemoryPath VARCHAR(200), voiceMemoryPath VARCHAR(200), imageMemoryPath VARCHAR(200), reminder VARCHAR(200), repeatDelivery VARCHAR(200), deliveryDate VARCHAR(200), senderId BIGINT(20), recipientId BIGINT(20), receiverName VARCHAR(30), receiverSurname VARCHAR(30), receiverEmail VARCHAR(30), receiverContactNumber VARCHAR(30),location VARCHAR(200) , viewStatus INT(20), sendStatus INT(11), dateCreated VARCHAR(100), isDe...

    $576 (Avg Bid)
    $576 Avg Bid
    65 bids

    Hi, The SQL script I attached contains an arithmetic overflow error. I tried replacing int with bigint and decimal, but I still get an error message when running the query for a specific date (10-Nov-2022). Could you please help me run the SQL script? Thank you.

    $101 (Avg Bid)
    $101 Avg Bid
    26 bids

    CREATE TABLE [dbo].[TRANSPORTSERIALTRACKING]( [PREFIX] [nvarchar](10) NOT NULL, [SERIALNUMBER] [nvarchar](30) NOT NULL, [DENOMID] [int] NOT NULL, [CURRENCYCODE] [nvarchar](30) NOT NULL, [DENOMINATION] [nvarchar](30) NOT NULL, [SERIES] [nvarchar](30) NOT NULL, [NUMERICSERIALNUMBER] [bigint] NULL, [SUFFIX] [nvarchar](10) NULL, [LASTINCASHCENTERID] [int] NOT NULL, [DATEFIRSTIN] [date] NULL, [DATEFIRSTOUT] [date] NULL, [COUNTRETURNS] [int] NOT NULL, [DATELASTIN] [date] NULL, [DATEDESTROYED] [date] NULL, [SORTINGDATEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGSITEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGQUALITYINSEQUENCE] [nvarchar](2000) NULL, [SORTINGMACHINEINSEQUENCE] [nvarchar](2000) NULL, [TRANSPORTFILEIDINSEQUENCE] [nvarchar](2000) NULL, [HEADERCARDINSEQUENCE] ...

    $42 (Avg Bid)
    $42 Avg Bid
    19 bids

    hello we try to verify ASSETS with metaplex using this CMD : ts-node ~/desktop/metaplex/js/packages/cli/src/ verify_assets ./assets but we get this error : bigint: Failed to load bindings, pure JS will be used (try npm run rebuild?) started at: 1652254059294 Verifying token metadata for 10 (img+json) pairs Checking manifest file: /Users/freelancer/Desktop/metaplex/js/packages/cli/assets/ /Users/freelancer/desktop/metaplex/js/packages/cli/src/commands/verifyTokenMetadata/ throw new Error( ^ Error: Creator share for /Users/freelancer/Desktop/metaplex/js/packages/cli/assets/ does not add up to 100, got: 0. at verifyAggregateShare (/Users/freelancer/desktop/metaplex/js/packages/cli/src/commands/verifyTokenMetadata/:11)

    $59 (Avg Bid)
    $59 Avg Bid
    7 bids

    Hello, I have a site, this site has a new version and the table schema has changed a little. I need a SQL file to change the schema of the old database into the new one and keeping the data. See files: - => the current database - => what the database should look like So I need a SQL file to run that should look like this: ALTER TABLE `articles` CHANGE `id` `id` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `articles` CHANGE `text` `article` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL; TABLE `articles` DROP `promoted`; TABLE `articles` DROP `cover`; etc... Warning: I know some of you would like to use an automated tool. But be aware that automated tools will delete and add fields, not rename them. Example : Want I want : ALTER TABLE `...

    $157 (Avg Bid)
    $157 Avg Bid
    32 bids

    3 separate sql statements Group by 1 - Group by day 2 - Group by week (a week is Monday thry Sunday) 3 - Group by Month Table structure is ges_id bigint (20) NOT NULL auto_increment, user_id int(11) NOT NULL default '0', word varchar(50) NOT NULL, guessday date, guessday_datetime datetime, winner tinyint(4) NOT NULL default '0', match_exact tinyint(4) NOT NULL default '0', ct_letters tinyint(4) NOT NULL default '0', PRIMARY KEY (ges_id) ******************************************************************************* DATA Information 1 = winner 0 = Not winner g.match_exact This is how many they matched g.ct_letters This is how many letters are in word they guessed words can be a different length each day...

    $32 (Avg Bid)
    $32 Avg Bid
    30 bids

    Need help with a PHP algorithm using BigInt math. Please contact me for more details.

    $148 (Avg Bid)
    $148 Avg Bid
    21 bids

    The dashboard of our wordpress website is only showing vertical text. See attachment. And is seems like a database error. DATABASE ERROR: 'The used table type doesn't support FULLTEXT indexes' [SQL=CREATE TABLE `i6sb7_trp_dictionary_nl_nl_en_gb` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `original` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `translated` longtext COLLATE utf8mb4_unicode_...]

    $27 (Avg Bid)
    $27 Avg Bid
    20 bids

    ...going for as long as possible. Currently, I am using the Spigot Algorithm that can be found here: This code works but after a day of it running non-stop it begins to slow down because it takes more and more CPU calculations to generate the next digit of PI(I believe), and this in turn slows the program that is using the digits of PI. I believe BigInt is part of the reason it gets slower as time goes on. So, I'm looking for a more efficient way to generator each digit of PI and I've heard there are two major ways to do this: one is CPU intensive and the second is more memory intensive? If this is true, I would like a method that is more memory intensive because the program needs CPU power to run well; and memory is more abundant on PC

    $22 (Avg Bid)
    $22 Avg Bid
    2 bids

    when I am trying to import db Error SQL query: -- -------------------------------------------------------- -- -- Table structure for table `error_logs` -- CREATE TABLE `error_logs` ( `id` bigint(20) NOT NULL, `sessionId` text NOT NULL DEFAULT '0', `user_type` tinyint(1) NOT NULL DEFAULT 0, `agent_id` text NOT NULL, `conductor_id` int(20) NOT NULL DEFAULT 0, `agent_name` text NOT NULL, `agency_name` text NOT NULL, `time_format` text NOT NULL, `current_dates` text NOT NULL, `records` text NOT NULL, `created_date` timestamp NOT NULL DEFAULT current_timestamp(), `status` tinyint(1) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 MySQL said: Documentation #1101 - BLOB, TEXT, GEOMETRY or JSON column 'sessionId' can't have a ...

    $14 (Avg Bid)
    $14 Avg Bid
    7 bids

    ...example: $domain = “”; Script must check if this domain - has a valid SSL certificate - if the certificat is still valid - check if installation is OK (full chain check) Result must be like this if ssl is not OK it must give an error Results must be stored in DB for example: CREATE TABLE `domain_checks` ( `id` bigint(20) UNSIGNED NOT NULL, `domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `common_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_valid_certificate` tinyint(1) NOT

    $161 (Avg Bid)
    $161 Avg Bid
    14 bids

    ...start for example: $domain = “”; Script must check if this domain - has a SSL certificate - if the certificate is valid - check if installation is OK For this check you can use a validation class like not tested but hope it can help or if you have another use it Results must be stored in DB for example: CREATE TABLE `domain_checks` ( `id` bigint(20) UNSIGNED NOT NULL, `domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `common_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_valid_certificate` tinyint(1) NOT

    $148 (Avg Bid)
    $148 Avg Bid
    17 bids

    ...data every second from all these Devices using JAVA, multi threading. As I have single device for testing. So as of now Code can be tested on 1 device and can be tested for rest of the devices on site at client end. Support will needed to test it at client end after lock down period is over. SQL Table structure DROP TABLE IF EXISTS `dl_eventlog_dtpew`; CREATE TABLE `dl_eventlog_dtpew` ( `id` bigint(50) NOT NULL, `event_time_epoch` LONG NOT NULL, `event_time` timestamp NOT NULL DEFAULT '1990-01-01 00:00:00', `line_id` int(10) DEFAULT NULL, `machine_id` int(10) DEFAULT NULL, `dt` varchar(15) DEFAULT NULL, `tm` varchar(15) DEFAULT NULL, `mould_id` int(11) DEFAULT NULL, `left_power_d1` int(1) DEFAULT NULL, `left_emergency_d2` int(1) DEFAULT NULL, `l...

    $92 (Avg Bid)
    $92 Avg Bid
    3 bids

    Need help to simply create a MySQL query to change table sequence_invoice_1 and have changed type of "sequence_value" from int(10) to bigint(20).

    $15 (Avg Bid)
    $15 Avg Bid
    15 bids

    MySQL relational database has 100+ tables. Some tables have "ON DELETE CASCADE" directive installed for example: CREATE TABLE `problem_tag` ( `problemtagid` bigint unsigned NOT NULL, `eventid` bigint unsigned NOT NULL, `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`problemtagid`), KEY `problem_tag_1` (`eventid`,`tag`,`value`), CONSTRAINT `c_problem_tag_1` FOREIGN KEY (`eventid`) REFERENCES `problem` (`eventid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Because of this constraint, I would like to generate a SELECT query to possibly detect orphaned data: SELECT eventid FROM problem_t...

    $36 (Avg Bid)
    $36 Avg Bid
    6 bids

    We have a wordpress website, but it appears the woocommerce plugin (or possible plugin conflict) is causing processes to get stuck, which eventually crashes the site. it appears there are a large number of processes are stuck, specifically database queries locking the table: ======== ALTER TABLE wp8e_wc_category_lookup CHANGE COLUMN `category_tree_id` category_tree_id BIGINT UNSIGNED NOT NULL INSERT IGNORE INTO wp8e_wc_category_lookup (category_tree_id,category_id) VALUES (729,729),(730,730),(729,730),(741,741),(729,741),(746,746),(729,746),(731,731),(729,731),(742,742),(729,742),(732,732),(729,732),(743,743),(729,743),(733,733),(729,733),(734,734),(729,734),(735,735),(729,735),(736,736),(729,736),(737,737),(729,737),(738,738),(729,738),(739,739),(729,739),(744,744),(729,744),(825...

    $70 (Avg Bid)
    $70 Avg Bid
    11 bids

    chatRooms --------- chatRoomId bigint UUID varchar(36) type varchar(25) niceName varchar(25) chatRoomParticipants -------------------- chatRoomId bigint userId bigint My app integrates private chat messaging. Whenever an user (userId) wants to send a private message to another user, I have to perform a query to find the chatRoom of type "PRIVATE_CHAT_ROOM" of which both and ONLY TWO of the users are participants - and if the chatRoom does not exist, it needs to be created. So let's assume userId 83 wants to send a message to userId 84, I need to extract the chatRoomId 213 of type PRIVATE_CHAT_ROOM: chatRooms --------------------------------------------- chatRoomId 213 UUID 923ifds-1239u1d-3128ufdk-21asd type "PRIVATE_CH...

    $23 (Avg Bid)
    $23 Avg Bid
    20 bids

    Create a REST WebService to update a table in datastax. 1. Need webservice 2. datastax repository 3. jUnit Test URL /orders/{orderNumber}/hold REST Type PUT Valid Statuses 200 - Success 500 - Other system-rela...Request Body: UpdateOrderHoldRequest { currentHold : { holdCode : String, subHoldCodes : String[] } } Response Body UpdateOrderHoldResponse { currentHold : { holdCode : String, subHoldCodes : String[] } previousHold : { holdCode : String, subHoldCodes : String[] } } CREATE TABLE order_by_order_number ( order_number bigint, current_hold_code text, current_sub_hold_codes frozen<list<text>>, previous_hold_code text, previous_sub_hold_codes frozen<list<text>&g...

    $46 (Avg Bid)
    $46 Avg Bid
    7 bids

    This PowerShell script will read an ...Owner 10) RecoveryModel Then dump the gathered information into a SQL table named Databases whose definition is given below. CREATE TABLE [dbo].[Databases]( [DatabaseID] [int] IDENTITY(1,1) NOT NULL, [InstanceName] [varchar](50) NOT NULL, [DatabaseName] [varchar](200) NOT NULL, [CreateDate] [date] NOT NULL, [Status] [varchar](64) NOT NULL, [UPdatebility] [varchar](64) NOT NULL, [db_size] [bigint] NOT NULL, [DatafileSize] [int] NOT NULL, [LogFileSize] [int] NOT NULL, [Owner] [varchar](100) NOT NULL, [RecoveryModel] [varchar](64) NOT NULL, [LoadDate] [date] NOT NULL, CONSTRAINT [PK_Databases_DatabaseID] PRIMARY KEY CLUSTERED ( [DatabaseID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO ** Output of the databases table is shown in

    $205 (Avg Bid)
    $205 Avg Bid
    4 bids

    Hi, I have a table with this structure CREATE TABLE [dbo].[mytree]( [id] [bigint] NOT NULL, [name] [nvarchar](24) NULL, [parentid] [bigint] NULL ) As you might guess, it represents a tree structure. I use this script to obtain all the data in the form of the tree select , AS name, from mytree left outer join mytree ltable on = If we run the script, the result would be something like this id name parentid 0 Root 0 (null) 1 Level1-1-0 0 2 Level1-2-0 0 3 Level1-3-0 0 4 Level2-4-1 1 5 Level2-5-1 1 6 Level2-6-1 1 7 Level2-7-2 2 8 Level2-8-2 2 9 Level2-9-2 2 10 Level2-10-3 3 11 Level2-11-3 3 12 Level2-12-3 3 13 Level3-13-7 7 14 Level3-14-7 7 15 Level3-15-7 7 The requirement is that I want a script that allows

    $35 (Avg Bid)
    $35 Avg Bid
    14 bids

    ...data every second from all these Devices using JAVA, multi threading. As I have single device for testing. So as of now Code can be tested on 1 device and can be tested for rest of the devices on site at client end. Support will needed to test it at client end after lock down period is over. SQL Table structure DROP TABLE IF EXISTS `dl_eventlog_dtpew`; CREATE TABLE `dl_eventlog_dtpew` ( `id` bigint(50) NOT NULL, `event_time_epoch` LONG NOT NULL, `event_time` timestamp NOT NULL DEFAULT '1990-01-01 00:00:00', `line_id` int(10) DEFAULT NULL, `machine_id` int(10) DEFAULT NULL, `dt` varchar(15) DEFAULT NULL, `tm` varchar(15) DEFAULT NULL, `mould_id` int(11) DEFAULT NULL, `left_power_d1` int(1) DEFAULT NULL, `left_emergency_d2` int(1) DEFAULT NULL, `l...

    $18 (Avg Bid)
    $18 Avg Bid
    2 bids

    ...what is inside of each stuff on this plant. You just need to create a visual front-end that they can click and show data from the sensors. Sensor data is already in a MySQL database on the server. Deliverables: Complete Front-End Show clickable blocks Show block sensors-data when inside a block ====================================== MySQL Table that will be used: CREATE TABLE `registers` ( `id` bigint(11) NOT NULL, `controller` int(11) NOT NULL, `reg_type` varchar(20) NOT NULL, `reg_id` int(11) NOT NULL, `reg_subid` int(11) DEFAULT NULL, `value` float NOT NULL, `reg_time` datetime NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `registers` (`id`, `controller`, `reg_type`, `reg_id`, `reg_subid...

    $11 / hr (Avg Bid)
    $11 / hr Avg Bid
    27 bids

    ...chargelines that apply to the customer and the definition table is shown below. Some of the charges are fixed, while others consist of a formula that says {Width_of_land}*{Length_Of_Land}*2080 . I need to calculate the Total amount based on a couple of charge lines that are a combination of fixed and variable (formula) inside a SQL function that is shown below. create table tblTarrifLine (ID bigint identity not null, Description varchar(100), UnitRate decimal(18,2), TarrifType varchar(100) default 'Fixed', Formula varchar(100)) go Insert into tblTarrifLine (Description,UnitRate,TarrifType,Formula) VALUES('Line Charge',30,'Fixed','') Insert into tblTarrifLine (Description,UnitRate,TarrifType,Formula) VALUES('Property Tax',1,...

    $33 (Avg Bid)
    $33 Avg Bid
    10 bids

    WordPress database error Cannot change column 'permission_id': used in a foreign key constraint 'fk_wp_wc_download_log_permission_id' of table 'newregal_regalia.wp_wc_download_log' for query ALTER TABLE wp_woocommerce_downloadable_product_permissions CHANGE COLUMN `permission_id` permission_id BIGINT UNSIGNED NOT NULL auto_increment made by require_once(''), require_once(''), require_once(''), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta

    $24 (Avg Bid)
    $24 Avg Bid
    18 bids

    ...`ContactNo` INT(11), `UserLevel` INT(2) ); The user will only register with: account number pin number contact telephone number User will have a default userlevel of 1 with an admin user having userlevel 2. The registration will only be visible to an admin login. I then need a transactions page to show current client balances using the following table CREATE TABLE `transactions` ( `TranId` BIGINT(11) NOT NULL AUTO_INCREMENT, `Description` VARCHAR(100), `Criteria` VARCHAR(100), `Result` VARCHAR(100), `Amount` DECIMAL(7,2), `Direction` INT(11), `UserID` INT(11), `TimeStamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`TranId`) ); As an admin it will be able to add new line items to the above with TransId being auto set. In this case the Description field will be a dro...

    $158 (Avg Bid)
    $158 Avg Bid
    17 bids

    I have an RPN calculator which works for small integers, I need it to work for big integers using the bigint library. This is a small task which I would like to pay 30 pounds.

    $111 (Avg Bid)
    $111 Avg Bid
    7 bids

    Already implemented rpn calculator using integers and is perfectly working and I want to add functionality to use rational numbers and bigint.

    $24 (Avg Bid)
    $24 Avg Bid
    6 bids

    ...wp_aiowps_login_activity (user_id, user_login, login_date, login_ip) VALUES ('2', 'michelp', '2019-01-21 16:38:59', 'xxx') I took a look at the database, and I noticed that a lot of tables don't have AUTO_INCREMENT enabled anymore, and also the next AUTO_INCREMENT value is 0. I all ready repaired a couple of tables like this: ALTER TABLE wp_aiowps_login_activity AUTO_INCREMENT = 58, CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT I have 114 tables. I need you to check each table and repair the AUTO_INCREMENT value where needed. I will provide you a copy of the DB so you can work on it locally. You probably need to compare with a fresh Wordpress DB (and plugins) to know which field should be auto increment. Once the repair its d...

    $32 (Avg Bid)
    $32 Avg Bid
    23 bids

    ...am attaching a file that contains table structure and test data of about 5 rows. CREATE TABLE `temp2` ( `Date` date NOT NULL, `ShortName` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `Number` int(6) NOT NULL, `LongName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `Open` double NOT NULL, `High` double NOT NULL, `Low` double NOT NULL, `Close` double NOT NULL, `Volume` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; Although only 4 columns (Date, ShortName, Close, Volume) are relevant, yet I have sent complete structure of the table. This table will contain about 600 rows per day and will have data of about 15 years. Requiredment: I want to find out that which 'ShortName' has continuously increased &#...

    $25 (Avg Bid)
    $25 Avg Bid
    4 bids

    Need a script to work on C# program, here's the full scripts in python and JS Python - " def getInstagramUrlFromMediaId(media_id): alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZab...alphabet[int(remainder)] + shortened_id return '' + shortened_id + '/' " JS - " function getInstagramUrlFromMediaId(media_id) { var alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-_'; var shortenedId = ''; media_id = (0, ('_')); while (media_id > 0) { var remainder = bigInt(media_id).mod(64); media_id = bigInt(media_id).minus(remainder).divide(64).toString(); shortenedId = (remainder) + shortenedId; } return '' + shortenedId + ...

    $10 (Avg Bid)
    $10 Avg Bid
    1 bids

    ...$conn->prepare("INSERT INTO memo(firstname, lastname, email) VALUES (:firstname, :lastname, :email)"); foreach($rows as $key => $value){ $stmt->bindParam($key, $value); } $stmt -> execute(); Please note: My code is Prepared statements and When you fix it please keep my code as it is Prepared statements to be useful against SQL injections MySQL code below CREATE TABLE `memo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `firstname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLA...

    $16 (Avg Bid)
    $16 Avg Bid
    17 bids

    ...TABLE `cft_fitbitheartratezone` ( `heartratezone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(40) DEFAULT NULL, `heart_zone_type` varchar(1) NOT NULL, `heart_zone_name` varchar(20) NOT NULL, `heart_rate_min` int(11) DEFAULT NULL, `heart_rate_max` int(11) DEFAULT NULL, PRIMARY KEY (`heartratezone_id`), KEY `by_user_zones` (`user_id`,`heart_zone_type`,`heart_zone_name`,`heart_rate_min`,`heart_rate_max`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; CREATE TABLE `cft_fitbitheartrateday` ( `heartrateday_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `activity_date` date NOT NULL, `heart_zone_type` varchar(1) NOT NULL, `heartratezone_id` bigint(20) unsigned DEFAULT...

    $177 (Avg Bid)
    $177 Avg Bid
    39 bids

    ...the result from the refcursor after i add the commit. e.g. script CREATE OR REPLACE PROCEDURE oureadata.pg_boweb_cms_category_update_v2(pid character, pcategoryname character varying, pwebcode character varying, porder numeric, pupdatedby character varying, pupdateddate timestamp without time zone, plang character varying, INOUT cresults refcursor) LANGUAGE plpgsql AS $procedure$ DECLARE cnt bigint; rtnCode char(1); BEGIN cresults := 'cur'; BEGIN update oureadata.CMS_CATEGORY set FCATEGORYNAME = pCategoryName, FWEBCODE = pWebCode, FORDER = pOrder, FUPDATEDBY = pUpdatedBy, FUPDATEDDATE = pUpdatedDate, FLANGCODE = pLang where lower(FID) = lower(pId); commit; end; OPEN cresults FOR VALUES ('stringresult�...

    $21 (Avg Bid)
    $21 Avg Bid
    4 bids

    BigInt constructor and toString considration data structure class Need A Division method and Module method for this project

    $130 (Avg Bid)
    $130 Avg Bid
    6 bids

    We are looking multithreading program with BigInt in Java and C++ I have attached my C++ file() and Java codes(). In C++ files, I couldn't increase while loop in line 284 ~ 345. I think I got a wrong method used to increase a Big Integer. In my Java codes, you can read my descriptions. As I discussed it, there are some problems to run multi-threads in some while loop between line 94 ~ 154 in file. Every code is working on the terminal mode, and you have to install Cygwin C++ compiler. 1. Purpose - to find the optimal bit size as below: T = A * B^X + R, ex.) 16402=1*2^14+18=1*4^7+18 if the bit size of T is 15 bits(16402), A=1(1bit), B=4(3 bits), X=7(3 bits) and R=18(5 bits), then total size will be 12 bits=1+3+3+5 for the optimal case

    $139 (Avg Bid)
    $139 Avg Bid
    5 bids

    ...clicks Logout. For this project, we can use the following db structure CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `firstName` varchar(255) DEFAULT NULL, `lastName` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `accountType` varchar(255) DEFAULT NULL, `billingAddress` varchar(255) DEFAULT NULL, `mobilePhone` varchar(255) DEFAULT NULL, `officePhone` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `notes` varchar(255) DEFAULT NULL, `createadBy` bigint(20) DEFAULT NULL, `modifiedBy` bigint(20) DEFAULT NULL, `createdDate` datetime DEFAULT NULL, `modifiedDate` datetime DEFAULT ...

    $131 (Avg Bid)
    $131 Avg Bid
    23 bids

    I need a quick vb.net web scraper that reads a list of domains from a mysql database than crawls those sites savi...web scraper that reads a list of domains from a mysql database than crawls those sites saving all html data into another table of the database. I have two mysql tables create table websites ( domain_name varchar(255), parse_type int(32), last_parsed datetime, domain_id bigint not null auto_increment, primary key(domain_id) ); create table links ( domain_id bigint, FOREIGN KEY (domain_id) REFERENCES websites(domain_id), url varchar(1024), last_parsed datetime, link_html TEXT, link_id bigint not null auto_increment, primary key (link_id) ); website table stores the domains, and the links table stores all the pages(url's)...

    $104 (Avg Bid)
    $104 Avg Bid
    12 bids

    I need a quick vb.net web scraper that reads a list of domains from a mysql database than crawls those s...scraper that reads a list of domains from a mysql database than crawls those sites saving all html data into another table of the database. I have two mysql tables create table websites ( domain_name varchar(255), parse_type int(32), last_parsed datetime, domain_id bigint not null auto_increment, primary key(domain_id) ); create table links ( domain_id bigint, FOREIGN KEY (domain_id) REFERENCES websites(domain_id), url varchar(1024), last_parsed datetime, link_html TEXT, link_id bigint not null auto_increment, primary key (link_id) ); website table stores the domains, and the links table stores all the pages(url's)...

    $155 (Avg Bid)
    $155 Avg Bid
    2 bids

    Looking to convert database from MariaDB to Percona Server! Whenever i tried to upload the database from the old hosting to a new hosting it shows me this error. Error SQL query: CREATE TABLE `wp_commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=Aria AUTO_INCREMENT=237 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PAGE_CHECKSUM=1 MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r...

    $24 (Avg Bid)
    $24 Avg Bid
    4 bids

    Implement a C (not C++) module that implements RSA. The module shall be suited for resource constraint environments (eg. small embedded devices), and shall not rely on any external large libraries such as libtom crypt. Also, code can not be copied from code which require license or in any other way prevents me from using the code freely. Using external implementations, such as "bigint" is fine, as long as the implementation does not come with a limiting license, eg. GPL is not accepted. The following is one example of code which looks suitable, although there may very weel exist many others. To demonstrate the RSA-module, a small demo program shall also be supplied, together with a makefile (etc

    $568 (Avg Bid)
    $568 Avg Bid
    20 bids

    I need a simple PHP script and good PostgreSQL cluster design to let me distribute database across multi servers , I want to achieve one million insert per second in the following table ``` CREATE TABLE sensor_log ( sensor_log_id SERIAL PRIMARY KEY, location VARCHAR NOT NULL, reading BIGINT NOT NULL, reading_date TIMESTAMP NOT NULL ) ``` What I need? 1- Good design of PostgreSQL cluster for High availability and performance 2- A PDF tutorial that explain how to setup servers and config PostgresSQL including hardware , operation system , file system , PostgresSQL configs and ... 3- A simple PHP script to show how to works and test the result When you bidding this project , Tell me how many server you think is needed for 1M insert per second ...

    $604 (Avg Bid)
    $604 Avg Bid
    13 bids

    I hav...images previously created should be combined into one gif image(like an animation). You have to download the database i created and test the python program you created, in order to be sure that it works. This process will show the spead of the 3 most popoular hashtags on a map. Preffered library: Basemap toolkit Type of the image: NASA ‘Blue Marble’ image Tweet table structure: id bigint NOT NULL, tweet_text character varying(300) NOT NULL, user_id character varying(50) NOT NULL, coordinates character varying(100), created_at character varying(100) NOT NULL, place character varying(100) NOT NULL, retweet_count integer NOT NULL, favorite_count integer NOT NULL, last_update timestamp without time zone, reply_count integer NO...

    $100 (Avg Bid)
    $100 Avg Bid
    2 bids

    ...return pos; } public Object get(Object name) { int pos = getPos((String) name); if (pos < 0) return null; String f = "string"; Object obj = (pos); if (obj == null) return null; ObjectInspector ins = ((StructField) (pos)).getFieldObjectInspector(); if (ins != null) f = (); switch (f) { case "double": return ((DoubleWritable) obj).get(); case "bigint": return ((Long) obj).get(); case "string": return ((Text) obj).toString(); default: return obj; } } So I made the code change to below public int getPos(String name) { // (name+()); Integer pos = (Integer) (()); if (pos == null) return -1; return pos; } public Object get(Object name) { int

    $30 (Avg Bid)
    $30 Avg Bid
    4 bids

    ...import two database in the new mysql with version 5.7.14: Static analysis: 3 errors were found during analysis. A comma or a closing bracket was expected. (near "`minutes`" at position 755) Unexpected beginning of statement. (near "6" at position 876) Unrecognized statement type. (near "NOT NULL" at position 879) SQL query: CREATE TABLE `wp_psp_post_planner_cron` ( `id` bigint(20) UNSIGNED NOT NULL, `id_post` bigint(20) NOT NULL, `post_to` text COLLATE utf8_unicode_ci, `post_to-page_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `post_privacy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email_at_post` enum('off','on') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off', `status` smallint(1) NOT ...

    $150 (Avg Bid)
    $150 Avg Bid
    12 bids