What is diff b/w MYISAM and INNODB storage engine. and also
define the benifits and drawbacks of both storage engine
Answer / rajanikanth
1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.
Is This Answer Correct ? | 2 Yes | 0 No |
when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field
Is mysql a dbms?
How to convert numeric values to character strings?
What are mysql functions?
How many services is running in sql server?
What are the difference between now and current_date in mysql?
What is mysqlcommand?
Explain the difference between mysql and mysql interfaces in php?
How do you start and stop MySQL on Windows?
What is processlist in mysql?
What is difference between mysql_connect and mysql_pconnect?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?