>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
On Sunday, 17. March 2002 05:52, Andreas Dau wrote:
> Hi There H
>
> Well, it's not really a mysql topic, but it's a bit connected to it. I
> have a website that uses frames. My php script retrieves data from a
> mysql database and displays it. My problem now is: each time that
> specific page loa
He didn't name a column 'column', he named a table 'column'. This may
have seemed reasonable given his application.
In any case, bad idea or not, his point is well-taken. It worked in one
place but not another. While column is a reserved word, the directions at
http://www.mysql.com/doc/L/e/Le
On Sun, Mar 17, 2002 at 12:28:35AM -0500, Lionlike wrote:
> Hi, I need a little help as I am a beginner with db things. I'm
> building a database for technicians and "help-desk" problems where
> technical problem tickets are stored in one table, and technicians in
> another. Really I have two
As usual, I am a newbie to MySQL. I have been studying the user manual and
Paul DuBois' book, MySQL. I have tried to run the scripts for "menagerie"
and "samp_db" on both a Windows 2000 machine and a Linux machine, both local
and remote with version 3.23.49a. I have used the command line and sever
On Sun, Mar 17, 2002 at 05:31:52AM +0100, Tozz wrote:
> Hey
>
> > Column is a mysql reserved word.
> > Just like desc or asc or tons of others.
> > See here:
> > http://www.mysql.com/doc/R/e/Reserved_words.html
> > Dan
>
> Then, imho I think its stupid that MySQL lets you create tables with
> re
Hi, I need a little help as I am a beginner with db things. I'm
building a database for technicians and "help-desk" problems where
technical problem tickets are stored in one table, and technicians in
another. Really I have two main questions. First, each problem may
have more than one tech
Hi, All
I updated JDBC Driver i maintained. :-)
http://www.t3-jpn.com/jdbc/jdbcmysql.html
[New Features for only JDK1.4 ]
Add New Property 'useNewIO' to use SocketChannel and DirectBuffer
with JDK1.4's New I/O API.
Please download gweMysqlJDBC_extra4.zip and set useNewIO t
Hi There H
Well, it's not really a mysql topic, but it's a bit connected to it. I
have a website that uses frames. My php script retrieves data from a
mysql database and displays it. My problem now is: each time that
specific page loads it first displays a white background, retrieves the
data and
Hey
> Column is a mysql reserved word.
> Just like desc or asc or tons of others.
> See here:
> http://www.mysql.com/doc/R/e/Reserved_words.html
> Dan
Then, imho I think its stupid that MySQL lets you create tables with
reserved words, but it stops you from making dumps. Still seems like a bug
t
Here's how I fixed the compile problem with gcc 3.0.4 and mysql (3.23.49)
which resulted in the undefined symbol __cxa_pure_virtual error (tested
on Solaris 2.6 and 8).
The suggestion of setting CXXLD=g++ is right, but unfortunately, configure
ignores it; both client/Makefile.in and sql/Makefile.
Column is a mysql reserved word.
Just like desc or asc or tons of others.
See here:
http://www.mysql.com/doc/R/e/Reserved_words.html
Dan
-Original Message-
From: Tozz [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 16, 2002 8:58 PM
To: [EMAIL PROTECTED]
Subject: MySQL tables named 'colu
Hello,
While reading my cron messages I found out that the mysqldump returns with
an error
mysqldump: Can't get CREATE TABLE for table 'column' (You have an error in
your SQL syntax near 'column' at line 1)
The table column is:
CREATE TABLE `column` (
`id` int(11) NOT NULL default '0',
`nam
>Description:
REGEXP and LIKE operators in SELECT statements will NOT
do case-insensitive queries in VARCHAR() and BLOB text
columns.
E.g.
SELECT * FROM article_database WHERE article_preview LIKE '%a%';
'%a%' LIKE 'What is a CPU?' -> 0
Hi mailing list,
I can't start mysqld-nt as I get the eror message 1067. If I start
winmysqladmin.exe there is no server visible.
The manual tell me in part 2.4 Post-installation Setup and Testing that I
should start the script ./scripts/mysql_install_db but this script is not
availabale (at all
On Saturday 16 March 2002 03:14 pm, you said:
> Hi,
>
> Just set a unique index on the right column and you won't have anymore
> duplicate in your table :)
>
> ALTER TABLE yourtable ADD UNIQUE(your_column);
>
> Regards,
>
You might also want to use "REPLACE INTO ..." rather than "INSERT INTO..." a
I tried the patch and it still failed. Sorry for long post, but hope it
may help.
Thank you.
Vlad.
The details:
$ uname -vr
2.4.7-10custom #12 SMP Mon Mar 11 00:54:16 CST 2002
$ gcc -v
Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.0.4/specs
Configured with: ../gcc-3.0.4/confi
Hi,
I just got this similar problem in mysql install. I fixed this by ignoring
the follow line in /etc/my.cnf :
socket=/tmp/mysql.socket
Hope this help you.
Hung Lam
- Original Message -
From: "Subbiah Nishant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 14,
At 11:13 AM 3/16/2002, you wrote:
>Hello,
>
>
>I have since several weeks a problem in mysql. I'm using the 3.23.42
>version on MacOSX.
>
>Sometime, the mysql does'nt respond any more to request made by my script
>(often PHP), and I have the following error : "Table 'mysql.db' doesn't exist".
>
In relational algebra, queries using the expression "for all" are usually
handled with the division operation. What is the equivalent of the
division operation in mysql (in sql, it's "where not exists B except A")?
-
Before
I apologize if this question has been asked in the past. I am looking to
implement a queueing layer similar to Oracle AQ for mysql. It uses a
feature called skip locks that allows you to run a statement like:
select * from table for update skip locked
I have been unable to locate this type of fe
SHOW PROCESSLIST
-Original Message-
From: Chip Wiegand [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 16, 2002 1:30 AM
To: [EMAIL PROTECTED]
Subject: Finding out whos using the database
Is there a command that I can use to find out how many people, or more
specifically, who, is using
brikou writes:
> => I have just downloaded the "mysql++-1.7.1-win32-borland.zip"
>
> Please explain me how to install/configure it on borland c++ 5 (path and
> stuff like this)...
> I tried to do something but the easiest example doesn't seem to work.
>
> THANXS
Just follow instructions in READ
Hello,
I have since several weeks a problem in mysql. I'm using the 3.23.42
version on MacOSX.
Sometime, the mysql does'nt respond any more to request made by my script
(often PHP), and I have the following error : "Table 'mysql.db' doesn't exist".
The MySQL process is up, but it seems to do
Hi!
An: [EMAIL PROTECTED]
Kopie:
Thema: Remote access to MySQL
> Thomas, show me the output of following statement:
> SHOW GRANTS FOR 'your_user'@'your_host';
>
+--+
| Grants for @10.2.107.0/255.255.255.0
From: "phplist" <[EMAIL PROTECTED]>
> I've tried further, and still came up short. This time, if I use the % -
> it returns nothing.
Here's another way to do it, using PHP:
Organization: http://$url\";>$organizationGeographic Region:
$geographicDescription: $descriptionURL: http://$url\";>$urlS
=> I have just downloaded the "mysql++-1.7.1-win32-borland.zip"
Please explain me how to install/configure it on borland c++ 5 (path and
stuff like this)...
I tried to do something but the easiest example doesn't seem to work.
THANXS
From: "Alex Lui" <[EMAIL PROTECTED]>
> I am newbie in PHP/MySQL. I am going to write an application of PHP/MySQL.
I
> need one password table to do user authentication job. My application user
> will be given accounts for using MySQL with appropriate privileges. And,
I
> found table mysql.user w
Is there a command that I can use to find out how many people, or more
specifically, who, is using the database? I tried the mysql web site but
the search result are more irrelevant than relevant.
Thanks,
Chip W
www.wiegand.org
[EMAIL PROTECTED]
--
Hi All,
I am newbie in PHP/MySQL. I am going to write an application of PHP/MySQL. I
need one password table to do user authentication job. My application user
will be given accounts for using MySQL with appropriate privileges. And, I
found table mysql.user which is similar to my proposed passwo
Hi,
Just set a unique index on the right column and you won't have anymore
duplicate in your table :)
ALTER TABLE yourtable ADD UNIQUE(your_column);
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Craig Westerman" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED
Just in case you were wondering what the state of mysql version 4 is.
We're running a production site with a reasonably loaded MySQL 4.0
back-end. You can visit the site at http://www.workzoo.com/
The main motivation for mysql4 was the enhanced fulltext index support
which is awesome and rapidly
I have a db table that receives weather data several times a day via a php
script and cron job. Sometimes the data is duplicated for a certain time
window.
11:50 44 degree
11:50 44 degree
11:40 45 degree
11:30 46 degree
11:20 46 degree
11:10 45 degree
I do not want the du
What maximum columns can a table has in MySQL??
Thanks!!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-
Ed Carp ([EMAIL PROTECTED]) writes:
> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
> box, mysql will start, but connections to the database just hang.
> mysqldmin, etc. all hang also. /t
Dan Nelson writes:
> >Description:
>
> Tru64 5.1a is more strict than other versions of Tru64 when
> compiling a threaded program.
>
> extract of pthreads.h file on Tru64 5.1:
>
> /*
>* Enable reentrant errno.h. HOWEVER: this is here only to avoid breaking old
>* (an
Stefaan Contreras writes:
> Heya,
>
> I am quite new to all this intriguing stuff.
>
> I use mysql-3.23.47-win with MySqlGUI 1.7.5
> I see my mysql database, but cannot create tables in it.
>
> Any ideas?
>
>
> Kind regards,
>
> Stefaan
>
Hi!
MySQLGUI does not have that feature.
You may
Try a GNU 3 patch from MySQL++ page.
If that one fails, let me know.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
Hello!
I have table
++-+--+-+++
| Field | Type| Null | Key | Default| Extra |
++-+--+-+++
| id | int(11) | | PRI | NULL | auto_increment |
| date | date|
* John Hughes
> I have three tables:
>
> students has student_id and student_name
> parents has parent_id and parent_name
> parentlog has student_id and parent_id
>
> I want to search the parentlog WHERE student_id = some_id
> GROUP BY parent_id
>
> (This will bring back two rows when there are tw
adam,
Friday, March 15, 2002, 9:47:03 PM, you wrote:
an> I don't see how to submit 'blahblah;;' using the quotes.
an> I've tried
an> mysql -u root
an> and then typed all the conceivable combinations for password
an> and
an> mysql -u root --password=blahblah;;
an> and
an> mysql -u root --password=
Thomas,
Friday, March 15, 2002, 11:03:25 PM, you wrote:
TS> I want to access various databases on a MySQL server remotely. I've set up
TS> an entry in the "mysql.user" table to allow access to mysql for all hosts
TS> in subnet 10.2.107.0/255.255.255.0. First this worked fine. Then my server
TS> m
Mark,
Friday, March 15, 2002, 5:45:40 PM, you wrote:
M>Description:
M> Downloaded recently & installed via RPM. Ran mysql_install_db
M> Executed safe_mysqld, but fails. Below is an excerpt from log file.
M> 020315 09:25:31 mysqld started
M> 020315 9:25:31 /usr/libexec/mysqld:
On Saturday, 16. March 2002 09:26, David McInnis wrote:
> I think that I saw a similar query last week some time but I cannot
> remember the sql syntax. Is it possible to insert from a select.
See http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Regards Georg
--
- Original Message -
From: "David McInnis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 16, 2002 3:26 PM
Subject: Insert from select
> I think that I saw a similar query last week some time but I cannot
> remember the sql syntax. Is it possible to insert from a sel
I think that I saw a similar query last week some time but I cannot
remember the sql syntax. Is it possible to insert from a select.
Something like
insert into table_a from select * from table_b where blah=somevalue
Thanks,
David McInnis
---
46 matches
Mail list logo
