Questions tagged as 'mysql'

Tagged questions
0
answers

Raise database [closed]

I have the classes in java each with their annotations made to persist, I have persistance.xml configured in that I have no problem, my problem is how do I connect it to the mysql database so that I can create the tables?     
asked by 22.09.2016 / 01:48
0
answers

Query in MYSQL takes 160 seconds to execute .. help please

This is the query in question, it's from a Wordpress theme SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.id = wp_postmeta.post_id) LEFT JOIN wp_options ON wp_options.option_name LIKE Concat('_...
asked by 11.09.2016 / 19:50
1
answer

Fail in sql query with or_like

I am creating an application for vehicle control with codeigniter 3.0. The SQL query I do is the following: MODEL private function dataParaProcedimiento($criteria){ $this->db->select( T_PADRON_NOMBRES ." as nombres,"....
asked by 31.08.2016 / 01:56
1
answer

Print Recursive Table - Idparent

I have the following BD: and what I want is to do a questionnaire in the following way: Question 1 Answer 1 Answer 2 Answer 3 Answer 4 Question 2 Answer 1 Answer 2 Answer 3 Answer 4 I'm trying with the f...
asked by 30.08.2016 / 00:34
0
answers

indirect direct relationship in database

In which cases you should use direct and indirect relationships when modeling a database. For example I have a case of this modeling,   uses direct (continuous lines) and indirect (non-continuous lines) relationships but when I export the...
asked by 09.08.2016 / 17:21
1
answer

When I save a form with nested_form_fields the console remains in BEGIN - Ruby on Rails

I need your help please. I can not create a new record with other nested records, because the console remains in BEGIN , that is, only the first query is output, which is the one that creates the main record, but never continues to insert...
asked by 22.08.2016 / 05:31
2
answers

Laravel | Problem with different cipher bcrypt

In the user registry I save the key with bcrypt, and in the authentication I make a return of the password and it gives me a different hash value of how the key is in the database, look: db key: $ 2y $ 10 $ 5HZ4raSDAB8WHJgG07yXU.1.9t2M / V3rt...
asked by 05.07.2016 / 21:11
1
answer

CodeIgniter PHP 404 not found

I have created a PHP record, to save the data of an HTML form, in a database. When I hit the save button I get "The page you requested was not found", I have no idea why. class Home extends CI_Controller { public function index() { // L...
asked by 02.08.2016 / 23:38
0
answers

Unable to connect to server 5 / Unable to connect to any of the specified MySQL hosts

Yesterday I applied a query: Update mytable set Column1='Value1' where Column='Value' and I do not know why strange reason I stop working the application only on my pc, since for other users it still works very well, now when trying to star...
asked by 26.07.2016 / 19:08
1
answer

Save report form

This form has been removing gray hair for a few hours and I can not find the reason why it is not saved. I have the following PHP code, which I use to save a form in the DB <?php session_start(); $conexion = mysqli("localhost","root",...
asked by 25.07.2016 / 02:33