douzhaiya3968 2013-01-16 00:22
浏览 20
已采纳

插入具有不同列名的mysql和postgresql

I ported my application from mysql to postgresql. In doing so camel cased column names where changed to use an underscore as the word separator in most cases. There are a couple where the camel case was just removed.

I now need to insert to both of these databases. The data, the number of columns etc are the same just the column names are slightly different. I can use PDO to switch database drivers and insert, but id like to do this without writing two seperate sql statements for inserts. Is there a common way to map column names to array keys or populate some class and pass that to PDO.

  • 写回答

2条回答 默认 最新

  • dongrong9938 2013-01-16 00:32
    关注
    $column_names[] = array('someName'=>'some_name');
    $column_names[] = array('someOtherName'=>'some_other_name');
    $column_names[] = array('someOtherNameAgain'=>'some_other_name_again');
    
    foreach($column_names as $mysql=>$post_ogre)
    {
       //decide which one you want to use here
    }
    

    something similar to this should work

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 依据报错在原代吗格式的基础上解决问题
  • ¥15 在虚拟机中安装flash code
  • ¥15 单片机stm32f10x编写光敏电阻调节3.3伏大功率灯亮度(光强越大灯越暗,白天正常光强灯不亮,使用ADC,PWM等模块)望各位找一下错误或者提供一个可实现功能的代码
  • ¥20 verilog状态机方法流水灯
  • ¥15 pandas代码实现不了意图
  • ¥15 GD32H7 从存储器到外设SPI传输数据无法重复启用DMA
  • ¥25 LT码在高斯信道下的误码率仿真
  • ¥45 渲染完成之后将物体的材质贴图改变,自动化进行这个操作
  • ¥15 yolov5目标检测并显示目标出现的时间或视频帧
  • ¥15 电视版的优酷可以设置电影连续播放吗?