256 Kilobytes

Database Development

Type All Category Database DevelopmentContent about database related considerations and subjects in computer programming. Tag All

Profile Photo - Some Guy

Does GROUP BY remove duplicates?

Answers in Database Development | By Some Guy

Published 6 months agoSun, 13 Jan 2019 04:21:55 -0800

Profile Photo - Default

Last Reply GROUP 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 -0700 1 month ago
🗨
2
🐏
0
👁
180
Profile Photo - Some Guy

Best method to store an array in a MariaDB/MySQL database?

Answers in Database Development | By Some Guy

Published 7 months agoThu, 06 Dec 2018 22:55:02 -0800

Profile Photo - August R. Garcia

Last Reply If 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 -0800 5 months ago
🗨
1
🐏
0
👁
272
Profile Photo - Some Guy

How do I become a database developer?

Answers in Database Development | By Some Guy

Published 6 months agoSun, 13 Jan 2019 04:22:05 -0800

Profile Photo - roxblade

Last Reply I'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 -0800 5 months ago
🗨
1
🐏
0
👁
161
Profile Photo - Some Guy

What are the 5 phases of SDLC?

Answers in Database Development | By Some Guy

Published 6 months agoSun, 13 Jan 2019 04:22:15 -0800

Profile Photo - roxblade

Last Reply First 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 -0800 5 months ago
🗨
1
🐏
0
👁
169
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last Reply You 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 -0800 5 months ago
🗨
1
🐏
0
👁
163
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
👁
151
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
👁
420
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
👁
162
Profile Photo - Some Guy

What is the difference between SDLC and waterfall model?

Answers in Database Development | By Some Guy

Published 6 months agoSun, 13 Jan 2019 04:22:25 -0800

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
👁
154
Profile Photo - Some Guy

How to have a LEFT JOIN only get row?

Answers in Database Development | By Some Guy

Published 6 months agoSun, 13 Jan 2019 04:21:45 -0800

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
👁
146
Profile Photo - Some Guy

What is DDLC in DBMS?

Answers in Database Development | By Some Guy

Published 6 months agoFri, 11 Jan 2019 18:48:34 -0800

Profile Photo - August R. Garcia

Last Reply Definitions: 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 -0800 6 months ago
🗨
1
🐏
0
👁
213
Profile Photo - Some Guy

What is the difference between delete and truncate?

Answers in Database Development | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:27:17 -0800

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
👁
149