praveena mani
Last Activity: Dec 6 '07, 07:08 AM
Joined: Sep 13 '07
Location:
-
-
Can u provide me more details on this!!... -
Sending E-mails through MySql
I have a table where i enter the students details.
Whenever we insert a row in this table, a mail should be sent to the student for the student to verify the details entered.
The email id is already stored in the table.
How to implement this using mysql?
[CODE=MYSQL]
create table s_details(
SELECT_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
REF_NUMBER VARCHAR(20),
REG_NO VARCHAR(20),... -
Yeah.. Wat are the advantages of storing it separately???...Leave a comment:
-
Storing addresses in separate tables in a database
What are the advantages of storing addresses of students or customers in a separate table in database? -
it is working in the sense the query is ok..
but x is always displayed as 0....Leave a comment:
-
[code=mysql]
CREATE PROCEDURE view_select
(coll INT(11))
BEGIN
DECLARE x INT;
set x=0
SELECT course_id,x:=x+ 1 FROM s_details;
end//
[/code]
this is what u asked me to do right?
but this gives an error.
if i remove the colon it is working...Leave a comment:
-
i even tried without a loop but that x=x+1 doesnt get incremented.
each time it is displaying zero only for x. Why?...Leave a comment:
-
I jus want to view the records what i ve entered in my table.
But with one more field added while displaying that is the serial number x.
I am getting the count of total number of records in the table into variable y.
So until x<y the loop should execute but it is not happening why?...Leave a comment:
-
it becomes infinite loop.
I want x to act like serial number for my table.
Everytime wen a record is displayed x shud be incremented by 1.
Can u pls help me to implement this?...Leave a comment:
-
Incrementing a variable in a loop.
[code=mysql]
create procedure view_select
(coll int(11))
begin
declare x int;
declare y int;
set x=0;
select count(*) into y from s_details where college_code=co ll;
while(x<y) do
select day_number,titl e,first_name,mi ddle_name,last_ name,
date_of_birth,e _mail,ref_numbe r,
date_of_entry_o f_details,cours e_id,x+1 from s_details;
set x=x+1;
end while;
end//... -
Can we insert null values in stored procedures?
Can we insert null values in stored procedures?
When we tried to insert null inprocedures its giving query ok...
But wen we try to display the values from table it shows empty set...
Y??? -
default value for Auto increment
how to specify a default value for auto increment??
for innodb engine.. -
thanx..
it helped me alot..Leave a comment:
-
yeah,how to insert values for this table?
jus gimme an example to insert values..Leave a comment:
-
Inserting values into a table with two timestamp fields
how to insert values in this table for these two timestamps???
[code=mysql]
create table s_details(
SELECT_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
TITLE varchar(4) NOT NULL,
FIRST_NAME varchar(20) NOT NULL,
MIDDLE_NAME varchar(20),
LAST_NAME varchar(20) NOT NULL,
DATE_OF_BIRTH date NOT NULL,
NATIONALITY varchar(20) ,
E_MAIL varchar(30) NOT NULL,
DATE_OF_ENTRY_O F_DETAILS...
No activity results to display
Leave a comment: