Find Jobs
Hire Freelancers

Create MYSQL Create queries from source code that has INSERT/UPDATE/DELETE/ETC

$10-15 USD

処理中
投稿日: 14年以上前

$10-15 USD

完了時にお支払い
I have lost my MYSQL install/create file to create all the database tables that are needed... Basicly, I have two files with about 200-300 MYSQL queries that have INSERT/UPDATE/DELETE/SELECT.. Alot are the same, but basically what I want you to do is get all the table values for each table found and make MYSQL create queries for me. [login to view URL]( "INSERT INTO widgets(server_id,data,received_date) VALUES(%u,'%s', unix_timestamp())", In this example, the table is WIDGETS, and the table values are server_id,data, and received_data.. there may be another queries with: [login to view URL]( "INSERT INTO widgets(server_id,data,received_date,final_data) VALUES(%u,'%s', unix_timestamp(),fdata)", Which means final_data will have to be added to that top query, you get me? Basicly find all the queries that are used, use the table names that are found, and find all the values used for each table, and give me MYSQL create functions. Try to aim for if its TEXT/INTEGER/ETC ... for unix_timestamp, use TEXT. So for the above example might be something like "CREATE TABLE widgets server_id INT, data TEXT, recieved_date TEXT, final_data TEXT)" ^^ Or however it is used to create! Depending on if thats all there is (you might find more fields for widgets in other areas, but there are only TWO files to look in.) For auto_increment, or keys, do not spend to much time on this unless you know. I will tell you however server_id for example IS auto_increment. but thats normally the case for IDS. Overall this is a very SMALL job. Thanks! ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform MYSQL, Windows
プロジェクト ID: 2938643

プロジェクトについて

4個の提案
リモートプロジェクト
アクティブ 14年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
See private message.
$12 USD 14日以内
5.0 (49 レビュー)
5.1
5.1
この仕事に4人のフリーランサーが、平均$11 USDで入札しています
ユーザーアバター
See private message.
$6.80 USD 14日以内
4.9 (26 レビュー)
3.6
3.6
ユーザーアバター
See private message.
$12.75 USD 14日以内
4.7 (9 レビュー)
3.2
3.2
ユーザーアバター
See private message.
$12.75 USD 14日以内
5.0 (3 レビュー)
2.5
2.5

クライアントについて

SWEDENのフラグ
Sweden
5.0
15
お支払い方法確認済み
メンバー登録日:10月 7, 2008

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。