Questions tagged as 'mysql'

Tagged questions
1
answer

Know the latest price of Mysql products

I have a table of products where their characteristics are and another table "db_stock" where the activities of the products are managed. These activities may vary the purchase price or sale price of the products, even several times a day. I...
asked by 04.04.2017 / 12:57
2
answers

Compare two hours (TimeStamp) MySql Java

I must compare 2 hours one that is already registered from the database and the current time, I have been told that I can use the timestamp in MySQL make me return a true or false and minutes difference, then in java I should receive what retu...
asked by 21.05.2016 / 00:23
1
answer

PHP connection with DBISAM

For several days I have tried to connect to a DBISAM database but I have not managed it, download and install odbc driver and I do excel tests and it works perfect but when I try PHP it gives me an error, this is the script I'm using: <?php...
asked by 04.04.2016 / 21:26
2
answers

Reservations Classrooms with different time slots

the server must be able to reserve a classroom for 30 minutes, 1 hour or 1 hour and a half. The database: describes users; 'id','int(11)','NO','PRI',NULL,'auto_increment' 'username','varchar(64)','NO','',NULL,'' 'email','varchar(64)','NO...
asked by 13.05.2016 / 19:52
1
answer

How to make a query from a mysql meta query?

Suppose I want to get all the tables that have a column that is named 'name' . This can be easily achieved by using the 'information_schema' scheme provided by mysql . However, suppose I want to list all the names in the 'name' column of all...
asked by 21.04.2016 / 20:42
1
answer

MySQLSyntaxErrorException: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'latin1'

I am developing a login system with connection to a database of a client, but at the time of confirming the user and password send this error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: COLLATION 'utf8_bin' is not valid for CHA...
asked by 17.06.2016 / 19:17
1
answer

Configure PHP and MySQL - Database connection error (1): The MySQL adapter 'mysql' is not available

How can I solve this error? Database connection error (1): The MySQL adapter 'mysql' is not available. At the moment of loading the php.ini , it does not show me that it is loading the extension extension=php_mysql.dll extension=php...
asked by 15.02.2016 / 17:08
2
answers

No results using jQuery autocomplete and MySQL

The autocomplete of this code should show me the articles I have in a database of MySql , but every time something is written inside the text box it shows me no search result . I already verified that the connection data are corre...
asked by 08.06.2016 / 03:05
2
answers

MySQL: Function to determine if an ID exists

I need to do a mysql function that returns true if an id exists, I must send 3 parameters, name of the table, field name and value, if there is a record in that table that is identified with the value received in the specified field of the table...
asked by 12.09.2016 / 03:21
1
answer

Export Mysql Data with php

Greetings, I'm trying to export mysql data to an EXCEL using php, The problem I have is that when I try to export the data is not exported, that is, it shows the data on the screen again, but it does not give me the window to export .....
asked by 11.09.2016 / 09:57