ds20021205 2017-06-15 13:22
浏览 60
已采纳

将csv文件导入MySQL时,在创建表时更改数据类型 - PHP

In my previous question, I asked how to create table using backticks for my fields. Now our team decided to have computations to some of our .csv files when importing it to mysql. However, our default datatype is VARCHAR(500). Our table has an Amount column and we like that datatype to be INT. Can you give us hints on how to do it? Thank you.

Here's my code:

for($i=0;$i<count($data); $i++) {
    $f = strtolower(trim($data[$i]));
    if ($f) {
        // normalize the field name, strip to 20 chars if too long
        $f = substr(preg_replace ('/[^0-9a-z]/', '_', $f), 0, 100);
        $field_count++;
        $fields[] = $f.' VARCHAR(500)';
    }
}

$sqlcreate = "CREATE TABLE $table (" . implode(', ', $fields)  . ')';
echo $sqlcreate;
  • 写回答

1条回答 默认 最新

  • duannan3959 2017-06-15 13:34
    关注

    If you need to use a different column type based on the name of the column, you could use either an if/then or switch/case statement:

    for($i=0;$i<count($data); $i++) {
        $f = strtolower(trim($data[$i]));
        if ($f) {
            // normalize the field name, strip to 20 chars if too long
            $f = substr(preg_replace ('/[^0-9a-z]/', '_', $f), 0, 100);
            $field_count++;
            if($f == 'Amount') {
                $fields[] = $f.' INT(10)';
            } else {
                $fields[] = $f.' VARCHAR(500)';
            }
        }
    }
    
    $sqlcreate = "CREATE TABLE $table (" . implode(', ', $fields)  . ')';
    
    
    echo $sqlcreate;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 业务编程如何选择学习方向和内容?
  • ¥15 wamp3.3.5安装完成后图标正常显示绿色,鼠标左右键点击图标均无反应。求解决方法。
  • ¥15 鼠标点击的这条记录了什么?
  • ¥15 在写pid调速的程序时,电机始终维持最大速度
  • ¥15 【有偿】调用DXGI截图初始化失败,提示0xf 887a0004
  • ¥15 请问如何查看手机root记录?
  • ¥15 商城小程序订单号重复
  • ¥15 学校优化算法sbo和蚁群算法怎么结合
  • ¥21 matlab怎么求时域信号的二阶导数
  • ¥15 判断两个表是否完全相同