douyou9923 2014-04-08 17:56
浏览 65

如何将数据从一个表插入另一个表?

I have two tables named

newlab(Department_Name,Total_PC,MAC,Lab_Code,PC_Name,Purchase_Order_No,Brand,Model_Name,Price,Processor,Ram,HDD,HDD_Type,OS)

and

maintenance(Department_Name,MAC,Lab_Code,PC_Name,Purchase_Order_No,Brand,Model_Name,Price,Processor,Ram,HDD,HDD_Type)

I want to insert data from newlab to maintenance.

My code is

$sql = "INSERT INTO ` maintenance`(MAC,Lab_Code,PC_Name,Purchase_Order_No,Brand,Model,Price,Processor,Ram,HDD,HDD_Type)SELECT MAC,Lab_Code,PC_Name,Purchase_Order_No,Brand,Model_Name,Price,Processor,Ram,HDD,HDD_Type FROM `newlab` WHERE PC_Name='".$PC_Name."'";
$ress = mysqli_query($con,$sql);

if(!$ress)
{
    echo "Not done";
}

But the problem is that it always Outputs - "Not done". I want to know why the query is not executed.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#hadoop#的问题
    • ¥15 (标签-Python|关键词-socket)
    • ¥15 keil里为什么main.c定义的函数在it.c调用不了
    • ¥50 切换TabTip键盘的输入法
    • ¥15 可否在不同线程中调用封装数据库操作的类
    • ¥15 微带串馈天线阵列每个阵元宽度计算
    • ¥15 keil的map文件中Image component sizes各项意思
    • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
    • ¥15 划分vlan后,链路不通了?
    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据