what are the optimization techniques for Query optimization performance issues and faster execution of queries2 9499
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?10 35850
in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.1 2056
if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?2 2737
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command5 5024
how to find missing numbers between two order numbers; and dates ?1 4295
How to get full name of monthname ?4 5842
about join2 2233
about foregine2 1716
How to find out the second largest element from mysql table15 17627
How we can copy one table data into another table whose name same as table but in differ database8 11180
please give me the answer for this: query which generates the second highest integer in the table?8 3605
How many tables will create when we create table, what are they?5 5764
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
What are the method you will follow while sql installing
How can you get your MySQL root password, if you lost it?
What is RMS Migrations
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
How can you move the master database
using primary can we relate two table, with out foreign key?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
How to set the time zone for MySQL to particular country time?
what is mysql optimization in brief?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.