Questions tagged as 'mysql'

Tagged questions
1
answer

"No suitable driver found" in Java database connection

Well, I use eclipse and I'm trying to connect to a MySQL database with my project, my code, compared to other tutorials I found, is perfect, and that's it: package pack; import java.sql.*; import javax.swing.JOptionPane; public class Banco...
asked by 10.06.2014 / 01:49
0
answers

Problems adding action in Zend Framework 1

I'm having trouble adding a song that's contained in the album, so when I add a song it's already related to the album id. My problem is in the addMusic () method below: MusicasController: public function adicionarAction() { $forms...
asked by 18.07.2014 / 17:31
1
answer

I can not insert simple text into mysql with column text [duplicate]

I'm not able to do a simple update to a table that contains a TEXT column. I put a simple Spanish text however the sql returns me error saying that line is too large. But it is a very small phrase. Here is the error code: SQL query error...
asked by 17.06.2014 / 13:51
1
answer

Integrating articles into a slider

I'm working on an article slider, whose articles are in a database that can be deleted / added (CMS), everything is working perfectly, the database, and the slider. Now I just wanted to integrate the articles into the slider. Here is my code, wh...
asked by 13.03.2014 / 11:23
1
answer

Difference in performance in the creation of FK MySQL

Does anyone know if there is a difference in bank performance if I create the FKs before the other fields in the table or vice versa? I heard comments that it is ideal to always leave FK's as the first columns of the table, but I have not fou...
asked by 14.03.2014 / 21:13
1
answer

Delete a record after making a query?

Is there a way, after a query, to delete the result returned from a database? I have a message table (from, to, message) each time I consult should I delete the read message (s) read.     
asked by 02.12.2014 / 23:56
1
answer

Select Format yyyy-MM-dd HH: mm: ss in MYSQL table column

Date 2014-12-01 10:52:38 2014-12-01 10:52:14 2014-12-01 10:51:57 2014-12-01 10:35:34 2014-12-01 10:23:17 2014-12-01 10:22:18 2014-12-01 09:03:49 2014-12-01 08:53:51 I have this column with these dates and I need to do a select that filters...
asked by 26.01.2015 / 17:30
1
answer

Distribute applications with Mysql

Does anyone know how to distribute the application and mysql database together? I'm using Innosetup, until I can install mysql, start the service but when I connect it gives error saying that I can not connect. See the inno code: ; Script g...
asked by 22.01.2015 / 19:41
0
answers

Get information from another table

Good people, I have the following code: <?php require('../members/inc/config.php'); require('../lib/framework.php'); $author = $_SESSION['username']; if(!empty($_POST['news_title']) || !empty($_POST['news_message'])) { if(!empty($_POS...
asked by 22.01.2015 / 21:02
0
answers

I can not connect pod_mysql to Netware

I have a NetWare IA32 NLM 6 50 server, with Apache 2, PHP 5.0.5 and MYSQL 4. In php.ini I have already connected the PDO drivers, which are already built into PHP 5 and even then I can not communicate with MySQL: extension=pdo.so ext...
asked by 12.11.2014 / 15:53