471,072 Members | 1,381 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,072 software developers and data experts.

mysql syntax error

red
I don't see why mysql is telling me the following is a syntax error:
create table articles
{ file char(30) not null
};
What is wrong with that ?

red
Jul 17 '05 #1
5 1715
red wrote:
I don't see why mysql is telling me the following is a syntax error:
create table articles
{ file char(30) not null
};
What is wrong with that ?

red


Use parentheses (), not curlies {}

create table articles
( file char(30) not null
);

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/
Jul 17 '05 #2
red wrote:
I don't see why mysql is telling me the following is a syntax error:
create table articles
{ file char(30) not null
};
What is wrong with that ?

red

Wrong braces. Use (), not {}

Steve
Jul 17 '05 #3
If you want an easy way to maintain your MySQL databases then try using
phpMyAdmin from http://www.phpmyadmin.net/

--
Tony Marston

http://www.tonymarston.net

"red" <gr*****@reenie.org> wrote in message
news:qS**********************@news.easynews.com...
I don't see why mysql is telling me the following is a syntax error:
create table articles
{ file char(30) not null
};
What is wrong with that ?

red

Jul 17 '05 #4
red
Tony Marston wrote:
If you want an easy way to maintain your MySQL databases then try using
phpMyAdmin from http://www.phpmyadmin.net/


Thanks everyone for the advice about the parentheses. I was reading from
a book, and I guess my eyes were fooling me.

I use phpmyadmin on my online server, but on my windows xp box, here's
how far I got with phpmyadmin:

http://www.zend.com/manual/faq.datab...ses.mysql.php5

"4. PHP 5 no longer bundles MySQL client libraries...
enable the extension php_mysql.dll inside php.ini"

I have the php_mysql.dll file in my php5 installation, and I know where
the php.ini file is. But I don't know what is meant by "enable the
extension" Can anyone please explain this ? Thanks.
Jul 17 '05 #5
red
red wrote:
Tony Marston wrote:
If you want an easy way to maintain your MySQL databases then try
using phpMyAdmin from http://www.phpmyadmin.net/


Thanks everyone for the advice about the parentheses. I was reading from
a book, and I guess my eyes were fooling me.

I use phpmyadmin on my online server, but on my windows xp box, here's
how far I got with phpmyadmin:

http://www.zend.com/manual/faq.datab...ses.mysql.php5

"4. PHP 5 no longer bundles MySQL client libraries...
enable the extension php_mysql.dll inside php.ini"

I have the php_mysql.dll file in my php5 installation, and I know where
the php.ini file is. But I don't know what is meant by "enable the
extension" Can anyone please explain this ? Thanks.


I finally figured it out.
in the php.ini file, remove the semicolon in front of
;extension=php_mysql.dll

It seems alot of people problems starting mysql in php5. I'll include my
experience in case it helps, although most people aren't as lost as I
am. Originally, I didn't figure this out because I was looking at the
php.ini in windows, which didn't have this line. Turns out my php.ini is
for php5 is in c:\php.

Also, I found http://www.faqts.com/knowledge_base/...html/aid/23162
helpful.

Jul 17 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Mario Ohnewald | last post: by
reply views Thread by google account | last post: by
13 posts views Thread by wideangle | last post: by
1 post views Thread by Ike | last post: by
5 posts views Thread by gsaray101 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.