Unknown column in field list using Mysql Error

Question

when i testing the sql code i got the error of #1054 - Unknown column '321sa' in 'field list'how to retify that what i trid so far i attached below

INSERT INTO member (mno,pname,dob,eperson,relationship,ephone)
    VALUES         (2323,321sa,dasda,sadas,asdas,33333)
MySQL said: Documentation

#1054 - Unknown column '321sa' in 'field list'

need to quote (with `'....'`or `"...."`) your string values. — Barbaros Özhan, Dec 13 '20 at 15:08
$stmt = $conn->prepare("INSERT INTO member (mno,nic,pname,dob,eperson,relationship,ephone) VALUES (?,?,?,?,?,?,?)"); $stmt->bind_param("sssssss",$mno,$nic,$pname,$dob,$eperson,$relationship,$ephone); — hari dran, Dec 13 '20 at 15:10

score -1 · Accepted Answer · edited Dec 13 '20 at 15:27

-1

what operation are you trying to perform? also heres a hack Enclose any string to be passed to the mysql server inside single quotes; e.g.:

$name = "my name"
$query = " INSERT INTO mytable VALUES ( 1 , '$name') "

edited Dec 13 '20 at 15:27

RiggsFolly

93,638
21
103
149

answered Dec 13 '20 at 15:06

opia austin

64
11

#1054 - Unknown column '321sa' in 'field list' what was a probelem – hari dran Dec 13 '20 at 15:07
ok saw a similar question try this https://stackoverflow.com/questions/23066782/unknown-column-in-field-list-error-with-mysql – opia austin Dec 13 '20 at 15:29

Unknown column in field list using Mysql Error

1 Answers1