Re: multiple domain names mapped to a single IP

certain the names resolve correctly in DNS... Then see point 1 above. he is talking about *server* address not the client that you always should use "skip-name-resolve" and never ever set permissions based on reverse-DNS because a) when DNS lags everything lags and b) it is easy for m

Re: multiple domain names mapped to a single IP

Kaushal There are two ways to approach this: 1.) Turn off name resolution in MySQL and only do the ACL by IP. This is probably best as name resolution can slow the database and cause outright app failure if DNS fails for any reason. 2.) Make absolutely certain the names resolve correctly in

Re: multiple domain names mapped to a single IP

Am 02.03.2017 um 16:01 schrieb Kaushal Shriyan: Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int

multiple domain names mapped to a single IP

Hi, Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11 int

Re: Dumping database names from bash with exclusion

* h...@tbbs.net [150401 15:22]: > On 2015/04/01 16:09, Tim Johnson wrote: > >Using Mysql 5 on darwin (OS x). > >This command > >SELECT schema_name FROM information_schema.schemata WHERE > >schema_name NOT IN > >('mysql','information_schema','performance_schema'); > >as executed from the mysql prom

Re: Dumping database names from bash with exclusion

On 2015/04/01 16:09, Tim Johnson wrote: Using Mysql 5 on darwin (OS x). This command SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema'); as executed from the mysql prompt gives me a dump of all databases except those no

Dumping database names from bash with exclusion

Using Mysql 5 on darwin (OS x). This command SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema'); as executed from the mysql prompt gives me a dump of all databases except those not included in the tuple. This command mys

Re: help with mysql db names

On 19.04.2013 06:49, Kapil Karekar wrote: Though I would recommend not using such names. Some poor guy working on your application six months down the line is going to wonder why his queries are failing, spend a day trying to figure out and will post the same question again to this list

help with mysql db names

Hello, why these db names created fail but the last one gets success? mysql> create database 3208e1c6aa32; ERROR 1064 (42000): 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 '3208e1c6aa32' at

Re: help with mysql db names

On 2013-04-19, Doug wrote: > > why these db names created fail but the last one gets success? [snips] > mysql> create database 3208e1c6aa32; > mysql> create database 208e1c6aa32; > mysql> create database 08e1c6aa32; > mysql> create database 8e1c6aa32; > mysql&

Re: help with mysql db names

On 19-Apr-2013, at 9:14 AM, Doug wrote: > why these db names created fail but the last one gets success? > > mysql> create database 3208e1c6aa32; > mysql> create database 208e1c6aa32; > mysql> create database 08e1c6aa32; > mysql> create database 8e1c6aa32; These

Re: Triggers and column names

om one invocation > of the trigger to the next, so don't have the "dynamic" code inside the > trigger. > > > -Original Message- > > From: Hal?sz S?ndor [mailto:h...@tbbs.net] > > Sent: Thursday, June 21, 2012 5:05 PM > > To: mysql > > Su

RE: Triggers and column names

l?sz S?ndor [mailto:h...@tbbs.net] > Sent: Thursday, June 21, 2012 5:05 PM > To: mysql > Subject: Re: Triggers and column names > > >>>> 2012/06/21 17:06 -0500, Gael Martinez >>>> > I'm getting that done today thru a large static trigger script and I > woul

Re: Triggers and column names

>>>> 2012/06/21 17:06 -0500, Gael Martinez >>>> I'm getting that done today thru a large static trigger script and I would like something more dynamic... <<<<<<<< For that it is needful to look up the table in INFORMATION_SCHEMA.COLUMNS, and,

Triggers and column names

Hello there I'm trying to figure out an elegant way with Mysql 5.5.25 to log changes via a before change trigger to a table including the column name of the field that changed... How can I dynamically enumerate the field names and populate the field log into the t1_log test table ... Wo

Re: Upgrade 5.0 -> 5.1 - long table names with invalid chars.

On 2/15/2012 22:16, Bobb Crosbie wrote: Hi Folks, I'm preparing an upgrade of a 5.0.51a database to 5.1.58 (Ubuntu 11.10) - Some of the table names contain invalid characters which mysql_upgrade (mysqlcheck) is attempting to escape by renaming the filename. However I'm having trouble

Upgrade 5.0 -> 5.1 - long table names with invalid chars.

Hi Folks, I'm preparing an upgrade of a 5.0.51a database to 5.1.58 (Ubuntu 11.10) - Some of the table names contain invalid characters which mysql_upgrade (mysqlcheck) is attempting to escape by renaming the filename. However I'm having trouble with some tables with long names. For i

RE: How to export data with column names?

>-Original Message- >From: mos [mailto:mo...@fastmail.fm] >Sent: Sunday, February 13, 2011 4:50 PM >To: mysql@lists.mysql.com >Subject: How to export data with column names? > >I want to use > >select * into outfile "myfile.txt" from table1; > >a

Re: How to export data with column names?

outfile.txt ~Chamila Gayan On Mon, Feb 14, 2011 at 11:15 AM, mos wrote: > I want to use > > select * into outfile "myfile.txt" from table1; > > and have it export the data as tab delimited but with the column names. I > need the column names because the import utilit

How to export data with column names?

I want to use select * into outfile "myfile.txt" from table1; and have it export the data as tab delimited but with the column names. I need the column names because the import utility will use that to create the table in another (non-MySQL) database. As it stands, I can't

How to export data with column names?

I want to use select * into outfile "myfile.txt" from table1; and have it export the data as tab delimited but with the column names. I need the column names because the import utility will use that to create the table in another (non-MySQL) database. As it stands, I can't

Re: STRAIGHT JOIN vs. field names

Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT JOIN". Thanks! Mike Spreitzer

Re: STRAIGHT JOIN vs. field names

The relationship looks righteous enough but I note that you use 'straight join' in your expression, rather than 'straight_join' as indicated in the manual (http://dev.mysql.com/doc/refman/5.1/en/join.html). Perhaps the message is a red herring and your trouble is elsewhere? - michael dykman On

STRAIGHT JOIN vs. field names

Why is it that a field name that works fine for a JOIN is invalid in a STRAIGHT JOIN? mysql> show create table fldsndm; +-+--

Re: Missing database file names

"Jesse F. Hughes" writes: > "Jesse F. Hughes" writes: > >> r...@pw:/var/lib/mysql/mythconverg# myisamchk -o recorded.MYI >> Warning: option 'key_buffer_size': unsigned value 18446744073709551615 >> adjusted to 4294963200 >> Warning: option 'read_buffer_size': unsigned value 18446744073709551615

Re: Missing database file names

"Jesse F. Hughes" writes: > r...@pw:/var/lib/mysql/mythconverg# myisamchk -o recorded.MYI > Warning: option 'key_buffer_size': unsigned value 18446744073709551615 > adjusted to 4294963200 > Warning: option 'read_buffer_size': unsigned value 18446744073709551615 > adjusted to 4294967295 > Warnin

Re: Missing database file names

(I emailed this to Martin and Jaime rather than to the discussion group, so I'm re-sending it.) Martin Gainty writes: > Jesse ..please keep us apprised on your progress..we would like to > know how fubar the db can be before it becomes 'unrecoverable' Well, I'm not having much luck so far. I h

Re: Missing database file names

2010/6/4 Jesse F. Hughes : > Is it possible to build a .MYI file "from scratch"? > > I have found a file that I believe is recorded.MYD.  I have the .frm > file as well, but I don't think that recorded.MYI survived the > file system event. Yes, the mysql utility "myisamchk" and the REPAIR command

Re: Missing database file names

Is it possible to build a .MYI file "from scratch"? I have found a file that I believe is recorded.MYD. I have the .frm file as well, but I don't think that recorded.MYI survived the file system event. -- "No feeling sympathy for mathematicians who start marching with signs like 'Will work fo

Re: Missing database file names

Dan Nelson writes: > In the last episode (Jun 02), Jesse F. Hughes said: >> After a recent hard drive kerfluffle and the results of fsck, I'm left >> with a slew of jumbled database files. The file command can tell me the >> file types, like so: >> >> #15901614: MySQL table definition file Vers

Re: Missing database file names

Dan Nelson writes: > In the last episode (Jun 02), Jesse F. Hughes said: >> After a recent hard drive kerfluffle and the results of fsck, I'm left >> with a slew of jumbled database files. The file command can tell me the >> file types, like so: >> >> #15901614: MySQL table definition file Vers

Re: Missing database file names

In the last episode (Jun 02), Jesse F. Hughes said: > After a recent hard drive kerfluffle and the results of fsck, I'm left > with a slew of jumbled database files. The file command can tell me the > file types, like so: > > #15901614: MySQL table definition file Version 10 > #15901615: MySQL MI

Missing database file names

After a recent hard drive kerfluffle and the results of fsck, I'm left with a slew of jumbled database files. The file command can tell me the file types, like so: #15901614: MySQL table definition file Version 10 #15901615: MySQL MISAM compressed data file Version 1 #15901617: MySQL table defin

Re: Ordering field names in a "DESC / DESCRIBE table" or "SHOW COLUMNS from table" command

ion_schema.columns > WHERE table_schema='db' AND table_name='tbl'; Thank you Peter! With your good example, it became very easy for me to reach a working solution, that was running the following query (replacing "database_name" and "table_name&qu

Re: Ordering field names in a "DESC / DESCRIBE table" or "SHOW COLUMNS from table" command

It would be convenient for me to get a list of those fields ordered by field / column name. SELECT * FROM information_schema.columns WHERE table_schema='db' AND table_name='tbl'; PB - Ricardo Dias Marques wrote: Hi all, I have a Linux server with MySQL 5.0 (5.0.67) installed. In that

Ordering field names in a "DESC / DESCRIBE table" or "SHOW COLUMNS from table" command

Hi all, I have a Linux server with MySQL 5.0 (5.0.67) installed. In that server, I have a database that has a table with many fields (around 60). It would be convenient for me to get a list of those fields ordered by field / column name. Unfortunately, a "DESC tablename ("DESCRIBE tablename") co

Re: Getting mySQL to ignore case sensitivity of field names

enter 'Host'. The mysql.com link seems to only talk about field values. That should not happen. Column names are not case sensitive in MySQL. http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html: Column, index, and stored routine names are not case sensitive o

Re: Getting mySQL to ignore case sensitivity of field names

Oops, sorry about that. My understanding is this is OS dependent: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html You may be able to set lowercase tables names, but would always have to use lowercase. I would just stick to entering in the correct case, as the other

Re: Getting mySQL to ignore case sensitivity of field names

o only talk about field values. Regards Adrian - Original Message - From: Scott Haneda To: Adrian Aitken Cc: mysql@lists.mysql.com Sent: Thursday, August 27, 2009 11:04 PM Subject: Re: Getting mySQL to ignore case sensitivity of field names http://dev.mysql.com/doc/refman/5.0/en/case-se

Re: Getting mySQL to ignore case sensitivity of field names

field names i.e. FullName should also be able to be referenced as fullname,fullNAME etc ? I'm running it on a linux box at home but my copy at work (running on Windows 2000 server) has this by default - I certainly set any options. When I Google all I seem to get are hits about ignori

Getting mySQL to ignore case sensitivity of field names

Hi, Google isn't my friend :-( How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName should also be able to be referenced as fullname,fullNAME etc ? I'm running it on a linux box at home but my copy at work (running on Windows 2000 server) has this by default - I cer

RE: Natural Join Issue: column names are equal but doesn't work anyways

Hi Deviad, NATURAL JOIN uses all column names that are the same between both tables as conditions. select * from rappresentanti NATURAL JOIN clienti; is the same as: select * from rappresentanti r JOIN client c ON r.cognome=c.cognome AND r.nome=c.nome AND r.vita=c.vita AND r.citta=c.citta

Re: Natural Join Issue: column names are equal but doesn't work anyways

On Tue, Aug 25, 2009 at 6:55 AM, Deviad wrote: > Hello, > I have been training for a test on Database Design and MySQL. > The following is inside a file we have to run before starting to code > what the excercises require us to. > Call the file as you wish and run it if it helps to understand the

Re: Natural Join Issue: column names are equal but doesn't work anyways

Hi again, since I'm not someone who gives up easily, I have restyled that old code (actually is from an example back of my teacher into 2002, I saw that she changed a bit her way to code this stuff), I restyled the code just to be sure it isn't some parsing issue or whatever. http://pastebin.com/f5

Natural Join Issue: column names are equal but doesn't work anyways

Hello, I have been training for a test on Database Design and MySQL. The following is inside a file we have to run before starting to code what the excercises require us to. Call the file as you wish and run it if it helps to understand the reason behind my problem. --- DROP

Re: Problem with Dynamic table names.

Marco, all, Marco Bartz wrote: > I accidentally sent it before finishing... > > I am looking for a way to do the following with a single query: >> SELECT `ID`, `Name`, `Interface`, >> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as >> `activeListings` >> FROM `sites`

Re: Problem with Dynamic table names.

Marco Bartz wrote: I accidentally sent it before finishing... I am looking for a way to do the following with a single query: SELECT `ID`, `Name`, `Interface`, (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as `activeListings` FROM `sites` I am querying the

Re: Problem with Dynamic table names.

I accidentally sent it before finishing... I am looking for a way to do the following with a single query: > SELECT `ID`, `Name`, `Interface`, > (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as > `activeListings` > FROM `sites` > I am querying the sites table and I want

Problem with Dynamic table names.

I am looking for a way to do the following with a single query: SELECT `ID`, `Name`, `Interface`, (select count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as `activeListings` FROM `sites`

Re: Recompiling to avoid issuing SET NAMES

| Variable_name| Value | +--++ | character_set_connection | latin1 | +--++ 1 row in set (0.00 sec) On Sun, Sep 28, 2008 at 9:11 AM, Luigi Perroti <[EMAIL PROTECTED]> wrote: > Hi, I'm currently using the official MySQL binaries and

Recompiling to avoid issuing SET NAMES

Hi, I'm currently using the official MySQL binaries and I have to issue 'SET NAMES utf8' queries on every connection to override the default values for character_set_connection and collation_connection. I was wondering how to avoid the overhead that issuing these queries introdu

Re: How do I get the file names from a certain directory in SQL?

I accept that.. but my requirement is , I have some no of Excel files..I just need to check the modified time of the files ,if it is modified currently then I need to open those files and convert the excel data to database.. otherwise i didnt change anything in my database.. how can i going

Re: How do I get the file names from a certain directory in SQL?

Martijn Tonies wrote: Hey, How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions

Re: How do I get the file names from a certain directory in SQL?

On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote: > Hi all, > > How do I get the file names from a certain directory in SQL? SQL is designed to deal with RDBs, not the rest of the computer system. I suggest you switch to a modern language such as Perl, Python, Ruby, or even PHP. E

Re: How do I get the file names from a certain directory in SQL?

Hey, > How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions that interact with the file sys

How do I get the file names from a certain directory in SQL?

Hi all, How do I get the file names from a certain directory in SQL? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Spaces in sourced file names?

e.com >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Monday, July 21, 2008 4:50 PM >To: Jerry Schwartz; mysql@lists.mysql.com >Subject: Re: Spaces in sourced file names? > >Ls -la file\ name.file > > >\ >Will escape the space for

Re: Spaces in sourced file names?

Ls -la file\ name.file \ Will escape the space for ya me believes --Original Message-- From: Jerry Schwartz To: mysql@lists.mysql.com Sent: Jul 21, 2008 13:48 Subject: Spaces in sourced file names? In the CLI, is there any way to source a file whose name has whitespace in it

Spaces in sourced file names?

In the CLI, is there any way to source a file whose name has whitespace in it (particularly spaces)? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 w

Re: Need help with a "natural sort order" for version numbers and release code names

Oh, and here's the output (Sorry): +---+-+ | releaseid | name| +---+-+ | 1 | Unspecified | | 2 | Next Patch | | 3 | LOCset | | 4 | Abashiri| |

Re: Need help with a "natural sort order" for version numbers and release code names

Here's my full test solution: use test; drop table if exists releases; create temporary table releases ( releaseid int(10) unsigned not null auto_increment primary key, name varchar(255) )engine=myisam; insert into releases ( name ) values ( 'Unspecified' ), ( 'Next Patch' ), (

RE: Need help with a "natural sort order" for version numbers and release code names

> -Original Message- > From: Jay Pipes [mailto:[EMAIL PROTECTED] > Sent: Friday, October 12, 2007 2:07 PM > To: Daevid Vincent > Cc: mysql@lists.mysql.com > Subject: Re: Need help with a "natural sort order" for > version numbers and release code

Re: Need help with a "natural sort order" for version numbers and release code names

Daevid Vincent wrote: I'm trying to get some 'release/version numbers' to sort properly. mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC; +---+-+ | ReleaseID | Name| +---+-+ |18 | Unspecifie

Need help with a "natural sort order" for version numbers and release code names

I'm trying to get some 'release/version numbers' to sort properly. mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC; +---+-+ | ReleaseID | Name| +---+-+ |18 | Unspecified | |20

Re: How do you reference custom column names

In the last episode (Jun 19), Scott Haneda said: > SELECT 1+1 as foo, 2 as bar, foo+bar > > This will not work, but I think you can see what I am trying to do. > I need to run a pretty hefty update on a database, and there are some > pretty heavy calculations I will be doing. The result of many

How do you reference custom column names

SELECT 1+1 as foo, 2 as bar, foo+bar This will not work, but I think you can see what I am trying to do. I need to run a pretty hefty update on a database, and there are some pretty heavy calculations I will be doing. The result of many of those, needs to be further used to make updates on other

Cluster/replication different table names

Hi guys, I wonder if there is any chance to set up replication/cluster with different tables names on the servers (maybe using aliases for tables) eg.. box1: db name: base1 table name: users box2: db name: base1 table name: users_new Any ideas? Thanks in advance -- Regards, Ezequiel L

Field names truncated.

I recieved a database structure from a certain piece of software and I exported all the tables to MySQL, only to find out that the field names were cut short. How can I make sure that the field names is large enough to accomodate the longest field header? Thank you. -- -Mahmoud Badreddine http

Re: Does casing of Table names matter on Linux

uery > > like > > > select * from TAb1 ,will it make an effect. > > > I have found that this is not a problem on windows but it is on > > linux, i > > > want a sol. for that a i can not change all the table names as in > > some > > > places it is

Re: Does casing of Table names matter on Linux

> > select * from TAb1 ,will it make an effect. > > > I have found that this is not a problem on windows but it is on > > linux, i > > > want a sol. for that a i can not change all the table names as in > > some > > > places it is in small case and in ot

Re: Does casing of Table names matter on Linux

ter on linux ie if i have table name as tab1 and i execute query like > select * from TAb1 ,will it make an effect. > I have found that this is not a problem on windows but it is on linux, i > want a sol. for that a i can not change all the table names as in some > places it is in small

Re: Does casing of Table names matter on Linux

xecute query like > select * from TAb1 ,will it make an effect. > I have found that this is not a problem on windows but it is on linux, i > want a sol. for that a i can not change all the table names as in some > places it is in small case and in other places it is in capital case. >

Re: Does casing of Table names matter on Linux

have found that this is not a problem on windows but it is on linux, i > want a sol. for that a i can not change all the table names as in some > places it is in small case and in other places it is in capital case. Yes, this is a problem on Linux if you're using MyISAM etc, anything

Re: Does casing of Table names matter on Linux

e query like > select * from TAb1 ,will it make an effect. > I have found that this is not a problem on windows but it is on linux, i > want a sol. for that a i can not change all the table names as in some > places it is in small case and in other places it is in capital case. Yes.. There

Does casing of Table names matter on Linux

is not a problem on windows but it is on linux, i want a sol. for that a i can not change all the table names as in some places it is in small case and in other places it is in capital case. Pl. help me, Thanks, Abhishek jain

Re: Cloning a table with different column names

t; run 'mysqldump --no-data ' and redirect to a text > file. change the table name and column names in the text file as desired > (using perl) run mysql client redirect input from the text file > > Something with more dignity (and no perl) Perl = no dignity? My biz partner likes pe

Re: Cloning a table with different column names

Here is something convoluted and sick ... run 'mysqldump --no-data ' and redirect to a text file. change the table name and column names in the text file as desired (using perl) run mysql client redirect input from the text file Something with more dignity (and no perl) create t

Cloning a table with different column names

Hello: I have a need to create two tables from imported data. The only difference between the tables is the column names. The data will be the same. Can anyone propose a mysql method to create a new table from an existing table with new column names? thanks tim -- Tim Johnson <[EM

RE: Select where the column names are not fully known

I don't know if this can be done purely in SQL. Programmatically, you could do something like SHOW COLUMNS FROM tablename LIKE "vector%"; That would give you the names (and types, which you can ignore) of the desired columns. Then you can programmatically build up the list of co

Re: Select where the column names are not fully known

007 5:00 AM Subject: Select where the column names are not fully known We have a logging package that logs data into a table. Part of the data that is logged are elements of a vector. A logging application automatically takes out the elemets of the vector and automatically creates column names ba

Select where the column names are not fully known

We have a logging package that logs data into a table. Part of the data that is logged are elements of a vector. A logging application automatically takes out the elemets of the vector and automatically creates column names based on it's name and the element. This data will be mixed in with

RE: What's the best way to INSERT a long list of email addresses and names into a TABLE?

e best way to INSERT a long list of email addresses and names into a TABLE? Hi, I have a long list of email addresses, and names in a text file in csv format, and I want to know what's the best approach to quickly INSERT them into my customers TABLE. Initially I thought it could be easy

RE: What's the best way to INSERT a long list of email addresses and names into a TABLE?

I don't know; never tried it that way _ From: axis [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 9:37 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: What's the best way to INSERT a long list of email addresses and names into a TABLE? HT

What's the best way to INSERT a long list of email addresses and names into a TABLE?

I have a long list of email addresses, and names in a text file in csv format, and I want to know what's the best approach to quickly INSERT them into my customers TABLE. Initially I thought it could be easy to just add SQL INSERTs to the database dump but, the problem is I have to manuall

RE: What's the best way to INSERT a long list of email addresses and names into a TABLE?

he method we are using to bulk insert into our tables. Works like a champ. Don -Original Message- From: axis [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 9:10 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: What's the best way to INSERT a long list of ema

What's the best way to INSERT a long list of email addresses and names into a TABLE?

Hi, I have a long list of email addresses, and names in a text file in csv format, and I want to know what's the best approach to quickly INSERT them into my customers TABLE. Initially I thought it could be easy to just add SQL INSERTs to the database dump but, the problem is I ha

Re: case sensitive table names in mysql-5.0.21

-find-table.html /Johan Digvijoy Chatterjee skrev: Hello, I am using MySql-5.0.21 on Suse-Linux-10, i created tables using lowercase names for example ; mysql> create table a (id int); Query OK, 0 rows affected (0.04 sec) mysql> select * from A; ERROR 1146 (42S02): Table 'mysql.A' doesn&

Re: case sensitive table names in mysql-5.0.21

Hello, I am using MySql-5.0.21 on Suse-Linux-10, i created tables using lowercase names for example ; mysql> create table a (id int); Query OK, 0 rows affected (0.04 sec) mysql> select * from A; ERROR 1146 (42S02): Table 'mysql.A' doesn't exist mysql> select * from a;

case sensitive table names in mysql-5.0.21

Hello, I am using MySql-5.0.21 on Suse-Linux-10, i created tables using lowercase names for example ; mysql> create table a (id int); Query OK, 0 rows affected (0.04 sec) mysql> select * from A; ERROR 1146 (42S02): Table 'mysql.A' doesn't exist mysql> select * from a;

RE: blank user names in user table (SOLVED)

> -Original Message- > From: sheeri kritzer [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 2:37 PM > To: Duzenbury, Rich > Cc: mysql@lists.mysql.com > Subject: Re: blank user names in user table > > Rich, > > anonymous access means that '&#x

Re: blank user names in user table

Rich, anonymous access means that ''@host has access. That is, "blank" at host, as opposed to [EMAIL PROTECTED] To see if anonymous access is allowed, at the command prompt type: mysql -u asdf if you get a mysql login, you have anonymous access. Otherwise you'll get: ERROR 1045 (28000): Acce

blank user names in user table

Hi all, I've got a database I recently inherited where there are a number of records in the mysql.user table that have no user id. According to the mysql docs, this is supposed to allow guest access, and there is mention of how to turn it off. How does one actually connect in guest mode? My att

Re: 'Into outfile' doesn't include the column names. How can it be done?

; > > > Bonus marks for beginning the line with a # > > > > > > My attempt stalled as soon as I got one column of data in the result > set > > > with a row for each column of the target table. > > > > > > SELECT COLUMNS FROM INFORMATION_S

Re: 'Into outfile' doesn't include the column names. How can it be done?

t > > row rather having to hand type them as shown above? > > > > Bonus marks for beginning the line with a # > > > > My attempt stalled as soon as I got one column of data in the result set > > with a row for each column of the target table. > > >

Re: 'Into outfile' doesn't include the column names. How can it be done?

On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote: > > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > > > Hi Ariel, > > > > Maybe this example helps you to create CSV output from MySQL. > > The first SELECT generates the headerline; the second the data. > > ( SELECT 'FieldA','FieldB','FieldC',

Re: 'Into outfile' doesn't include the column names. How can it be done?

On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > Hi Ariel, > > Maybe this example helps you to create CSV output from MySQL. > The first SELECT generates the headerline; the second the data. > ( SELECT 'FieldA','FieldB','FieldC', ... ) > UNION > ( SELECT `FieldA`, `FieldB`, `FieldC`, ... > INTO

Re: 'Into outfile' doesn't include the column names. How can it be done?

To: Sent: Monday, March 06, 2006 8:12 PM Subject: 'Into outfile' doesn't include the column names. How can it be done? When using select into outfile, I can only get the table data, but I can't find how to include the column names. I haven't been able to include the col

RE: 'Into outfile' doesn't include the column names. How can it be done?

, 2006 5:12 PM To: mysql@lists.mysql.com Subject: 'Into outfile' doesn't include the column names. How can it be done? When using select into outfile, I can only get the table data, but I can't find how to include the column names. I haven't been able to include the column names in

Re: 'Into outfile' doesn't include the column names. How can it be done?

At 14:12 -0600 3/6/06, Ariel Sánchez Mora wrote: When using select into outfile, I can only get the table data, but I can't find how to include the column names. I haven't been able to include the column names into the actual return of the query, and they don't get stored in th

Re: 'Into outfile' doesn't include the column names. How can it be done?

Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 03/06/2006 03:12:20 PM: > When using select into outfile, I can only get the table data, but I > can't find how to include the column names. I haven't been able to > include the column names into the actual return of the

  1   2   3   4   5   >