256 Kilobytes

Database Development Comments

Type CommentsResponses to top-level threads. Category Database DevelopmentContent about database related considerations and subjects in computer programming.

Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

d

Mored
🗨 1
🐏 1
👁 3
Profile Photo - Default

Reply to Does GROUP BY remove duplicates?

Comments in Database Development | By Ali

Published

Profile Photo - Default

GROUP BY allows the only aggregation. If...

MoreGROUP BY allows the only aggregation. If you want to remove all duplicated rows, use SELECT DISTINCT. But DISTINCT command also so slow for lar...
🗨 2
🐏 0
👁 458
Profile Photo - roxblade

Reply to Does GROUP BY remove duplicates?

Comments in Database Development | By roxblade

Published

Profile Photo - roxblade

The GROUP BY is only used for aggregatio...

MoreThe GROUP BY is only used for aggregation. It groups contents by arguments. To combine the duplicate rows, I'd suggest using the SELECT DISTINCT comma...
🗨 2
🐏 0
👁 458
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

If you want to store array and/or object...

MoreIf you want to store array and/or object data as a string (i.e., in a single DB field), it is possible to encode it as JSON: http://php.n...
🗨 1
🐏 0
👁 802
Profile Photo - roxblade

Reply to How do I become a database developer?

Comments in Database Development | By roxblade

Published

Profile Photo - roxblade

I'll line-out the very basic necessities...

MoreI'll line-out the very basic necessities to become a database developer. You need to learn SQL and be proficient in MySQL. A bachelor's degree is very...
🗨 1
🐏 0
👁 419
Profile Photo - roxblade

Reply to What are the 5 phases of SDLC?

Comments in Database Development | By roxblade

Published

Profile Photo - roxblade

First off is the Requirement Capture and...

MoreFirst off is the Requirement Capture and Analysis. This is where we collect requirements. Along with users, we also take into consideration the variou...
🗨 1
🐏 0
👁 404
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

You should be able to do this:

MoreYou should be able to do this: INSERT INTO post_tag (post_id, tag_id) VALUES ( (SELECT id FROM posts WHERE name="Some Fucking Post&quo...
🗨 1
🐏 0
👁 398
Profile Photo - August R. Garcia

Reply to What is DDLC in DBMS?

Comments in Database Development | By August R. Garcia

Published

Profile Photo - August R. Garcia

Definitions:

MoreDefinitions: DBMS: Database Management System DDLC: Database Development Lifecycle For reference, DDLC does not refer to the Absolutely H...
🗨 1
🐏 0
👁 536