Teddy112

Can anyone give a clear,short and simple explanation about database indexes?

my insert statement seems to be ignoring my unique index and adding duplicates what'd i mess up? thanks in advance Table CREATE TABLE `address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `address_street1` varchar(100) NOT NULL, `address_street2` varchar(100) DEFAULT NULL, `address_street3` varchar(100) DEFAULT NULL, `address_city` varchar(45) NOT NULL, `address_state` char(2) DEFAULT NULL, …

Hi, I am accessing a FTP over SSL server with port no 990 in Implicit mode on Linux through File Zilla client on windows.It is connected successfully but it is not listing the directory there and giving an error in logs "226 Transfer done (but failed to open directory).". Can …

hi guys, I have a question regarding databases which made me stuck in my recent interview. How we can identify unique records in any table without using any primary key or unique key ? Plz share your ideas... thanks

SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist.

Open the command prompt Click on the "C:\" icon beside "Command Prompt" on the title bar. Click on Default and then the Colors tab.