php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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 Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
42 - 26 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Fri Mar 29 11:01:29 2024 UTC