Questions tagged as 'mysql'

Tagged questions
1
answer

MYSQL access by an application

I am creating an application in C # this, it connects to a remote MySQL server, I have enabled for any IP to have access to my DB with a read-only user. My question is: Is there a way in the WebService to authenticate the user in a way that I...
asked by 03.06.2016 / 04:12
0
answers

How to write text and image together in mysql with asp.net mvc

I am creating a forum in my application and would like to know how to save image and text together in Mysql, as in the message field there will be a WYSIWYG editor so I will have to save both text and images, among others. What kind of field do...
asked by 03.06.2016 / 01:09
1
answer

How to create table relationships in mysql [closed]

I am starting with a relational database and I have difficulty relating tables, I am a layman in the field. I ask for help by indicating one / some clear and objective books on the subject. Thanks for the attention     
asked by 18.10.2016 / 14:45
1
answer

Procedure insert mysql

Good afternoon, I'm not able to create this procedure and I do not understand why, if you can help me. DELIMITER $$ CREATE PROCEDURE SP_INSERT_TB_ASS_TUR_AL(IN sp_id_disciplina INT, IN sp_id_aluno_prof INT, IN sp_id_turma INT, IN sp_id_aluno I...
asked by 03.06.2016 / 19:53
2
answers

Count number of people in a table separating by age, sex and company

I'm having trouble running a select where you have to bring the amount of people working in a company , separating by age strong>, age and sex . I've done the example below, but so far I have not been able to make it work, it ha...
asked by 01.06.2016 / 02:06
0
answers

How do I put data from a form in php into a HeidiSQL table

I have a contact form in php , where when we submit we send an email with the data entered. What I wanted was to insert this data into a table in the HeidiSQL program. Form Code: <div class="pagina" id="contactos"> &l...
asked by 21.06.2016 / 13:17
1
answer

No query executed factory registered for 'sql' language

In my project there are some reports and graphs, using DynamicReports that work correctly on IDE Netbeans without any error. However, through the command line running the java -jar MinhaAplicação.jar jar this Exception...
asked by 30.05.2016 / 19:01
0
answers

Problem transforming collected data into a json file

I'm trying to write to an .json file, information I collect from a database but for some reason nothing is written. Follow the code:      require_once('../helpers/connect.php'); require_once('../models/marks.php'); $marks = Mark::select($p...
asked by 08.06.2016 / 02:25
1
answer

PHP and Javascript - Tuning MySQL table lookup (Doctrine Query)

I'm doing on my page of my client, which I assumed from another developer, a section to search for events registered in the MySQL database. How is this page: <div id="detalhesBusca" class="textDescricaoSobre font13" style="display: none">...
asked by 08.06.2016 / 21:00
2
answers

Generate random name in MySQL - Stored Procedure

Good evening, is there any way to generate random names with stored procedures in MySQL? I have the following table:    ALUNO (id: int [PK], name (varchar (100)), age: int, Cr (float)) I need this table with 10mil entries popular. To gene...
asked by 20.05.2016 / 03:23