I have a client database in my db dev server environment I need to
create, but the client name contains a dash "-". This blows up upon
attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx
Phil 5 2452
On Thu, 29 Jan 2004 09:54:11 -0800, Phil Powell wrote: I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx Phil
More information needed:
What database server are you using? (Assuming MySQL but you never know...)
--
Jeffrey D. Silverman | jeffrey AT jhu DOT edu
Website | http://www.wse.jhu.edu/newtnotes/
Phil Powell wrote: I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do
create database my-site;
If you are using MySQL, use:
create database `my-site`;
--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.
Official Google SERPs SEO Competition: http://www.koivi.com/serps.php
On Thu, 29 Jan 2004 09:54:11 -0800, Phil Powell wrote: I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx Phil
Assuming you mean MySQL...
More info: http://www.mysql.com/doc/en/Legal_names.html
What difference does it make to not use a hyphen? I mean, if the client
*wants* it that way is one thing, but databases are very "back end" and
may not ever be actually seen by the client. Just omit the hyphen is my
suggestion.
--
Jeffrey D. Silverman | jeffrey AT jhu DOT edu
Website | http://www.wse.jhu.edu/newtnotes/
"Phil Powell" <so*****@erols. com> wrote in message
news:1c******** *************** ***@posting.goo gle.com... I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx Phil
It may be like my server. I use CPanel and it appends the domainname to the
beginning of all databases created. e.g. domain_database .
So I would have to create a similar script to cause PHP to create a database
that added the underscore to the name with my domain before the underscore
on any db that I created.
"Shawn" <sh***@tsorland o.com> wrote in message news:<Wf******* ***********@big news3.bellsouth .net>... "Phil Powell" <so*****@erols. com> wrote in message news:1c******** *************** ***@posting.goo gle.com... I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx Phil
It may be like my server. I use CPanel and it appends the domainname to the beginning of all databases created. e.g. domain_database .
So I would have to create a similar script to cause PHP to create a database that added the underscore to the name with my domain before the underscore on any db that I created.
Actually I can't create any database much less a mySQL database with a
dash in it, so I gave up and had the sys admin literally make it for
me, with an underscore.
Phil This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Robert |
last post by:
I need some help with formatting some text received from a database
query. I am only selecting a single row per query so the formatting
will only be performed on a single row. The rows I need to format
upon display to the user are currently in text like so: word1 word2
word3 word4 (note there are only spaces between each word)
I just want to insert a character between each word when displayed. A
dash, for example. I want it to look...
|
by: Wayne Pierce |
last post by:
I have a small script with PHP that queries a MySQL database to pull
out one row, where I want to be able to access each of the columns
separately. I have tried several different variations and am able to
get the entire row to print, but when I attempt to access the
individual columns I get an error. Here is what I have so far:
if (isset($_POST)):
$link = mysql_connect('...','...','...');
mysql_select_db("...");
|
by: el_roachmeister |
last post by:
How can I correct this error apart from eliminating the dash in
United-Kingdom?
Couldn't execute query 'SELECT * FROM United-Kingdom ORDER BY level
DESC': 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 '-Kingdom ORDER BY level DESC' at line 1
|
by: Phil Powell |
last post by:
I have a client database in my db dev server environment I need to
create, but the client name contains a dash "-". This blows up upon
attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx
Phil
|
by: Darin Browne |
last post by:
I found the following email validation code in the newsgroup and it works great except it won't allow a dash in the name. I do not understand regular expressions so I'm unsure of how to fix it.
Can someone who understands regular expressions tell me what needs to be changed to allow a dash in the email name
public static bool IsValidEmailAddress(string sEmail
if (sEmail == null
return false
| |
by: mats.broberg |
last post by:
Dear all,
I'm having a scientific text translated into the majority of western
and eastern European languages* and have provided a small leaflet with
typesetting rules for the translators. Some translators protest that
this or that rule is not used in their respective language.
However, I think the majority of commercial translators are good at
translating, but don't know that much about typesetting. I see this
situation in Sweden...
|
by: sujith.bolar |
last post by:
This is IE issue only. Firefox and mozilla doe not have this problem.
td cell in a table with a title which includes '-'(dash). If I add a
dash between Time-Time. IE intrepets as new line os somethig and the
title is displayed in 2 line like:
Time-
Time
instead of Time-Time.
Below is snippet of the code.
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is this: can Access create
the document and place it as an OLE object to the relevant table?
Any help is greatly appreciated.
Ricky
|
by: =?ISO-8859-1?Q?=22Martin_v=2E_L=F6wis=22?= |
last post by:
"C:\Python24\Lib\site-packages\MySQLdb\cursors.py", line 149, in
Here it complains that it deals with the character U+2013, which
is "EN DASH"; it complains that the encoding called "latin-1" does
not support that character.
That is a fact - Latin-1 does not support EN DASH.
That's because your console uses the code page 437:
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |