Top "Mysql" questions

How to split the name string in mysql?

How to split the name string in mysql ? E.g.: name ----- Sachin ramesh tendulkar Rahul dravid Split the name …

mysql sql

How to select only date from a DATETIME field in MySQL?

I have a table in the MySQL database that is set up with DATETIME. I need to SELECT in this …

mysql date

Repair all tables in one go

How to check all the tables in the database in one go? Rather than typing the query check table ''tablename''; …

mysql sql

Error installing mysql2: Failed to build gem native extension

I am having some problems when trying to install mysql2 gem for Rails. When I try to install it by …

mysql ruby-on-rails ruby rubygems mysql2

INSERT INTO...SELECT for all MySQL columns

I'm trying to move old data from: this_table >> this_table_archive copying all columns over. I've tried …

mysql select insert-into

How to change MySQL column definition?

I have a mySQL table called test: create table test( locationExpect varchar(120) NOT NULL; ); I want to change the locationExpect …

mysql alter-table

The SQL OVER() clause - when and why is it useful?

USE AdventureWorks2008R2; GO SELECT SalesOrderID, ProductID, OrderQty ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total' ,AVG(OrderQty) OVER(PARTITION …

mysql sql sql-server aggregate-functions clause

What does it mean by select 1 from table?

I have seen many queries with something as follows. Select 1 From table What does this 1 mean, how will it be …

mysql sql plsql

How to import data from text file to mysql database

I have a 350MB file named text_file.txt containing this tab delimited data: 345868230 1646198120 1531283146 Keyword_1531283146 1.55 252910000 745345566 1646198120 1539847239 another_1531276364 2.75 987831000 ... MySQL Database name: Xml_…

mysql import text-files

MySQL Query - Records between Today and Last 30 Days

I want to return all records that were added to the database within the last 30 days. I need to convert …

mysql date select