Database Archives - Page 6 of 44

Database, Programming

IT Nursery

How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn’t seem to ...

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

Database, Programming

IT Nursery

What is sharding and why is it important?

I think I understand sharding to be putting back your sliced up data (the shards) into an easy to deal with aggregate that ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Find nearest latitude/longitude with an SQL query

I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

MYSQL OR vs IN performance

I am wondering if there is any difference with regards to performance between the following SELECT ... FROM ... WHERE someFIELD IN(1,2,3,4) SELECT ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL Delete all rows from table and reset ID to zero

I need to delete all rows from a table but when I add a new row, I want the primary key ID, which ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL case sensitive query [duplicate]

This question already has answers here: How can I make SQL case sensitive string comparison on MySQL? (12 answers) Closed 3 years ago. ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Detect if value is number in MySQL

Is there a way to detect if a value is a number in a MySQL query? Such as SELECT * FROM myTable WHERE ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

How to start MySQL server from command line on Mac OS Lion?

I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the ...

May 31, 2022
0 Comments