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 4 months agoSun, 13 Jan 2019 04:21:55 -0800

Profile Photo - roxblade

Last Reply The 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... roxblade,

The GROUP BY is only used...

Tue, 05 Feb 2019 03:28:32 -0800 3 months ago
🗨
1
🐏
0
👁
105
Profile Photo - Some Guy

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

Answers in Database Development | By Some Guy

Published 5 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 3 months ago
🗨
1
🐏
0
👁
166
Profile Photo - Some Guy

How do I become a database developer?

Answers in Database Development | By Some Guy

Published 4 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 3 months ago
🗨
1
🐏
0
👁
97
Profile Photo - Some Guy

What are the 5 phases of SDLC?

Answers in Database Development | By Some Guy

Published 4 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 3 months ago
🗨
1
🐏
0
👁
108
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 3 months ago
🗨
1
🐏
0
👁
100
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
👁
83
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
👁
247
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
👁
99
Profile Photo - Some Guy

What is the difference between SDLC and waterfall model?

Answers in Database Development | By Some Guy

Published 4 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
👁
93
Profile Photo - Some Guy

How to have a LEFT JOIN only get row?

Answers in Database Development | By Some Guy

Published 4 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
👁
88
Profile Photo - Some Guy

What is DDLC in DBMS?

Answers in Database Development | By Some Guy

Published 4 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 4 months ago
🗨
1
🐏
0
👁
147
Profile Photo - Some Guy

What is the difference between delete and truncate?

Answers in Database Development | By Some Guy

Published 5 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
👁
94