is it possible to format a powerbook g4 mac? like totally erase the HD then pop in the Mac OS cd and it will boot up an install like windows or any linux? (5 Replies)
Hi Again Guys ,
Please i installed linux RH 6.1 on Toshiba , 10G , RAM=128 , 600 MHZ .
After i installed linux i got many error messages , seems it was not installed correctly , also when i finished installation it did not ask me for the 2nd installation CD , and when i logged as root , i... (5 Replies)
I have next part of script:
for i in $LIST
do
echo "`date +"%H:%M:%S"` Converting $i ...";
mysql -uroot some -sABe "ALTER TABLE $i ENGINE=$ENGINE";
done
I want to get following output formatting:
"OK" must be one under another :)
... (3 Replies)
I have file with different columns
for ex.
contents of file "txt"
NAME AGE MARKS
HARRY 23 89
TOM 12 67
BOB 23 11
and you see its not formatted.Now, I need the file "txt" to be formatted like
COLUMN1 COLUMN2 COLUMN3
NAME AGE ... (3 Replies)
Hello,
I am developing a platform Independant tool that should work for all major unix flavors outlined in this forum(Solaris,Linux, AIX, HPUX, SCO,BSD)
Therefore, in order to cover all types of user community, I have deliberately posted the same message on every forum. Please do not think... (9 Replies)
I need to format a txt file and convert it in CSV.
Any "future" column is separated by a newline.
FROM:
XS1
1.43294
0.0
XS2
1.21824
0.0
TO:
XS1,XS2 (2 Replies)
Hi Guys,
i have report that runs every 10 min and send the report of failed jobs to my mail.
Currently i am using a command like this to send mail.
mailx -t -s "FAILURE JOBS IN HYDRA $temp_date" addressee@domain.com < temp_file5
But i am getting mail in this format ....... (4 Replies)
Good day All,
I have requirement where my input data looks like below
] Message5
Expecting Output as
04/MAR/2104 ||| 23:15:45 ||| servername ||| NOTIFICATION |||message1||||||userId|||||| Message5
I could not use space delimiter as in the messages I would be having them as... (2 Replies)
Hi, I am new to UNIX and need your help in formatting the below input command to the desire output
Input:
CREATE UNIQUE INDEX XPKTABLE1
(
COL1,
COL2
) ON TABLE_NM;
Output:
COMMENT ON TABLE DB_NM.TABLE_NM AS 'PK=,COL1,COL2; ';
In... (14 Replies)
Discussion started by: varun2327
14 Replies
LEARN ABOUT PHP
mysqli_sqlstate
MYSQLI_SQLSTATE(3) 1 MYSQLI_SQLSTATE(3)mysqli::$sqlstate - Returns the SQLSTATE error from previous MySQL operation
Object oriented style
SYNOPSIS
string$mysqli->sqlstate ()
DESCRIPTION
Procedural style
string mysqli_sqlstate (mysqli $link)
Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no
error. The values are specified by ANSI SQL and ODBC. For a list of possible values, see http://dev.mysql.com/doc/mysql/en/error-han-
dling.html.
Note
Note that not all MySQL errors are yet mapped to SQLSTATE's. The value HY000 (general error) is used for unmapped errors.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)RETURN VALUES
Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no
error.
EXAMPLES
Example #1
$mysqli->sqlstate example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* Table City already exists, so we should get an error */
if (!$mysqli->query("CREATE TABLE City (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.
", $mysqli->sqlstate);
}
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* Table City already exists, so we should get an error */
if (!mysqli_query($link, "CREATE TABLE City (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.
", mysqli_sqlstate($link));
}
mysqli_close($link);
?>
The above examples will output:
Error - SQLSTATE 42S01.
SEE ALSO mysqli_errno(3), mysqli_error(3).
PHP Documentation Group MYSQLI_SQLSTATE(3)