Top "Mysql" questions

How to copy data from one table to another new table in MySQL?

I want to copy data from one table to another in MySQL. Table 1 (Existing table): aid st_id from_uid …

mysql copy

Doctrine - How to print out the real sql, not just the prepared statement?

We're using Doctrine, a PHP ORM. I am creating a query like this: $q = Doctrine_Query::create()->select(…

php mysql orm doctrine doctrine-query

How to connect to MySQL Database?

New to C# programming, I'd like to be able to access MySQL Databases. I know MySQL connector/NET and MySQL …

c# mysql nuget-package mysql-connector

How can I loop through all rows of a table? (MySQL)

I have a table A and there is one primary key ID. Now I want to go through all rows …

mysql loops

How to change collation of database, table, column?

The database is latin1_general_ci now and I want to change collation to utf8mb4_general_ci. Is there …

mysql collation

what is the difference between GROUP BY and ORDER BY in sql

When do you use which in general? Examples are highly encouraged! I am referring so MySql, but can't imagine the …

sql mysql database

How to do a batch insert in MySQL

I have 1-many number of records that need to be entered into a table. What is the best way to …

mysql sql database insert

How to add new column to MYSQL table?

I am trying to add a new column to my MYSQL table using PHP. I am unsure how to alter …

php mysql add alter

Increment value in mysql update query

I have made this code for giving out +1 point, but it doesn't work properly. mysql_query(" UPDATE member_profile SET …

php mysql sql sql-update

Best data type to store money values in MySQL

I want to store many records in a MySQL database. All of them contains money values. But I don't know …

mysql sqldatatypes currency