Questions tagged as 'mysql'

Tagged questions
2
answers

Insert in multiple tables

I want to do the following insert in MySql CREATE PROCEDURE cadastroLocal (var_localNome varchar(80), var_horainicial TIME, var_horafinal TIME, var_periodoemminutos INTEGER, var_diasdasemana INTEGER) BEGIN INSERT INTO LOCAL (LOCAL.NOME...
asked by 16.10.2014 / 19:37
1
answer

How do I sign up for Moodle, and where is the data recorded?

I am developing a Moodle registration plugin which generates a bank account, but I have some doubts regarding the confirmation of the user's enrollment: What is the table responsible for enrolling a student in a course in Moodle? What woul...
asked by 17.09.2014 / 04:40
1
answer

CREATE DATABASE through a script in PHP?

How could I create a database every time a user, for example, if a company registers in my web system? Type, today, the only thing I have are administrative access data to FTP and database data as host, port ... How could within an administra...
asked by 02.09.2014 / 21:12
1
answer

Replication MySQL Database

I'm sketching an online project and need to ask a question about creating the database. I will have a COMPANY database containing the named reference and a code. From this bank COMPANIES I will want to generate a new database structure, bu...
asked by 02.09.2014 / 20:48
1
answer

Return only one item related to the main table

I have two tables, respostas and respostas_log , where I store information of the answers in answers and some others that have to go logging in replies_log. I need in my SELECT to bring only the last log of each response. Example...
asked by 13.05.2014 / 22:42
1
answer

Create 1: 1 relation in Query Browser

I would like to know how to create 1: 1 relationships in the Query Browser. I do not know if I'm right, but it creates 1: n relationships when creating foreign keys .     
asked by 08.03.2014 / 04:42
1
answer

How to delete MySQL database news?

In this link teaches you to list comments (in my case news) using external database (project download). How can I delete a news item when selecting, and still have a Dialog appear asking if I want to delete the news from the external databa...
asked by 11.03.2014 / 19:40
1
answer

How to change a charset from a table to utf8 in a latin1 database?

I am trying to change the charset from a table to utf8 in a BD that contains all the other tables as latin1swedish. I have run several commands and says that it has changed, it shows that that table is the only one like utf8, but any insertion k...
asked by 03.04.2014 / 22:32
1
answer

Problems with data modeling with Persistence.xml

I created a college application to create automatic tables by Hibernate with JPA but it gave some error in some tables, which were these; Catalog OrderDAO ProductDAO but is generating the following error, When I click on Catalo...
asked by 25.09.2014 / 01:13
1
answer

CakePHP does not show special characters present in the contents of the database

I get something like: Produ��es - Casamento Catarina & Lu�s _ Caves Taylor�s But what was expected was to get: Produções - Casamento Catarina & Luís _ Caves Taylor's This only happens with data coming from the database, which i...
asked by 15.04.2014 / 18:45