256 Kilobytes

Databases > Programming

Type All Category DatabasesDiscuss database design and development, such as relational and NoSQL technologies like MySQL, MariaDB, and MongoDB. Tag Programming

Profile Photo - Some Guy

How to fix "Every derived table must have its own alias"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyImagine a table called purchases that records purchases made by customers at stores, i.e., it's a many to many, and the software needs to know which c... Univa,

Imagine a table called pu...

Sun, 05 May 2019 03:27:34 -07002 years ago1
🗨 1
🐏 0
👁 556
Profile Photo - Some Guy

How to fix "Operand should contain 1 column(s)"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyThis error can occur if you accidentally use commas instead of AND in the ON clause of a JOIN. FOR EXAMPLE: JOIN joined_table ON (joined_table.c... Univa,

This error can occur if y...

Thu, 18 Apr 2019 07:57:10 -07002 years ago1
🗨 1
🐏 0
👁 584
Profile Photo - Some Guy

What do I do "Access denied for user 'root'@'localhost'"? Help needed

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyTry out the following steps to overcome this issue: Find mysql related entries from system sudo find / -name mysql Remove all mysql related en... Univa,

Try out the following ste...

Fri, 12 Apr 2019 11:34:06 -07002 years ago1
🗨 1
🐏 0
👁 583
Profile Photo - Some Guy

Solve "trying to get property of non-object"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyYou're probably trying to get the value from an array with object syntax. Most database data is handled in arrays, not objects. If you are d... Hash Brown,

You're probably tryin...

Sun, 20 Jan 2019 18:29:51 -08002 years ago1
🗨 1
🐏 0
👁 529
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last ReplyIf you are getting this error while connected to a remote terminal via SSH (such as to a web host), there may be a non-root account that you are meant... August R. Garcia,

If you are getting this e...

Sat, 22 Dec 2018 08:22:52 -08002 years ago1
🗨 1
🐏 0
👁 381
Profile Photo - Some Guy

Solve "Column count doesn't match value count at row 1"?

Answers in Databases | By Some Guy

Published

Profile Photo - August R. Garcia

Last ReplyThis error can occur if you are missing If your insert statement does not specify the number of columns correct. Example of incorrect statement:... August R. Garcia,

This error can occur if y...

Thu, 20 Dec 2018 01:18:24 -08002 years ago1
🗨 1
🐏 0
👁 399
Profile Photo - Some Guy

ORA-00979: not a group by expression - solutions?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, ORA-009779 is a fairly straight forward error. You have not included any code so I'll have to explain what it's likely to be... I... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:36:33 -08002 years ago1
🗨 1
🐏 0
👁 420
Profile Photo - Some Guy

How to fix "unknown 'column name' in 'field list'"?

Answers in Databases | By Some Guy

Published | Last Update

Profile Photo - Hash Brown

Last ReplyHello, This is really easy, the column name you have refferenced (rabbit_name) does not exist. Check the spelling, or add the column to the tabl... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:22:55 -08002 years ago1
🗨 1
🐏 0
👁 378
Profile Photo - Some Guy

What is "mysqli_fetch_assoc"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, Firstly and most importantly, mysqli is dead. It's very easy to mess up and ship code with security issues. You should look at PDO (PHP... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:19:40 -08002 years ago1
🗨 1
🐏 0
👁 413
Profile Photo - Some Guy

Differences between primary keys and unique keys?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

For my new job, I need to use SQL but I&...

MoreFor my new job, I need to use SQL but I'm not that familiar with it. Could someone please explain the differences between primary keys and unique...
🗨 0
🐏 0
👁 331
Profile Photo - Some Guy
Profile Photo - Some Guy

I'm getting tossed an error that sa...

MoreI'm getting tossed an error that says "Fatal Error: call to undefined function mysql_connect()". Can somebody tell me how to solve this...
🗨 0
🐏 0
👁 387
Profile Photo - Some Guy

What is "mysqli_real_escape_string" in PHP?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I'm writing a program for a class p...

MoreI'm writing a program for a class project. I'm writing PHP for the program and I can figure out a code. I don't know what "mysqli_...
🗨 0
🐏 0
👁 402
Profile Photo - Some Guy

Getting error "Mysql server has gone away"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I am setting up a new server for my busi...

MoreI am setting up a new server for my business and have been doing the SQL configuration to manage the data that our web app uses. Last time I started...
🗨 0
🐏 0
👁 334
Profile Photo - Some Guy

Fix "Tuple index out of range"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I'm running a simple python program...

MoreI'm running a simple python program that will display the data from my SQL database in a tinter form and its stating the tuple index is out of ra...
🗨 0
🐏 0
👁 345