11-05-2010
Make sure your cells format fits the data format of your structure
Note that there are some DecimalSeparator in windows that may be considered depending on how MySQL does handle the conversion (or maybe MySql Does have its own config file?)
Search google with keyword : decimal separator and mysql data export import.
10 More Discussions You Might Find Interesting
1. Programming
Hi all,
Can anyone tell me a little about the datatype FILE, which represents stream. What does its structure look like, and in which header file is it defined and so on...
Ex :
FILE *fp ;
fp = fopen("filename", "w") ; (6 Replies)
Discussion started by: milhan
6 Replies
2. Programming
Hi,
I am trying to understand an very old C program.
....
time_t start, end;
ptr = localtime(&start);
...
fprintf(out, "%-35s 01 %5s %2s %10d 1 5 /tty/M%d/%02d %24s", buffer3, job, ver, start, mach_num,atoi(buffer), asctime(ptr));
fprintf(out, "%-35s 03 %5s %2s %10d 1 5... (9 Replies)
Discussion started by: whatisthis
9 Replies
3. Programming
I am writing some code to do analysis on the file system (HP-UX 11.11).
I am using stat(..) to get file information. My problem is that the file-size may exceed the data types defined in 'sys/stat.h' & 'sys/types.h' respectively.
Thus file-sizes in the Giga-byte range are not read correctly.... (2 Replies)
Discussion started by: ALTRUNVRSOFLN
2 Replies
4. Shell Programming and Scripting
I am using perl 5.8.0.
I need to check some values to see it they are floats. Our system does not have Data::Types so I can't use is_float. Is there something else that I can use? The only thing in Data is Dump.pm. I am not allowed to download anything to our system so I have to use what I have.... (3 Replies)
Discussion started by: ajgwin
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Newbie here. I have a file that consists of data that I want to convert to a csv file. For example:
Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105
Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Discussion started by: kangaroo
3 Replies
6. Shell Programming and Scripting
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL
when I split by
FS=","
then
$0=TEST_HEME
$1="SubNetwork=ONRM_RootMoR
$2=SubNetwork=ARNC1"
but I need this will be single value
"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1" (4 Replies)
Discussion started by: Hemendra
4 Replies
7. Programming
i'm using a C program and running it on a linux server, i got 2 adressess of 2 variables, and 2 addresses of 2 chars, and compared it. and got the size of a int and the size of a char.
why is a size of a int (4 bytes) bigger then the size of a char (1 byte)?
also if i do &a-&b i get 1, but if i... (30 Replies)
Discussion started by: omega666
30 Replies
8. Shell Programming and Scripting
OK, I am one needy dude. However, how can I make the program NOT change any of the values BETWEEN the first and second "," ?
I dont want any of the numbers changed that are preceded by "AT".
I want ALL other numeric values > 300 changed to 300.
cat qin.csv |head... (4 Replies)
Discussion started by: herot
4 Replies
9. Programming
This is from a program I wrote over in 1998 that I am trying to compile on a linux machine:
void write_line (FILE *fp, int rec_no, line_rec *arec)
{
fpos_t woffset;
woffset = (rec_no - 1) * sizeof(line_rec);
fsetpos(fp,&woffset);
fwrite(arec,sizeof(line_rec),1,fp);
}On the line... (2 Replies)
Discussion started by: wbport
2 Replies
10. Shell Programming and Scripting
I am extracting data via sql query and some of the data has commas. Output File must be csv and I cannot update the data in the db (as it is used by other application).
Example
table FavoriteThings
Person VARCHAR2(25),
Favorite VARCHAR2(100)
Sample Data
Greta rain drop on... (12 Replies)
Discussion started by: patk625
12 Replies
LEARN ABOUT PHP
mysqlnd_uh_convert_to_mysqlnd
MYSQLND_UH_CONVERT_TO_MYSQLND(3) 1 MYSQLND_UH_CONVERT_TO_MYSQLND(3)
mysqlnd_uh_convert_to_mysqlnd - Converts a MySQL connection handle into a mysqlnd connection handle
SYNOPSIS
resource mysqlnd_uh_convert_to_mysqlnd (mysqli &$mysql_connection)
DESCRIPTION
Converts a MySQL connection handle into a mysqlnd connection handle. After conversion you can execute mysqlnd library calls on the connec-
tion handle. This can be used to access mysqlnd functionality not made available through user space API calls.
The function can be disabled with mysqlnd_uh.enable. If mysqlnd_uh.enable is set to FALSE the function will not install the proxy and
always return TRUE. Additionally, an error of the type E_WARNING may be emitted. The error message may read like PHP Warning:
mysqlnd_uh_convert_to_mysqlnd(): (Mysqlnd User Handler) The plugin has been disabled by setting the configuration parameter
mysqlnd_uh.enable = false. You are not allowed to call this function [...].
PARAMETERS
o $MySQL connection handle
- A MySQL connection handle of type mysql, mysqli or PDO_MySQL.
RETURN VALUES
A mysqlnd connection handle.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.4.0 | |
| | |
| | The $mysql_connection parameter can now be of |
| | type mysql, PDO_MySQL, or mysqli. Before, only |
| | the mysqli type was allowed. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
mysqlnd_uh_convert_to_mysqlnd(3) example
<?php
/* PDO user API gives no access to connection thread id */
$mysql_connection = new PDO("mysql:host=localhost;dbname=test", "root", "");
/* Convert PDO MySQL handle to mysqlnd handle */
$mysqlnd = mysqlnd_uh_convert_to_mysqlnd($mysql_connection);
/* Create Proxy to call mysqlnd connection class methods */
$obj = new MySQLndUHConnection();
/* Call mysqlnd_conn::get_thread_id */
var_dump($obj->getThreadId($mysqlnd));
/* Use SQL to fetch connection thread id */
var_dump($mysql_connection->query("SELECT CONNECTION_ID()")->fetchAll());
?>
The above example will output:
int(27054)
array(1) {
[0]=>
array(2) {
["CONNECTION_ID()"]=>
string(5) "27054"
[0]=>
string(5) "27054"
}
}
SEE ALSO
mysqlnd_uh.enable.
PHP Documentation Group MYSQLND_UH_CONVERT_TO_MYSQLND(3)