mysql,hello£¡
There are three table(a,b,c) in my database,Today, I want to delete some records from
b;
but I regreted very much my having send wrong command :delete from a where id>3
I make a mistake, I deleted the records from a table which I shouldn't delete from!
Can I restore the records
On Saturday 03 November 2001 04:26, paco anubis wrote:
> Hello,
> I started learning Perl 4 weeks ago and mysql 3 days
> ago so I know that I am in over my head, but here goes
> nothing. I am trying to build a Perl CGI application
> (using DBI) to pass form contents from a web page
> directly int
Well, you usualy split your data in tables for a reason, because some data in
mulitple numbers are associated to one, or multiple data.
In your case, if you have one address and contact per customers, then make it
one table.
If you have an unknown numer of contacts and numbers per customer, the
Under "Description of MySQL regular expression syntax", the manual says:
This is a simplistic reference that skips the details. To get more exact
information, see Henry Spencer's regex(7) manual page that is included
in the source distribution.
Since the
Hi,
Try :
SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 UNION SELECT * FROM tbl3
UNION SELECT * FROM tbl15 WHERE title LIKE 'something' ORDER BY
date_created DESC
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMA
Hi all,
I have looked throught the manual and found that I could use a UNION syntax
to join a bunch of tables into 1 query. How the heck can I do this with 15
tables, order the records by date_created desc and have there be WHERE title
LIKE 'something'. I have those other parts (order, etc) jus
hello!
im storing pretty big amounts of customer data in a mysql databases.
its about 2 million rows. what im wondering about now is, how does mysql
perform joins on such amounts of data?
i was planning to split the info in at least 3 tables: a general
customer table,
a address table, and a co
> > section 6.4.1.1:
> > ...
> > INNER JOIN and , (comma) are semantically equivalent. Both do a
> > full join between the tables used. Normally, you specify how
> > the tables should be linked in the WHERE condition.
> > ...
> > Carsten H. Pedersen
>
> ??
>
> Since this does not appear in the m
> section 6.4.1.1:
> ...
> INNER JOIN and , (comma) are semantically equivalent. Both do a
> full join between the tables used. Normally, you specify how
> the tables should be linked in the WHERE condition.
> ...
> Carsten H. Pedersen
??
Since this does not appear in the manual for v. 3.23.42,
At 19:10 02/11/2001 -0500, Ken wrote:
Hi Ken,
Unlucky with your report I can't able to begin any test
for fix this behavior. Try to make notes about every
step until reach the crash, then send me the notes and the
structure of the tables.
Regards,
Miguel
>I'm running MySQL 3.23.41 on Win95 (jus
I've observed that if I run a simple "SELECT *" command on a two-row table,
the query takes anywhere from half a second to four seconds:
>>>
mysql> select * from pet;
+--+-+-+--++---++
| name | owner | species | sex | birth | de
Thanks! I altered my statements to use left joins and now it all looks like
it's working!
On Thursday 01 November 2001 09:51 pm, Quentin Bennett wrote:
Hi,
You need to read up on Left Joins, which will insert a 'NULL' row in the
results for B where there isn't a real one.
Regards
Quentin
I was poking around my Error Files today and I came across this error in
the file:
<
011101 13:00:33 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init param
At 9:42 PM +0100 11/3/01, paul wrote:
>Good day,
>
>Your installation instructions read as follows:
>
>If you don't have a copy of the MySQL distribution, you should first
>download one from `http://www.mysql.com/downloads/mysql-3.23.html'.
>To install either distribution, unzip it in some empty d
Good day,
Your installation instructions read as follows:
If you don't have a copy of the MySQL distribution, you should first
download one from `http://www.mysql.com/downloads/mysql-3.23.html'.
To install either distribution, unzip it in some empty directory and
run the `Setup.exe' program.
U
At 6:07 AM -0800 11/3/01, Mags wrote:
>is there any API in mySQL for copying rows in the same
>table..
>or any function of that sort.
What does "copying rows in the same table" mean? Copying them to where?
>Later,
>Mags
-
Bef
At 9:02 AM -0500 11/3/01, Greg Sarsons wrote:
>I haven't succeeded in being able to group by time. My timestamp field
>is -mm-dd hh:mm:ss. What I would like is have a query that will
>enable me to be to group on events say every 5 minutes.
>
>I've played around with using time_to_sec(timesta
At 04:26 PM 11/2/2001 -0600, Paul DuBois wrote:
>At 2:12 PM -0800 11/2/01, Bennett Haselton wrote:
>>How do you change the order of columns in MySQL tables? I assume the
>>tables have a concept of column order, since the DESCRIBE command always
>>lists the columsn in the order in which they wer
Hi
should be
mysql_connect("fred.com", "fredsusername", "fredspassword")
or
mysql_connect($host, $username, $password)
Only needs quotes if you are using actual values
HTH
Peter
> -Original Message-
> From: Imran Aziz [mailto:[EMAIL PROTECTED]]
> Sent: 03 November 2000 19:49
> To:
Hi all,
I have a MySQL database 'mydb' and I can perfectly access it via telnet. I
have one database and I have full access to it. I can't create user and
other databases, but its fine.
Problem is that I write a PHP script and I can't access my sql database
using that script! I got 'Access Denie
I forgot to mention one very important thing: this error cropped up after I
edited /usr/local/libdata/perl5/site_perl/i386-openbsd/DBI.pm to use DBI
version 1.20 instead of 1.15 (apparently, this file was not updated after I
uninstalled 1.15 and installed 1.20, because I got errors complaining abo
I'm trying to use Perl DBI to connect to MySQL, and getting some really
nasty errors:
SV = RV(0x1a45c) at 0xc4a04
REFCNT = 1
FLAGS = (ROK)
RV = 0xc4998
SV = RV(0x1a45c) at 0xdfbfd9a0
REFCNT = 1
FLAGS = (ROK,READONLY)
RV = 0xc4998
DBD::mysql initialisation failed: dbih_setup_attrib(DBI::dr
At 10:05 AM -0700 10/26/01, Jonathan M. Morgan wrote:
>I am working my way through Paul DuBois' excellent book "MySQL and Perl for
>the Web." One of the examples shows how to conduct a poll- vote for your
>favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl
>Paul then suggests modi
I went to the link provided to the list archive just to see if I could find
anything. I couldn't find anything with "CD", "CD ROM", "CD-ROM", "running
mySQL for a CD" and various permutations and combinations thereof. Also did
a Google search for this and came up blanked. So, this is not as readil
On Sat, 2001-11-03 at 08:33, [EMAIL PROTECTED] wrote:
> Hi. I have already written a php / mysql search engine, so i have a
> vague idea of what i'm doing. But i do have a query no seems to
> be able to answer.
>
> Is it possable to copy a row from one table, to another table?
> Both tables h
Hello!
I have two tables:
table a: and table b:
+---+-+ +---+-+
| x | foo | | x | bar |
+---+-+ +---+-+
| 1 | "a" | | 2 | "U" |
| 2 | "b" | | 3 | "X" |
| 4 | "c" | | 4 | "Y" |
| 6 | "d" | | 5 | "Z" |
+-+ +-+
x is the primary key(s) in both tables.
f
> >The FAQ clearly states
>
> There's a FAQ?
Yes, but it's unofficial, and it's a secret... :-)
http://www.bitbybit.dk/mysqlfaq
- it's been around for a while, now, and I and
others have asked the site maintainers to place
a link to it somewhere in the documentation
section.
Alas, they
> The manual's description of Join Syntax lists the various kinds of
> syntax but doesn't define some of them, e.g.:
>
> table_reference, table_reference
>
> and
>
> table_reference INNER JOIN table_reference join_condition
Yes, it does.
> I'm guessing these two are equivalent, except that yo
Hi!
>Dear Mr. Tuuri,
>
>I think it is outstanding that you offer this essential add-in to MySQL.
Thanks!
>Do you have any plans to add "On Delete Cascade" or "On Update Cascade" to
>InnoDB, and if so when? I am still being forced to choose between sticking
Sorry, not in the near future. B
The manual's description of Join Syntax lists the various kinds of
syntax but doesn't define some of them, e.g.:
table_reference, table_reference
and
table_reference INNER JOIN table_reference join_condition
I'm guessing these two are equivalent, except that you can't use a
join_condition with
David Wolf writes:
> Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000
> SP2
>
> David
Thanks, I will check it out ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL
>The FAQ clearly states
There's a FAQ?
I don't see one mentioned at
http://www.mysql.com/documentation/index.html , except for the "dynamic
FAQ". I just tried this dynamic FAQ with Topic "Language Reference",
keyword "join". That produces 0 results.
The welcome message for this list says "
Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000
SP2
David
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, November 03, 2001 4:14 AM
Subject: Re: MySQLGUI hangs on certain command
Hi. I have already written a php / mysql search engine, so i have a
vague idea of what i'm doing. But i do have a query no seems to
be able to answer.
Is it possable to copy a row from one table, to another table?
Both tables have the same field names, and settings. And i can
easily "insert
Apple has posted an article on using MySQL and Postgres under Mac OS X:
http://developer.apple.com/internet/macosx/osdb.html
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
>> I will have to include a warning in the comments section of the MySQL
>> documentation to NOT CONVERT MySQL SYSTEM TABLES FROM myISAM TO INNODB TYPE!
I have now added a warning about this to the manual.
Regards,
Monty
Al Giacomucci writes:
> We are developing an application for commercial distribution using a Java
> client, JDBC, and an SQL database . It will come in 2 versions - a
> standalone single-user version that will run on a PC and multi-user version
> where the database will run on a separate server.
We are developing an application for commercial distribution using a Java
client, JDBC, and an SQL database . It will come in 2 versions - a
standalone single-user version that will run on a PC and multi-user version
where the database will run on a separate server.
For the standalone version we
is there any API in mySQL for copying rows in the same
table..
or any function of that sort.
Later,
Mags
__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
-
Use MYODBC (see http://mysql.com ) to connect to the mysql database
Within Access database use 'link to external data' for mysql and use an
INSERT query to get the data into the Access table
HTH
Peter
> -Original Message-
> From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
> Sent: 03
I want to enable a user-friendly search for authors in a books database.
When an author's name is spelled in several ways (T.S. Eliot; Eliot, T S;
Eliot, Thomas Stearns, etc.) the user input using these different spellings
should find all entries from this author. I thought I could get this don
I haven't succeeded in being able to group by time. My timestamp field
is -mm-dd hh:mm:ss. What I would like is have a query that will
enable me to be to group on events say every 5 minutes.
I've played around with using time_to_sec(timestamp) to convert all the
times to seconds and then gr
You can use phpadmin to control the database and there is an option to
view dump into a CSV file either in MS Excel format or standard CSV
file. Once you dumped it, you can then import it into Access
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message
I have done Access to mySQL, but not the other way around... I guess
you would need to export the table to a CSV file then import it into
Access.
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT
Does anyone know how to download a table from MySQL (at
a server)to MS' Access '97 (at a client)?
Thanks!
Anthony F. Rodriguez
([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
> If you look at the documentation for UPDATE, you'll
> find no mention of multi-table updates, and so they don't
> exist. If you search the docs you'll find that they are to
> be added in 4.1.
> The FAQ clearly states that multi-table updates and deletes
> do not exist at this point in time. And
Enquiries writes:
> Does anyone know of any EASY instructions on how to you MYSQL?
The manual, the FAQ, and the book by Paul DuBois. I haven't read
the book myself tho.
> I've forgotten the password to mysql and cannot understand how you
> actually reset it?
> I've read the documentation but d
> > I don't know how to remove users other than directly removing them from
> > mysql.user table
> >
>
>
> This may be very obvious but being a new mysql admin user how do I do what
> you say above, to delete the user from the user table. There doesn't
> appear to be any examples of this in the do
Enquiries wrote:
> Does anyone know of any EASY instructions on how to you MYSQL?
>
> I've forgotten the password to mysql and cannot understand how you
> actually reset it?
> I've read the documentation but does not make any sense.
>
> Any help would be appreciated.
>
> Thanks
> George Ewing
>
>
Does anyone know of any EASY instructions on how to you MYSQL?
I've forgotten the password to mysql and cannot understand how you
actually reset it?
I've read the documentation but does not make any sense.
Any help would be appreciated.
Thanks
George Ewing
-
Hi,
I am having problems finding this file:
libmysqlclient.so.6.0.0
I wanted to use a MySql Db through Kylix 2. On attempting to connect to the db, I get
the error message
unable to Load libmysqlclient.so.6.0.0
I could not find the file on my system using the Find File option. I
> I have a database of dealers.
=Hmm, reminds me of a joke: how many industries do you know that refer to their
customers as "users" and their
suppliers as "dealers"?
A web page loads a list of states, a user
> clicks on the
> state and the database is queried and lists in a table the dealers f
[EMAIL PROTECTED] writes:
> MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it.
> It connects fine, I can view a table, etc.. But, when I click on the
> GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and
> issue SHOW PROCESSLIST, there are a
Hi,
I found a discussion about the index file not being able to be RAIDed, and
know that the OS Limit will apply in any case, but this is Solaris 8, so
that isn't a problem, but can't find anything that explicitly states it.
Even SHOW TABLE STATUS:
mysql> show table status like 'tt_tickets'\G
> How do you change the order of columns in MySQL tables? I assume the
> tables have a concept of column order, since the DESCRIBE command always
> lists the columsn in the order in which they were created.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_5_0
/ Carsten
--
Carsten H. Pedersen
keep
Uriel Wittenberg writes:
> UPDATE persondata SET age = select age from othertable where
> persondata.id = othertable.id;
>
> But the manual gives no clue as to whether this is possible.
It does. If you look at the documentation for UPDATE, you'll
find no mention of multi-table updates, and so
Hi,
Assuming that a 'table' has been defined with MAX_ROWS high enough to allow
the table to be > 4Gbytes, does the same size limit apply to the index as
the data file, or is the index file subject to a different limit?
Thanks for a speedy response
Quentin Bennett
Transport Systems Division
In
57 matches
Mail list logo
