Where do I write my mySQL code

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Where do I write my mySQL code

Postby Webgirl » 07. February 2009 00:30

Where do I write my code in Xampp e.g.

mysql> CREATE DATABASE books;

Please help for Im confused :oops:

Another dumb question

SQL-Befehl:

mysql > CREATE DATABASE books

MySQL meldet:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> CREATE DATABASE books' at line 1
Webgirl
 
Posts: 8
Joined: 04. February 2009 21:21

Re: Where do I write my mySQL code

Postby Izzy » 07. February 2009 01:34

You are trying do everything the hard way because you will not read your previous posts and the replies first.
viewtopic.php?p=135194#p135194

Here is a tutorial that will perhaps be useful:
viewtopic.php?p=135246#p135246

Learn how to use the excellent forum search facility described here:
viewtopic.php?f=16&t=32670
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Where do I write my mySQL code

Postby Webgirl » 07. February 2009 02:17

but Im not using any Joomla just a new Database nothing more.
Webgirl
 
Posts: 8
Joined: 04. February 2009 21:21

Re: Where do I write my mySQL code

Postby Izzy » 07. February 2009 02:26

Webgirl wrote:but Im not using any Joomla just a new Database nothing more.
The link just demonstrates how to set up a database and is irrelevant whether using Joomla or simply doing what you want to do, create a database - and please read the whole of the post I linked you to not simply the topic title or your credibility will be seriously affected.
Izzy wrote:You can use the above method to create any database with any username with any password for any script you want in the future, so keep a copy of this procedure.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 7 guests