How do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date?
Latest Answer: For the configuration of MySql these dependencies are required as:mysql-5.0mysql-server-5.0mysqlclient9-5.0mysql-devel-5.0php-mysql-5.0install by rpm -i vh mysql-server-5.0.rpm and others also sameIf configured in RHEL the .rpm are needed.if configured ...
Latest Answer: There are five types of db engines MyISAM(default type),INNODb,BDB,Heap,Mearge,Temproray ...
Latest Answer: mysql 4.0 onwards support subquery ...
Latest Answer: mysql5 support view and procedure where as 4 is not support ...
Latest Answer: A trigger is a named database object that is associated with a table and that is activated when a particular event occurs for the table. For example, the following statements create a table and an INSERT trigger. The trigger sums the values inserted into ...
Latest Answer: mysql support all typ of join inner join outerjoin(alltype ) and self join ...
Can use rownum.If possible explain.regards,Joe
Latest Answer: it is pretty easy to delete dublicate rows using UNIQUE index on the table...the column on which you can find out duplicacy of records.Alter table xyz add unique index (col1,col2,...)on executing the query Duplicate keys are automatically deleted from ...
Latest Answer: ya that's rightdesc table is easy to useThink this way to desc a table,DB has to save the info some where right? its the information _schema DB where all the info related to Database or table is storedinternally desc will do the same as the below ...
Latest Answer: Make clear qus first ...
View page << Previous 1 [2] 3 4 5 Next >>
Go Top
