i made a table in sql server 2000 and in a column i want to
add image path of a picture present in my hardisk... so
using insert statement how will i insert the path of the
image in the table??
Answer / anuj maheshwari
suppose your url is c://documents/image1.jpg.
1st on ur form , put one this property. "ecytype=mulipleform".
by this , u can upload your file on your destination. and
store your path in a one variable and put it into your
insert query. this is way to insert a path in a database.
| Is This Answer Correct ? | 9 Yes | 1 No |
Can we store images in mysql database?
How to start mysql server?
I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?
Explain MySQL optimization?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
What does tinyint mean?
What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
what programming language which is used for testing and developement in sql?
What is the difference between database and table?
What are date and time data types?
What are the 'mysql' command line options?
write a command to view the content of the table
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)