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 back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 18:01:29 2024 UTC