How to use an OUT paramter / read data with SELECT from table in a MySQL procedure

MySQL
I am new in creating procedures in MySql and still learning it. So, I am stuck in creating procedures and need help. The question might seem basic but...
1 year ago

How to get at most two entries for each name in the where clause

MySQL
What I'm trying to accomplish is select multiple values with a limit. SELECT id FROM table WHERE name IN ('Tom', 'Tommy') LIMIT 2 I understand this...
1 year ago

MySQL Utilities - ~/.my.cnf option file

MySQL
I am trying to use 2 of the mysql utilities, mysqldiff and mysqldbcompare and want to avoid putting my password on the command line Is it possible to...
1 year ago

The follwoing query give me MySQLSyntaxErrorException what is wrong with Qurey

MySQL
The following exception is thrown when ever i execute the following qury Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You ...
1 year ago

Codeigniter: Changing SQL query in model leads to a "failed to open stream" warning. Testing with a simple select * query works, however

MySQL
Database: MySQL version 5.6 hosted on remote server Codeigniter version: 3.0.6 on localhost PHP version: 5.5.9 I am working with a model, trying to b...
1 year ago

Why does rlike and like in this case give different results?

MySQL
I have two queries. select count(AlbumID) from album where albumname like '%[%]'; Result :15733 SELECT count(AlbumName) FROM album WHERE AlbumName...
1 year ago

mysql function is not working properly

MySQL
My database name is dfeb and I have a table named invdt and columns named batch_number,id .I want to get the batch_number where id=59, using a fu...
1 year ago

Some columns are hidden in phpMyAdmin

MySQL
I have about 11 columns in a mysql table and none of them are empty. When I view these columns in the Browse section, some columns are hidden whereas ...
1 year ago

mysql calculate percentage in select

MySQL
I have a basic voting system that collects votes. Tabulation should take total yes votes divided by total votes to determine if a 2/3rd majority is re...
1 year ago

mySQL: Get records union from same table

MySQL
I have 2 tables a car model and car parts. Both are related with a partfitment table whose only fields are the primary keys modelID and partID. I am ...
1 year ago

Subquery Syntax error for sql

MySQL
Hi i am trying to fetch data from two tables(products and issues) in PHP and MySQL. In issues table there is a column status which have four differen...
1 year ago

Increase pages with PHP and SQL with $_GET[""]

MySQL
Currently I am busy with a blog, but I get stuck at increasing pages, offset and limit. It is supposed to count up the page and show 10 rows at every ...
1 year ago

How can I use a foreign key and joins to get the info I need from mysql database

MySQL
I am currently achieving this with several steps, but it would be better if I could find what I need with one query. I think it's possible with joins ...
1 year ago

Can't login to with new passwrod to mysql console

MySQL
I am new o MySQL. I create a new user: CREATE USER 'geo'@'localhost' IDENTIFIED BY '12345'; GRANT ALL PRIVILEGES ON *.* TO 'geo'@'localhost' WITH GRA...
1 year ago

Getting the date and sending it through mysqli insert?

MySQL
Basically I've got a contact us form, and I would like to submit the date as well, when the submit button is pressed. Basically you fill out the boxes...
1 year ago

Displaying based on Results in Mysql Query

MySQL
I have an orders table in mysql and in that for some orders I set particular order status like 'review'. I want to setup a way if any order placed by...
1 year ago

Migration of MYSQL database without losing records

MySQL
I'm migrating a MYSQL DB from one host to another so I run the following command to backup the DB from the old hosting: mysqldump -u **** -p **** | g...
1 year ago

Count of joined items per group in MySql

MySQL
I need to get a set of results showing the number of items accumulated for each 'esta' group. I'm grouping the results by establishment. Establishm...
1 year ago

Update and Delete query for merging records

MySQL
I have a table with following records id | fname | lname | skills 22 | Jane | Doe | php,mysql 43 | Jane | Doe | java,oracle,php 45 | Jane | Doe...
1 year ago

Like % with many values in sql

MySQL
How to write the like% query with too many values in sql ? For example ,please see the table structure Id Tid name 1 1 test 2 3 ram 3 10 fe...
1 year ago