The follow lines will
->list DBs
->allow to select one
->list tables under the selected DB
mysql> show databases;
mysql> use
mysql> show tables;
hope this helped!
-Original Message-
From: David Grant [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 12:21 PM
To: My SQL M
David Grant wrote:
> This is the error I receive. MySQL is working fine, but I need to know
> how get php working with sql.
This means your PHP was not compiled with MySQL support. Recompile PHP.
> Also, does anyone know the command to list all the db's? thanks.
show databases;
--
Hi
Very new to MySQL and just wondering if there is an alternative interface to the
command line. The beginners tutorial I am working through from WWW.Mysql.com seems to
do all tasks from the command line. This seems very cumbersome in modern times. I
understand there is a graphical interfa
Hi,
1. I am reading 'internals' list and I see some words about subselect in 'bk
commit into 4.1 tree' messages...
Seems like we can expect subselect in 4.1 branch !?? :)
2. When 4.0.2 beta will be released?
3. Seems like gcc 3.0 (or 3.1?) becomes an "official" recommended compliler
for mysql
I use exclusevely command line interface, and i believe most of the
programmers prefer command line interface over GUI.
As to large queries... just save them in yor files or use 'edit' command.
On Mon, 3 Jun 2002, Ehmer David wrote:
> Hi
>
> Very new to MySQL and just wondering if there is
"mysql support is not available to php on this server"
This is the error I receive. MySQL is working fine, but I need to know
how get php working with sql.
Also, does anyone know the command to list all the db's? thanks.
Dave
--
Hi
Very new to MySQL and just wondering if there is an alternative interface to the
command line. The beginners tutorial I am working through from WWW.Mysql.com seems to
do all tasks from the command line. This seems very cumbersome in modern times. I
understand there is a graphical interfa
On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote:
> Hello,
>
> in InnoDB tables in MySQL, if
> innodb_flush_log_at_trx_commit is set to 1, then on
> COMMIT, the buffer log is flushed to disk log...
Right.
> or the changes are reflected in the disk copy of the database??? i
> mean wh
Hello,
in InnoDB tables in MySQL, if
innodb_flush_log_at_trx_commit is set to 1, then on
COMMIT, the buffer log is flushed to disk log...or the
changes are reflected in the disk copy of the
database???
i mean what is flushed, the buffer-pool that contains
data and indexes or the log-buffer??
Tha
At 08:58 PM 6/2/2002, you wrote:
>What algorithm do ENCODE-DECODE functions use?
>
>
>--
>Best regards,
> Evgeny mailto:[EMAIL PROTECTED]
Evgeny,
Encode(),Decode() is for low level security. If you are trying to
store passwords use something like MD5() to creat
Anyone have any ideas on how to get MySQL to work under cygwin?
I'm especially interested in getting a libmysqlclient which is compatible
with cygwin so that I can use it to compile various other program which
require the library...
Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because I
Hi,
I'm having trouble trying to insert form data into a mysql db, the
thing is my client wants table data to be splitted, I mean some data
comes from the first form, and the rest from another form.
This is a portion of the php script.
// Add together proper fields to enter birth date
$fecha_na
Dave Rolsky wrote:
>Is there any programmatic way (SQL, C-level API) way to determine whether
>or not a given mysql server is running in ANSI mode or not?
>
>If not, this would be most helpful, as otherwise it is impossible to
>know how to quote identifiers (` or ").
>
>
>-dave
>
>/*=
Is there any programmatic way (SQL, C-level API) way to determine whether
or not a given mysql server is running in ANSI mode or not?
If not, this would be most helpful, as otherwise it is impossible to
know how to quote identifiers (` or ").
-dave
/*==
www.urth.org
we await th
What algorithm do ENCODE-DECODE functions use?
--
Best regards,
Evgeny mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Melvyn Sopacua wrote:
> Hi Mark,
>
> At 02:04 3-6-2002, Mark shared with all of us:
>
>> > Yes and no. I do want that, but afterwards I want to connect.
>>
>>
>> It still does not look to me like you really want to ping the server.
>> What
>> you seem to want is to check whether the server is al
Hi,
I didn't get that deeply into why exactly, but it seems that when I removed
the mysql database from the file, that the rest went fine with
mysql -u -p Hi.
>
>Which version of mysqldump did you use and what error message do you
>get?
>
>I have never used mysqldump this way but from what I read
Hi Gelu,
At 23:10 2-6-2002, Gelu Gogancea shared with all of us:
>I'm sorry ... i didn't read carefully you mail
No problem.
>Anyway, my opinion is that you should use(i don't know if is possible) the
>mysql_options to set time out.
That works if only mysqld is down and the machine is rea
Hi Mark,
At 02:04 3-6-2002, Mark shared with all of us:
> > Yes and no. I do want that, but afterwards I want to connect.
>
>
>It still does not look to me like you really want to ping the server. What
>you seem to want is to check whether the server is alive; and if not,
>reconnect; right?
Con
- Original Message -
From: "Melvyn Sopacua" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: "MySQL General" <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 10:27 PM
Subject: Re: mysql_ping()
> >So... you don't need mysql_ping ... unless if want to check periodical if
> >t
Hi.
On Fri 2002-05-31 at 09:19:38 -0400, [EMAIL PROTECTED] wrote:
> im missing the mysql and mysqladmin binaries after my admin guy installed
> the most recent stable mysql rpm on a (linux) machine. are these included in
> the "client" rpm that he may have missed or is there something "new" that
Hi.
If you want someone to consider answering your problem, you should
write in a manner that it is understandable what you want.
I.e. give a detailed description of what your requirements are and
what you have already considered and why it won't work. Also have a
look at the mailing list archiv
Hi.
Which version of mysqldump did you use and what error message do you
get?
I have never used mysqldump this way but from what I read in the help
of mysqldump 3.23.31, mysqldump should insert the necessary SQL
statements regarding changing and creating the databases (if they do
not already exi
Hi.
With MyISAM the table will be marked crashed and you have to repair it
(with myisamchk or REPAIR TABLE). In most cases this will simply
disregard the last change. There is a low probability that the table
is broken in a more serious way and you have to use your last backup
(you surely do make
Hi !!
uhh, this sounds really stupid to be honest :-)
My first thought is, If they are so deep in MS junk
why should they port to PHP/MySQL in the first place ??
I think it's definitely easier to give then a quick-course
in PHP than writing these kind of workarounds...
You could maybe write ano
What if the MySQL server crashes during an Insert or delete or update
statement, In what state would that leave the database, and would MySQL
recover? If so how would it do that?
If not what would happen, half of the statement would get executed before
the crash while the rest is not?
Would you pl
Hi Melvyn,
I'm sorry ... i didn't read carefully you mailPHP is great, if you can
create socket that mean you can send and receive.data.In fact simple_command
with COM_PING do the same thing.I suppose are some function in PHP for
handling data.From your code i see the "fsockopen" returning the
Mark,
- Original Message -
From: "Mark Hazen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, June 02, 2002 8:21 PM
Subject: Will we ever get 3.23.50 for Linux
> Monty said this on April 23, 5 1/2 weeks ago:
> If we don't get any fatal bug reports by the end of
Hi,
Just now i read carefully your previous maili don't know if is possible
to create a socket/used with PHP.
In principle a client socket it's some like this:
if ((sock=socket(AF_INET,SOCK_STREAM,0))<0) --create socket file
{
.perror("Can't create socket: socket()");
.exit(1);
Hold the phone - I've just realised that those tables 'missing' .ISM files are
actually supposed to be MyISAM - (I have complete MYD and MYI files) - not ISAM (ISM,
ISD) - how do I tell MySQL this is the case?
TIA (Again)
/Phil
On Sun, 02 Jun 2002 21:28:17 +0100
"Phillip Baker" <[EMAIL PROTE
Hello,
As I understood segmentation fault happens during compilation?
Segmentation fault happens always at the same point?
If not then it is a problem of your memory, try memtest86 to test your
memory (not your but your computer :) )
If it always happens at the same point than
Hi Gelu,
At 21:52 2-6-2002, Gelu Gogancea shared with all of us:
>Indeed, mysql_simple_command (with COM_PING command like argument ) is used
>by C API mysql_ping, to check connection.MYSQL struct it's used like
>handler.
>For a connection you must use in order:
>mysql_init(),
Hi,
In haste to change some server hardware I copied the /var/lib/mysql directory directly
assuming this would suffice in order to carry the data over. I'm pretty certain I
stopped mysqld, but regardless I now seem to be missing nearly all the respective .ISM
files for my databases.
Now, I'm
I have tried this 3 times so far everytime i do a 'make', after a
while, i get this message:
make[2] *** [my_net.lo] Segmentation fault
make[2] Leaving directory '/home/per0xide/mysql-3.23.49/libmysql'
make[1] *** [all-recursive] Error 1
make[1] Leaving directory ' /home/per0x
well yeah, but the people who are going to be using the databse don;t know
PHP and they want to edit the queries in Access, but still be able to access
it online, and if they change the queries in Acces, then it won't be changed
on the webpage (don't ask my why they want this, i'm just doing a jo
Hi,
Indeed, mysql_simple_command (with COM_PING command like argument ) is used
by C API mysql_ping, to check connection.MYSQL struct it's used like
handler.
For a connection you must use in order:
mysql_init(),-initialise MYSQL struct
mysql_options(),- option for c
Hi,
If you wish to write an server application ...i think, you can be interested
about how make settings for a socket (see "man 7 setsockopt")
But your problem it's so far from thati think, you changed some user
access rights and for this reason you can't connect to MySQL server.
Try mysql -u
At 19:53 2-6-2002, Gelu Gogancea shared with all of us:
>mysql_ping check connection to server.
>In documentation at "8.4.3.163 mysql_ping()" you can find more details about
>that.
Yeah right.
Did you actually take a look?
Reading the source gives me more information. I know it returns an intege
Hi,
mysql_ping check connection to server.
In documentation at "8.4.3.163 mysql_ping()" you can find more details about
that.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 01, 2002 8:56 AM
> To: [EMAIL PROTECTED]
> Subject: core dump, multithreading using MyODBC on Solaris
>
>
> Hello,
>
> I'm using MyODBC 3.5 on Solaris.
>
> From time to time I get
Hi,
I've got a function/method in php, where socket communication is used,
to determin if a host is live - however - there is drawback, because
it's being registered as an invalid connection and the host gets blocked.
Now - whether this is acceptable behavior (I can't turn the whole thing off,
w
>
> > INSERT INTO my_table VALUES (foo, foo), (bar, bar), (z, z)...
>
>From my own experience, by using this method, that is doing one insert per
200 or more rows I can increase the insert speed from between 5x - 10x. A
couple more performance improvements where made as well so that value isn
The MATCH syntax will return a number indicating the relevance of a
particular record to the specified criteria. I would like to generate
similar numbers for phrase searches... please read on.
I have written code which will generate an SQL query that allows phrase
searching (without using IN BO
Hello everyone.
I am trying to add non-Latin text to MySQL. Specifically speaking I need to
use Persian fonts.
I can add the text in the sql tables with no problem. I can also display
them on the generated cgi pages which call those tables. The problem I have
is when I go back to edit these tables
Hi,
first of all: I'm currently not reading this mailing list,
so if you answer I would be happy to receive a Cc:
I'm currently trying to switch a web site on a complete
new machine. The old machine was runnig MySQL 3.22.32,
the new machine runs on 3.23.49
The application used Phorum for genera
Hi All,
I've been trying to re-start the mysql server for a while now.
A few days ago, I discovered that I couldn't connect to the database
after entering my password. I got the usual "can't connect via
the /tmp/mysql.sock" message.
I tried to restart the daemon with ./bin/safe_mysqld &, but th
version 3.23.49.
when you have not compiled with --enable-local-infile, you
will get
$ mysql --help | grep local | wc -l
0
looks like undocumented feature.
--
Petr Chloupek
[EMAIL PROTECTED]
All work and no play makes Jack a dull boy.
-BEGIN GEEK CODE BLOCK-
Version: 3.12
GCS d- s:
On Sat, 01 Jun 2002 11:58:38 +0200
Claire Forchheimer <[EMAIL PROTECTED]> wrote:
I know the answer to the first part at least. I think you want to use two columns in
the order by clause, and leave out the group by clause. As in:
select * from tbl order by apt, name;
I'm afraid its too late a
Hi
I am working with Windows NT.
I want to install mysql on drive d.
Now i need to change the file my.cnf.
In the manual they write that i need to put this file in c:\
BUT what if i don't have drive C??
and if now i want to write some program that find out the drive that mysql
installed on.
how c
Hi all,
I read in the manual about building mysql not on c:\
and i found that i need to change the file my.ini
my questions are:
1) can i build this file by my self and not with winmysqladmin.exe?
2) it is enough to change this file if i want to put mysql in drive d, or am
i need to do another ch
Hi
After i install mysql, there is a way that i can know on witch drive i
installed it on?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
At 07:07 PM 5/31/2002, you wrote:
>Hi Jeremy,
>
>I've done some tests grouping the INSERTs in groups of 1000 and 1, and
>it got very faster, in my Pentium III 700 from job I could get less than 3s.
>But I'm still doing concatenation to get the INSERT clause in the form
>"values (x,x), (x,x) ..
Does the library 'libmysqlclient.so' known to work
in a multi-threaded environment on Solaris?
I'm asking as in my C++ multithreaded program I get segmentation/bug error
from time to time.
Each of my threads is holding its own persistent connection.
I'm using MyODBC.
But even after I let each
Leeuw van der, Tim writes:
> Hello,
>
> Thank you very much for your reply! I was hoping that this was indeed fixed
> in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to
> 4.0.1; I will retest the query with 4.0.2 as soon as it's released.
>
> Apologies btw for not mentioning
54 matches
Mail list logo
