php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #19995 duplicate statements in SQL
Submitted: 2002-10-19 15:47 UTC Modified: 2002-10-19 20:23 UTC
From: blueblower0 at hotmail dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.3 OS: Win2000
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: blueblower0 at hotmail dot com
New email:
PHP Version: OS:

 

 [2002-10-19 15:47 UTC] blueblower0 at hotmail dot com 
This is what happens now with version 2.3.2 when I try to create a new table with 2 fields "foo" and "baz" on an existing database. I also get duplicates in other situations but this one speaks for itself?

Error
SQL-query :
  
CREATE TABLE `test` (

`foo` TINYINT NOT NULL ,
`baz` VARCHAR NOT NULL ,
`foo` TINYINT NOT NULL ,
`baz` VARCHAR NOT NULL 
) 

MySQL said: 
You have an error in your SQL syntax. 

Well, I can understand why there's an error.
Has anyone got the same problem?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-19 20:23 UTC] sniper@php.net 
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PHP.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Mon Apr 28 10:01:29 2025 UTC