In PHPmysql language how can we update our previous
information.when update form open then we get our previous
information in textbox,checkbox,selct,radio button.How can
we show the information in checkbox,select menu,radio
button which is available in database?
Which one of the following is the correct way to select all
columns and all rows from "vtable"?
Choice 1
SELECT FROM vtable SELF JOIN vtable
Choice 2
SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = *
Choice 3
SELECT EVERYTHING FROM vtable
Choice 4
SELECT vtable.* WHERE vtable = vtable
Choice 5
SELECT * FROM vtable WHERE 1 = 1
how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me
Can anyone help me to create a good mysql database schema
with an example.
Thanks,
Sekar.jr
103
HOW TO FIND display the total number of weeks in the year
of 1998 IN EMP TABLE
60
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?
237
maximum size of a database in mysql?
65
How to set the time zone for MySQL to particular country
time?
309
how many fields can be updated using set in a mysql query?
39
what is mysql optimization in brief?
48
how we can find nth max salary from an employe table by
using my sql?
13
mazimum size of a database in mysql? when we create a table
then how many tables actually created? write there name?
25
How to enable or disable a row of a table using MySQL in
struts?
208
all the queries used in sql
223
How can you get your MySQL root password, if you lost it?
how many table created when we create a table in mysql?
39
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 ?