Top "Mysql" questions

Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)

I am reading up on transactions in MySQL and am not sure whether I have grasped something specific correctly, and …

mysql sql transactions

How to enable mysqlnd for php?

I have PHP installed and running (version: 5.3.17) and I want to switch to mysqlnd (in the phpinfo mysqlnd does not …

php mysql linux yum mysqlnd

PHP MYSQL UPDATE if Exist or INSERT if not?

I have no idea if this is even remotely correct. I have a class where I would like to update …

php mysql sql-update sql-insert on-duplicate-key

Fetch only one row in PHP/MySQL

Possible Duplicate: mysql_fetch_array() expects parameter 1 to be resource, boolean given in select simple question here. I have a …

php mysql database fetch

MySQL case sensitive query

This has been asked on this site before but I couldn't find a sufficient answer. If I'm doing a query …

mysql case-sensitive

What does it mean when MySQL is in the state "Sending data"?

What does it mean if the Mysql query: SHOW PROCESSLIST; returns "Sending data" in the State column? I imagine it …

mysql

How can I rename column in laravel using migration?

I have columns as mentioned bellow: public function up() { Schema::create('stnk', function(Blueprint $table) { $table->increments('id'); $table-&…

php mysql database laravel migration

How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL)

I need help checking if a row exists in the database. In my case, that row contains an email address. …

php mysql mysqli pdo

Laravel 5.2 - Use a String as a Custom Primary Key for Eloquent Table becomes 0

I am trying to use email as my table's primary key, so my eloquent code is- <?php namespace App; …

php mysql laravel laravel-5 eloquent

Delete all rows with timestamp older than x days

I want to delete all the rows with timestamp older than 180 days from a specific table in my database. I've …

mysql sql-delete