Hi there i am having another issue with key constraints now, i emptied the tables and
made the foreign keys fine although now when i try and insert a row into the table i
get this
ERROR 1216: Cannot add or update a child row: a foreign key constraint fails
What could be the problem ?
--
MySQL
Hello,
I know I am asking a very silly question, but it's really bothering me for
quite a while:
I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The installation
shows no problem, and I can see that the 'mysqld' server is actually runing
through a command like "./bin/mysqladmin
If setting up apache on a local *nix box is more than what you need try
phpdev.
http://www.firepages.com.au/devindex.htm
~Jeff
- Original Message -
From: "Jakob Dölling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 12:31
Subject:
I worked out the problem, it worked if i emptied the table, what could that be all
about ?
>>> Daniel Rossi <[EMAIL PROTECTED]> 09/05/03 10:50am >>>
What is the definition of the constraint symbol there is no example of it in the docs ?
Also on a few tables i get errors trying to setup foreign k
Hi,
there is no acknowledgement when a table is created. You don't find out
about it until you turn off the gui and restart it.
Respectfully,
Ligaya Turmelle
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Hi all,
I'm trying to merge and existing list of 900-odd email-list subscribers
into an existing membership system.
The existing system uses the userid (eg "Justin") as the primary key.
Obviously, I don't have the leisure of asking 900-odd people what their
preferred userid is, so I've decide
In the last episode (Sep 04), Jerry Rasmussen said:
> I recently installed mysql 4 from source. After compiling everything I
> am unable to start mysql. This is the error I get in the log when I try
> to start mysql.
>
> 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find
> fi
MySQL 4.0 (the current stable brench) does not support subqueries.
This feature is present in the beta brench of MySQL, v4.1.
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries
Sincerily,
Leonardo Rodrigues
- Original Message ---
Hi,
I'm using MySQL 4.0.1 for Linux/Windows... I need to perform a query like this:
SELECT AVALIACAO, COUNT(AVALIACAO)
FROM AUDITORIAS
WHERE IDVERSAO = (SELECT MAX(IDVERSAO) FROM VERSOES WHERE DATA = '2003-08-23')
GROUP BY AVALIACAO
And its doesn't work in this version...
There is other way to
Hi Matthew,
Before I started using phpMyAdmin, I didn't want anything to do with it.
:-) But now I find it to be nice for quick things like browsing tables,
quick edits, table statistics, etc. For queries that return large
amounts of text, it's MUCH more legible than the command line. :-)
Keep in
I do not have a my.ini. I do have a my.cnf. Any other ideas.
On Fri, 2003-09-05 at 00:44, Martin Gainty wrote:
> did you look at datadir specification in my.ini?
> -Martin
> - Original Message -
> From: "Jerry Rasmussen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, Sep
I like it also, but of all things, I have trouble with the display on Internet
Explorer sometimes, strange only because everybody seems to write everything to be
IE compatible nowadays, and it hangs, so I use Mozilla on it and have never had a
problem. It makes some nice printouts of the table stru
did you look at datadir specification in my.ini?
-Martin
- Original Message -
From: "Jerry Rasmussen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 5:59 PM
Subject: MYSQL not starting
> I recently installed mysql 4 from source. After compiling everything
> SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments'
> which will show us the constraints for table departments..-Martin-
Apologies constraint was missing, this works
ALTER TABLE assets
ADD CONSTRAINT FOREIGN KEY (end_dateID) REFERENCES end_dates(end_dateID)
ON DELETE CASCADE
+-
Matthew:
Personally I prefer the shell - but I do have clients who's host providers
only allow phpMyAdmin - it is a pretty powerful interface - once you spend
about 10 mins in there it is pretty easy to use, and just remember that it
does have a raw sql 'field' that will let you run any query that
Hi all!
Here's a question for all my fellow geeks / coders / software engineers
/ curious DB admins.
I've been doing a lot of reading lately, and have noted a few things:
1. Out of the "big three" commercial databases, only Oracle seems to
support nested transactions. Is there any practical purp
SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments'
which will show us the constraints for table departments..-Martin-
Original Message -
From: "Daniel Rossi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 5:50 PM
Subject: Constraint Symbol
What is t
I recently installed mysql 4 from source. After compiling everything I
am unable to start mysql. This is the error I get in the log when I try
to start mysql.
030901 19:41:35 Fatal error: Can't open privilege tables: Can't find
file: './mysql/host.frm' (errno: 13)
I am trying to get this to r
What is the definition of the constraint symbol there is no example of it in the docs ?
Also on a few tables i get errors trying to setup foreign keys
ALTER TABLE departments
ADD FOREIGN KEY (departmentID) REFERENCES departments_join(departmentID)
ON UPDATE CASCADE
this for example gives me
Can
If I wanted to make a dictionary entry that would just provide a
sequential # starting at X and every time its used, it adds one... Is
this possible? How?
I do not quite understand the docs, but it seems like unique and
template has this ability.
Thanks,
Adam
Hi,
I need to move my site to a host that supports PHP and MySQL. I found a
nice deal that provides a lot of good stuff for an affordable price
(sitelutions.com is offering 5 MySQL databases, PHP support, cgi, etc etc
for $9.95/month).
There's only one problem--they don't allow you to edit the M
I'm not too familiar with this.. someone else today used the value 50,
when in fact based on their avg_row_length being reported as:
Avg_row_length: 2257832
Your average row length is reported as:
Avg_row_length = 20564
From: http://www.mysql.com/doc/en/CREATE_TABLE.html
AVG_ROW_LENGTH A
On 4 Sep 2003 at 16:54, Keith Bussey wrote:
> Thanks I will make new tables and transfer the data over =)
>
> Just wodnering though, any advice on how to tell what to set
> AVG_ROW_LENGTH to ?
Eh? Isn't that was I was saying 5.5 hours ago? This isn't anything
new. Here's the message again in
Darryl,
The following query would return all rows in employee that existed in emp2
(**Assuming 'employee' and 'emp2' have a common field 'key').
SELECT e1.* FROM employee AS e1, emp2 AS e2 WHERE e1.key = e2.key;
There is a great book that introduces SQL (SQL-1 and SQL-2 concepts) titled
"The
Thanks I will make new tables and transfer the data over =)
Just wodnering though, any advice on how to tell what to set AVG_ROW_LENGTH to ?
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting [EMAIL PROTECTED]:
>
> On Thu, 4 Sep 2003, Keith Bussey wrote:
> >
On Thu, 4 Sep 2003, Keith Bussey wrote:
> Running that shows me the following:
>
> mysql> SHOW TABLE STATUS FROM email_tracking LIKE 'email_body_old';
> ++++++-+-+--+---++---
Hi Mark,
I'm no Linux expert, but I think you would look at the difference
between the SIZE and RSS values in top (or the equivs. in other
progs...).
Also IIRC, from your first message, I don't think you're using a
full-text index in your query, are you? I think I saw column LIKE
'%word%' and no
Hi Kevin,
I imagine the query is examining/returning so many rows that it's going
to take a long time to create the needed temporary table (how long have
you it go?). To start with, show us the EXPLAIN output for the problem
SELECT, along with the SELECT. Also the size of the involved tables
(rows
I'd bump up these two settings.
innodb_buffer_pool_size=32M
innodb_additional_mem_pool_size=16M
I'm not sure what the max is on innodb_buffer_pool_size,
but that is where innodb caches data. The more that is in cache
means less disk reads which equals speed.
walt
K Old wrote:
>
> Hello ever
On 4 Sep 2003 at 16:10, Keith Bussey wrote:
> The MYI for that table is 1.7M, and no the text field isn't indexed
>
> Other table has all fixed-length records except 2 varchar fields
>
> Thus, if I understand right, then because the field is text it uses
> more pointers than a larger table t
Heikki,
There is not concunrrently running ANY queries on the table I am
ALTERing. In some cases I am the only person connected to the server.
Unfortunately I am not able to provide you with the proper test case
because this problem is not repeatable. Yes, I encounter this problem
very frequen
Quoting "Keith C. Ivey" <[EMAIL PROTECTED]>:
> On 4 Sep 2003 at 15:31, Keith Bussey wrote:
>
> > I do have another Database on the same machine which has a table that
> > is a lot bigger (about 9 GIGs) and it wasn't created with any of the
> > special table options suggested by Keith C. Ivey belo
Quoting Colbey <[EMAIL PROTECTED]>:
> Hrm.. interesting.. I know I've personally hit the 4gb limit before and
> had to do a fix for it.. but never hit an internal tablesize limitation..
>
> You didn't mention what version of mysql your running...
I mentioned in my original email ;p.4.0.13-
On 4 Sep 2003 at 15:31, Keith Bussey wrote:
> I do have another Database on the same machine which has a table that
> is a lot bigger (about 9 GIGs) and it wasn't created with any of the
> special table options suggested by Keith C. Ivey below.
Does the other table have fixed-length records (no V
Hrm.. interesting.. I know I've personally hit the 4gb limit before and
had to do a fix for it.. but never hit an internal tablesize limitation..
You didn't mention what version of mysql your running...
Also if the table has alot of columns and 1 of more of those columns has
alot of data, perh
[EMAIL PROTECTED] wrote:
> I'd recommend Apache, www.apache.org, but be aware that Windows OSes come
A "have to" for geeks and those who want to rely blindly on their software.
I think Nicola is better served with a search on Tucows or a similar portal
for http servers for non-geeks. 602Pro LanS
I do have another Database on the same machine which has a table that is a lot
bigger (about 9 GIGs) and it wasn't created with any of the special table
options suggested by Keith C. Ivey below.
The difference is this table has many more fields, while the email_body one (the
one with the problem)
Most likely it's the 4GB OS limitation... My suggestion is to create a
new table using mysql's built in raid option... span the table over
multiple files to allow of much larger table growth...
migrate all the rows over to the new spanned table..
On Thu, 4 Sep 2003, Keith C. Ivey wrote:
> O
> No, it turns out this is not the key. With mysql_connect() I'm
actually
> failing MORE often than with mysql_pconnect - so far it hasn't stayed
> up 15 minutes without error. (Fortunately, I have a cron job checking
> on it and restarting.)
After the failed connection attempt, there will be a
> Use transaction:
>
> begin
> update ...
> update ...
> ...
> update ...
> commit;
>
> This way you will only have a syncs to disk at every commit instead of
every
> update.
This won't help -- I'm not doing a batch process. Each update is coming
from a different connection...
--steve-
--
M
On Thu, 4 Sep 2003 13:57:53 -0500, Darryl Hoar <[EMAIL PROTECTED]>
wrote:
Joins can in fact be rather confusing at first. The MySQL manual doesn't
help out much, either, I'm afraid. There are lots of good references
available though. I don't know of any online right off hand, but _SQL
Queries
Greetings,
I am just trying to wrap my brain around joins.
I have a table employee. For each record in employee, I want to see
if a record exists in table emp2 based on a field value in both tables. IE,
for each employee
for each emp2
if employee.field1 = emp2.field3 then
do some
Hello everyone,
I am using a product that came packaged with Mysql 4.0.8-gamma and I
believe our configuration settings in my.cnf are too low and was wanting
a second opinion, and I'm aware of the my-huge.cnf file that comes
bundled with the mysql source and our variables are set way below the
my-
I also had table is full error, today
actually.
mysql> alter table mytable max_rows = 2000 avg_row_length=50;
mysql> show table status like 'mytable' \G
*** 1. row ***
Name: mytable
Type: MyISAM
Row_format: Dynam
In the last episode (Sep 05), Chris Nolan said:
> One of my clients has two applications running on SCO OpenServer (I
> said a naughty word...oh dear...) boxes. Personally, I have major
> personal and professional problems with this current arrangement and
> am trying as quickly as possible to move
Hi,
Have a look at:
http://www.mysql.com/doc/en/String_functions.html
You can find there functions to use in SELECT and WHERE clauses, like
UPPER(), LOWER(), SUBSTRING(), etc. and
http://www.mysql.com/doc/en/String_comparison_functions.html
for string comparison functions (LIKE, REGEXP, MATCH
Chris,
Wow, tell us how you really feel.
Less age is getting the better of me ISAM (indexed sequential access method)
tables are used by a few different DMS such as Informix. ISAM was original
developed by IBM. It allows data access sequentially or randomly via
indices.
Anyway, are you asking if
greetings,
When I am doing a select or update statement, I was wondering if there were
functions to compare strings. IE
Select * from employee,emp2 where uppercase(employee.fname)
matches(emp2.fname*)
that is to compare two fields from two tables and see if they match
regardless of whether
one i
Hello all,
I was wondering if any of you have ever added the MyODBC to a Cobalt raq4?
I have downloaded the RPM ( MyODBC-3.51.01.i386-1.rpm )
When I go to rpm the file I recieve the error below---
[root /JON]# rpm -ivh MyODBC-3.51.06-1.i386.rpm
error: failed dependencies:
i am attempting to compile libwrap support into mysql 4.0.14. my host is
rh7.2 with 2.4.18-18.7.x kernel. i am using gcc-3.3.1 to compile with. my
version of tcp_wrappers is 7.6-19. i was wondering if there was a version
incompatibility somewhere, or if there was somestep in compilation i was
missi
Teemu,
what kind of queries, if any, you are concurrently running on the tables you
are ALTERing?
"
030904 10:22:14 InnoDB: Warning: MySQL is trying to drop table
research/#sql2-4a4-1a8
InnoDB: though there are still open handles to it.
InnoDB: Adding the table to the background drop queue.
0309
On 4 Sep 2003 at 10:53, Keith Bussey wrote:
> Your suggestion seemed to wipe out my rows ! (s'ok I got a backup ;p)
Yikes! Are you running into any file system limits? Have you dealt
with files larger than 4 GB on that server before with no problems?
If not, you may have run into a MySQL bug
On Thursday, Sep 4, 2003, at 10:03 US/Eastern, Parker Morse wrote:
On Thursday, Sep 4, 2003, at 01:27 US/Eastern, Antony Dovgal wrote:
Please, read
http://www.php.net/manual/en/features.persistent-connections.php
I recommend you not to use *_pconnect. There are some big problems
with persistent c
Hi!
Try this:
SELECT TD.project_id, P.project_manager,
SUM( TD.time_hours_worked ) as hours
FROM time_daily TD
INNER JOIN projects P ON P.project_id = TD.time_project_id
WHERE TD.time_user_id = 'xpt'
HAVING hours <> '0.00'
Hope this helps!
On Wed, 2003-09-03 at 17:24, Cory Hicks wrote:
Dude ... You got the same name as me ...
So does that mean I can blame any idiotic
statements I make on you ?
We got a popular name.
Mike
-Original Message-
From: Michael Johnson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:51 AM
To: [EMAIL PROTECTED]
Subject: MySQL 4.1
This is the output from check table ArpMon;
mysql> check table ArpMon;
+--+---+--+-+
| Table| Op| Msg_type |
Msg_text|
+--+---+--+
I have a complex web application consisting of several programs totalling
about 100k lines of C code that has been running successfully under Linux.
To improve security, I want to port the application to MacOS X, where
considerably less effort goes into designing security breaches. When I try
com
I'd recommend Apache, www.apache.org, but be aware that Windows OSes come
with a personal version of IIS that can be used as a single server (i.e.,
no virtuals). Check Windows Components in Add/Remove Programs. The Apache
site has good documentation and some IIS info can be found in the Windows
he
Hi all,
At the moment, we all know that InnoDB does not yet have FULLTEXT
indexes. This is not another message asking as to when we will have that
functionality.
This message is different. On the mailing list for DBMail, we've been
discussing MySQL table types, with everyone highlighting the fact
I hope someone can help me on this. I've searched the mailing list
archives and the manual and can't find anything, except for user comments
in the manual that confirm what I'm finding.
I'm using derived tables users with restricted privileges. The only way I
can get the derived tables to work
Hi all,
One of my clients has two applications running on SCO OpenServer (I said
a naughty word...oh dear...) boxes. Personally, I have major personal
and professional problems with this current arrangement and am trying as
quickly as possible to move them away from these ancient things.
Interest
> I'm using InnoDB tables. I've set one of my fields to auto increment.
> This field has a relationship with another table. I need to
> reset auto increment back to 1 after it reaches the max value (And it
will).
A you sure about that last? If you use BIGINT (63 bits), at 1000 inserts
per second
Hi all!
Is anyone running MySQL on Linux kernel 2.6 or the kernel shipped with
RedHat 9.0? I am curious as to the impact of the new thread
implementation on MySQL's stellar performance (I like picking on the
Oracle, MS SQL Server and Foxpro admins that I have to work with. What
exactly is a Foxpro
Hi all!
Looking at one of the things that is set to be added to MySQL 5.0
(foreign keys for all table types), I have the following question:
Will we be able to have foreign keys that involve tables of different
types? Any early indications about the performance implications of
having such things
Hi -
I'm using InnoDB tables. I've set one of my fields to auto increment.
This field has a relationship with another table. I need to
reset auto increment back to 1 after it reaches the max value (And it will).
Does anyone know how I can do this ?
I basically need functionality similar to Oracle
On 4 Sep 2003 at 10:13, Keith Bussey wrote:
> -rw-rw 1 mysqlmysql4.0G Aug 31 01:01 email_body.MYD
>
> Thus if I try and insert one more row I get the error:
>
> ERROR 1114: The table 'email_body' is full
By default, MyISAM tables use 4-byte pointers to indicate positions
in t
Fraser MacLeod <[EMAIL PROTECTED]> wrote:
>
> I have set up mySQL 4.1 and everything seems to work fine. I have created a
> database, and populated it, queried it, etc. Now I would like to add spatial
> data (points, lines, polygons);
>
> Using a mysql client I am able to insert spatial values
I'm not sure it has to do with the number of rows, but in any case this is what
happened:
mysql> select count(*) from email_body;
+--+
| count(*) |
+--+
| 208853 |
+--+
1 row in set (0.00 sec)
mysql> alter table email_body MAX_ROWS=70;
Query OK, 315 rows affected (0
Hi there
##ERROR 2013: Lost connection to MySQL server during query ##
I get this error when i try to remotely connect to my mysql server, it
has been working until i changed the server's ip and isp, when i
re-change the mysql server to the old ip address (first isp), it's
working again .
When i do
Bom dia,
Fiz um arquivo de instalacao para o meu sistema usando o install shield e estou
com algumas duvidas qto a instalar a base de dados. Segue o que eu jah fiz:
(1) Meu script de instalacao vai replicar o diretorio "C:\mysql\bin" na maquina do
usuario
(2) Copiarah tb "libmysql.d
Actually I think it can be done, but I need some help on the hooks on MySQL
and the approval of Heikki...
The matter is that I can be an interesting mental exercise and I think that
it is missing to be a real 'de facto' world wide product.
Any help?
Leo.
- Original Message -
From: "electrot
Hi All,
I'm programming a method to delete a parent record and all its children
in a child table in one go. This is what I have:
UPDATE item i, category_item ci
SET i.date_deleted = ?, ci.date_deleted = ?
WHERE ci.item_id = i.item_id
AND ci.category_id = ?
and it works. But then I realised that
well, that'll teach me not to update my java api bookmarks to 1.4
the getGeneratedKeys() calls works like a charm!
Thanks for the help
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 02, 2003 4:09 PM
> To: Dan Greene
> Cc: [EMAIL PROTE
Hey all, I have a table with the following size:
-rw-rw 1 mysqlmysql4.0G Aug 31 01:01 email_body.MYD
Thus if I try and insert one more row I get the error:
ERROR 1114: The table 'email_body' is full
Now I'm wondering why this is and if there is any options ot increase max tab
On Thursday, Sep 4, 2003, at 01:27 US/Eastern, Antony Dovgal wrote:
Please, read
http://www.php.net/manual/en/features.persistent-connections.php
I recommend you not to use *_pconnect. There are some big problems
with persistent connections and these problems are 'by design'.
Use SQLrelay if you
Hi Jake,
I think I know what you mean, but it depends on how you access your db.
You want the metadata - in JDBC you would go something like this:
metaData = resultSet.getMetaData();
colName1 = metaData.getColumnName(1);
On 09/04/2003 02:50 PM Fortuno, Adam wrote:
I don't follow your question.
Thanks Paul, the options file worked fine!
Neil Belch
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Neil Belch" <[EMAIL PROTECTED]>; "mySQL List"
<[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 2:48 AM
Subject: Re: mysqlimport problems
> At 0:34 +0100 9/4/03,
hi,
i have built and installed mysql-4.0.14 to /usr/local/mysql and want to set
up initial grant tables now but mysql_install_db fails and I am lost.
What shall I do now?
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing column
Many... but try Xitami and Apache. They're great.
BTW, XP? Try SuSE, far better then Windoof.
--- Nicola Hartland <[EMAIL PROTECTED]> wrote:
> I am not sure this is the right place for this
> question but I am trying to find a personal server
> that I can install on my PC, I run XP that I
> I am trying to select the column names from a table to be displayed in a
> web page. Is there anyway to select column names without desc?
If you are using PHP, you can look at the following:
http://us4.php.net/manual/en/function.mysql-field-name.php
Chris
--
MySQL General Mailing List
For
MySQLd-nt (v4.0.14) is eating up all the available CPU resources on a
Windows 2000 server (dual 933 Pentium, 1GB RAM), with a maximum of 40
users so far. I have tried each combination of the default
configuration files, and each variety of the executable (nt, max-nt
etc.), and it's always the same
I am not sure this is the right place for this question but I am trying to find a
personal server that I can install on my PC, I run XP that I can have to test the web
pages. Does anyone have any suggestions and how to configure them.
thanks in advance
Nicci
"Gronquist, Jim M" <[EMAIL PROTECTED]> wrote:
>
> I can log into mysql using
>
> safe_mysqld --skip-grant-tables &
>
> mysql -u root -mysql
>
> The directions say that from mysql I should be able to manually execute
> the SQL commands in mysql_install_db
>
> and then run mysqladmin flush-privi
MySQLd-nt (v4.0.14) is eating up all the available CPU resources on a
Windows 2000 server (dual 933 Pentium, 1GB RAM), with a maximum of 40
users so far. I have tried each combination of the default
configuration files, and each variety of the executable (nt, max-nt
etc.), and it's always the same
I don't follow your question. Please elaborate.
Cheers,
Adam
-Original Message-
From: Jake Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 1:46 AM
To: Mysql
Subject: How can I select the column names?
I am trying to select the column names from a table to be displa
Hi i was wondering if there was ever going to be a time when Innodb can also
be fulltext indexable ? Being that i just started to work with Innodb and
cant believe how proper it feels of a relationional database over Myisam.
Like with Myisiam you cant set relationships up or is that going to change
Aki Karjalainen wrote:
Hi.
I've got a problem where I need to drop everything but numbers from a string and evaluate against it.
E.g. SELECT * FROM MYDATA WHERE DROP_ALL_LETTERS(MYSTRING) = '1254'
or
SELECT * FROM MYDATA WHERE REMOVESUBSTRINGS('A-Z', MYSTRING) = '1254'
10 points to the one whos k
Hi,
Unfortunately, nobody responded my mail. I am still trying to solve the
problem I described in my earlier mail (quoted below).
I am mailing again because I have some new information about the issue.
I converted all my tables to InnoDB (MyISAM -> InnoDB) and this solved
the problem. With In
Hi.
I've got a problem where I need to drop everything but numbers from a string and
evaluate against it.
E.g. SELECT * FROM MYDATA WHERE DROP_ALL_LETTERS(MYSTRING) = '1254'
or
SELECT * FROM MYDATA WHERE REMOVESUBSTRINGS('A-Z', MYSTRING) = '1254'
10 points to the one whos knows how to do a qu
Hello,
I am making a avatar chat you can see some of my work and I hope you could
help me in a small area that im needing help in which is making your client
and server to be able to split avatars such as like on www.habbohotel.com
you have one user with his / her own avatar and you have another us
You said --
I am trying to establish temporary tables that are accessible via MyODBC.
I can create the table with data in it and query it from the MySQL command
line, but it never shows up through MyODBC. Is there something magical
about temporary (memor
Hi there
##ERROR 2013: Lost connection to MySQL server during query ##
i get this error when i try to remotely connect to my mysql server, it
has been working until i changed the server's ip and isp, when i
re-change the mysql server to the old ip address (first isp), it's
working again .
when i
Creating Tables
The general attributes can be given for any column type, with a few
exceptions. You can specify NULL or NOT NULL to indicate whether a
column can hold NULL values. For all but BLOB and TEXT types, you can
specify DEFAULT def_value to indicate that a column should be assigned
the va
thanks for the valuable tips
sanjay gupta
- Original Message -
From: "Thierno Cissé" <[EMAIL PROTECTED]>
To: "'sanjay gupta'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 3:50 PM
Subject: RE: how to change default data directory
> Hi Sanjay,
> I see two wa
thanks for valuable tips
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 3:30 PM
Subject: Re: how to change default data directory
> "sanjay gupta" <[EMAIL PROTECTED]> wrote:
> >I am using RH7.1 box . I
Hi Sanjay,
I see two ways to proceed :
1 - after install, move or copy (with -R option) your actual datadir
under /var/lib/mysql
(that is to say all the directories located under /var/lib/mysql/*)
to /var1/lib/mysql,
and then modify in your my.cnf the variable
to correspond with the new d
I am trying to establish temporary tables that are accessible via MyODBC. I can
create the table with data in it and query it from the MySQL command line, but it
never shows up through MyODBC. Is there something magical about temporary
(memory-based) tables that prevents this?
I am running My
I am trying to establish temporary tables that are accessible via MyODBC. I can
create the table with data in it and query it from the MySQL command line, but it
never shows up through MyODBC. Is there something magical about temporary
(memory-based) tables that prevents this?
I am running My
1 - 100 of 115 matches
Mail list logo