256 Kilobytes

Database Development Answers

Type AnswersAsk and answer questions, if that is something that you want to do. Category Database DevelopmentContent about database related considerations and subjects in computer programming. Tag All

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

Regular indexes are basically irrelevant...

MoreRegular indexes are basically irrelevant if you need string matching within arbitrary positions in a string (rather than only at the start). The...
🗨 0
🐏 1
👁 257
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

This is the line that caused the error t...

MoreThis is the line that caused the error to be thrown: INSERT IGNORE INTO things (name, created_at, updated_at) VALUES ("Some String", 1563893034,...
🗨 0
🐏 0
👁 264
Profile Photo - Some Guy

Does GROUP BY remove duplicates?

Answers in Database Development | By Some Guy

Published

Profile Photo - Default

Last ReplyGROUP BY allows the only aggregation. If you want to remove all duplicated rows, use SELECT DISTINCT. But DISTINCT command also so slow for lar... Ali,

GROUP BY allows the only...

Tue, 28 May 2019 23:39:57 -07001 year ago1
🗨 2
🐏 0
👁 397
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyIf 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... August R. Garcia,

If you want to store arra...

Mon, 04 Feb 2019 14:09:39 -08001 year ago1
🗨 1
🐏 0
👁 687
Profile Photo - Some Guy

How do I become a database developer?

Answers in Database Development | By Some Guy

Published

Profile Photo - roxblade

Last ReplyI'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... roxblade,

I'll line-out the very ba...

Sun, 03 Feb 2019 11:33:59 -08001 year ago1
🗨 1
🐏 0
👁 367
Profile Photo - Some Guy

What are the 5 phases of SDLC?

Answers in Database Development | By Some Guy

Published

Profile Photo - roxblade

Last ReplyFirst off is the Requirement Capture and Analysis. This is where we collect requirements. Along with users, we also take into consideration the variou... roxblade,

First off is the Requirem...

Sun, 03 Feb 2019 09:35:48 -08001 year ago1
🗨 1
🐏 0
👁 348
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyYou 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... August R. Garcia,

You should be able to do...

Thu, 31 Jan 2019 21:13:44 -08001 year ago1
🗨 1
🐏 0
👁 344
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm getting an "ERROR 1170 (42000): BLOB/TEXT column 'some_column' used in key specification without a key length" error in M...
🗨 0
🐏 0
👁 366
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI’m working on a new query for pulling specific data and receive the error “Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Ba...
🗨 0
🐏 0
👁 1,102
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm trying to create a procedure but I'm getting an error that the procedure already exists, how can I solve this?
🗨 0
🐏 0
👁 444
Profile Photo - Some Guy

What is the difference between SDLC and waterfall model?

Answers in Database Development | By Some Guy

Published

Profile Photo - Some Guy

MoreI am having some problems with database development. What is the easiest way to understand the difference between SDLC and waterfall model?
🗨 0
🐏 0
👁 353
Profile Photo - Some Guy

How to have a LEFT JOIN only get row?

Answers in Database Development | By Some Guy

Published

Profile Photo - Some Guy

MoreI am process of developing database and I am on part where to address the issue of Left Join row. How to address this issue in the part of database de...
🗨 0
🐏 0
👁 326
Profile Photo - Some Guy

What is DDLC in DBMS?

Answers in Database Development | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyDefinitions: DBMS: Database Management System DDLC: Database Development Lifecycle For reference, DDLC does not refer to the Absolutely H... August R. Garcia,

Definitions:

Fri, 11 Jan 2019 18:49:06 -08001 year ago1
🗨 1
🐏 0
👁 468
Profile Photo - Some Guy

What is the difference between delete and truncate?

Answers in Database Development | By Some Guy

Published

Profile Photo - Some Guy

I am a little new at this and am unclear...

MoreI am a little new at this and am unclear on how functions actually work. I know delete deletes things, and truncate shortens things, but I do not get...
🗨 0
🐏 0
👁 345