MySQL Archives - Page 4 of 38

MySQL, Programming

IT Nursery

Import SQL file into mysql

I have a database called nitm. I haven’t created any tables there. But I have a SQL file which contains all the necessary ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL – Get row number on select

Can I run a select statement and get the row number if the items are sorted? I have a table like this: mysql> ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How to change the CHARACTER SET (and COLLATION) throughout a database?

Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How to get database structure in MySQL via query

Is it possible to somehow get structure of MySQL database, or just some table with simple query? Or is there another way, how ...

June 1, 2022
0 Comments

MySQL, Programming

IT Nursery

How can I tell when a MySQL table was last updated?

In the footer of my page, I would like to add something like “last updated the xx/xx/200x” with this date being the last ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Add 2 hours to current time in MySQL?

Which is the valid syntax of this query in MySQL? SELECT * FROM courses WHERE (now() + 2 hours) > start_time note: start_time ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

How to find the mysql data directory from command line in windows

In linux I could find the mysql installation directory with the command which mysql. But I could not find any in windows. I ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Is there a REAL performance difference between INT and VARCHAR primary keys?

Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I’d like to use VARCHAR as ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

GROUP_CONCAT ORDER BY

I’ve a table like: +-----------+-------+------------+ | client_id | views | percentage | +-----------+-------+------------+ | 1 | 6 | 20 | | 1 | ...

May 31, 2022
0 Comments