Top "Mysql" questions

How to execute raw queries with Laravel 5.1?

So I have this tiny query to run on my DB and it works fine in MySQL Workbench. Basically, a …

php mysql sql database laravel-5.1

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known

I download from https://github.com/luciddreamz/laravel Laravel for openshift then upload over my repository over github. This code …

mysql laravel laravel-5 openshift

Using "like" wildcard in prepared statement

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on …

java mysql jdbc prepared-statement

MySQL Workbench Edit Table Data is read only

When trying Edit Table Data in MySQL Workbench 5.2.37, its in read only mode. It is editable only if the table …

mysql mysql-workbench

Show all current locks from get_lock

Is there any way to select / show all current locks that have been taken out using the GET_LOCK function? …

mysql locking

mysql datatype for telephone number and address

I want to input telephone number in a form, including country code, extension create table if not exists employee( ` country_…

mysql types phone-number street-address

Checking for an empty field with MySQL

I've wrote a query to check for users with certain criteria, one being they have an email address. Our site …

php sql mysql null

Copy values from one column to another in the same table

How can I make a copy values from one column to another? I have: Database name: list number | test 123456 | somedata 123486 | …

mysql database

MySQL table is marked as crashed and last (automatic?) repair failed

I was repairing this table suddenly server hanged and when I returned back all tables are ok but this one …

mysql repair

How to store Emoji Character in MySQL Database

I am using Emoji character in my project. That characters are saved (??) into mysql database. I had used database Default …

mysql