Top "Mysql" questions

CSV Export/Import with PHPExcel

Could you please guide me or provide me with some sample codes for performing CSV export and import using the …

php mysql csv phpexcel

Does MySQL index foreign key columns automatically?

Does MySQL index foreign key columns automatically?

mysql database indexing

How to program a MySQL trigger to insert row into another table?

I'm looking to create a MySQL trigger on a table. Essentially, I'm creating an activity stream and need to log …

mysql triggers lastinsertid procedures

How to change the mysql root password

I have installed MySQL server 5 on redhat linux. I can't login as root so I can't change the root password. …

mysql linux passwords redhat

Error in dropping a database in MySQL (can't rmdir '.\oro', errno: 41)

I can't delete a database from mysql. The error is like ERROR 1010 (HY000): Error dropping database (can't rmdir '.\oro', …

mysql phpmyadmin drop-database

How to group mysql rows with same column value into one row?

I have two tables, keywords and data. Table keywords have 2 columns (id, keyword), table data have 3 columns (id[foreign key …

sql mysql aggregate-functions

Authentication failed using method mysql_native_password

Trying to connect to MySQL on my web host, using Connector/Net C#/WinForms in Visual Studio 2012 Update 3, but getting …

c# mysql winforms visual-studio-2012 mysql-connector

Multiple inner joins with multiple tables

So I have four tables. Each table has a single id for the previous table id. So my in click …

mysql sql join inner-join

MySQL get the date n days ago as a timestamp

In MySQL, how would I get a timestamp from, say 30 days ago? Something like: select now() - 30 The result should …

mysql

MySQL: Creating a new table with information from a query

In MySQL, I would like to create a new table with all the information in this query: select * into consultaa2 …

mysql sql insert sql-update