Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                         SiteMap shows list of All Categories in this site.

Categories  >>  Software  >>  Databases  >>  MySQL        Suggest New Category      Question  Asked @ Answers Views     select   The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id  2  554 How can increase the performance of MySQL select query? Span-Systems   2  1095 How many ways we can we find the current date using MySQL?  4  1900 How can we find the number of rows in a table using MySQL?  1  1325 Explain Normalization concept? Inuva   1  1083 Give the syntax of Grant and Revoke commands?  1  1622 What is maximum size of a database in MySQL? V2-Solutions   9  5943 How many tables will create when we create table, what are they?  2  549 What are the other commands to know the structure of table using MySQL commands except explain command? SigmaTree   2  1187 How many values can the SET function of MySQL take? Creative-Informatics  2  1850 What is the maximum length of a table name, database name, and fieldname in MySQL? TISL   1  5760 What are the advantages of stored procedures, triggers, indexes?  2  3710 How can we repair a MySQL table? Infosys  2  1522 What?s the difference between query_cache_type 1 and 2?  1  1196 How do you prevent MySQL from caching a query?  1  1046 E-Mail New Answers        Answer Selected Questions        Post New MySQL Question   Prev    1   2   3   4   5    [6]   7   8   9    Next         Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions     MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions     DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions     SQL PLSQL Interview Questions     Databases AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   what is mysql optimization in brief? 46   what is the advantage of stored procedures, triggers and indexing in mysql 29   how many fields can be updated using set in a mysql query? 36   all the queries used in sql 223   how we can find nth max salary from an employe table by using my sql? 11   Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr 101   HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE 58   maximum size of a database in mysql? 61   how many table created when we create a table in mysql? 35   How can you plan the logshipping before processing? 182 ACC How to enable or disable a row of a table using MySQL in struts? 207   How can you get your MySQL root password, if you lost it? 261 PCS suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ? 159 ACC 1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used? 171 ACC 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? 236   mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name? 25   How to set the time zone for MySQL to particular country time? 309   Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools? 323 TCS E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com