Find Jobs
Hire Freelancers

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

$10-15 USD

En curso
Publicado hace más de 14 años

$10-15 USD

Pagado a la entrega
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 del proyecto: 2938643

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 14 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$12 USD en 14 días
5,0 (49 comentarios)
5,1
5,1
4 freelancers están ofertando un promedio de $11 USD por este trabajo
Avatar del usuario
See private message.
$6,80 USD en 14 días
4,9 (26 comentarios)
3,6
3,6
Avatar del usuario
See private message.
$12,75 USD en 14 días
4,7 (9 comentarios)
3,2
3,2
Avatar del usuario
See private message.
$12,75 USD en 14 días
5,0 (3 comentarios)
2,5
2,5

Sobre este cliente

Bandera de SWEDEN
Sweden
5,0
15
Forma de pago verificada
Miembro desde oct 7, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.