| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> update adressen set GebDatum = STR_TO_DATE(GebDatum, GET_FORMAT(DATE,'USA')) <-- doesn't work
<1> i added it to the path, still doesnt work
<2> !tell danh about doesnt work
<3> Alrighty.
<1> hey, my bad, forgot a slash at the end. it works now
<1> now i just have to figure out why it isnt connecting to a remote server ;)
<4> !m MichaelDiederich date time functions
<3> MichaelDiederich: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<0> i read that page
<4> 'usa' is not a valid date format
<0> i copy &pasted from there
<0> GET_FORMAT(DATE|TIME|DATETIME, 'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL')
<0> Returns a format string. This function is useful in combination with the DATE_FORMAT() and the STR_TO_DATE() functions.
<5> anyone had any success trying to run mysql-workbench under Ubuntu?
<4> str_to_date(GebDatum, '%d.%m.%Y')
<4> that'll convert it to yyyy-mm-dd, the standard date format for mysql
<0> thank you, i have a try
<0> perfect! thank you!
<1> thanks, shabbs
<6> woo woo
<7> chugguh chugguh chugguh chugguh
<8> Is there a way to make the output of a quesry be paginated in the mysql client.
<8> s/\./?
<9> hm is it just me, or is it usually a bad sign to have static and non-static methods in a cl***
<10> if I select from A left join B inner join C ....... its an inner join between the table resulting from the left join of a and b, then inner joined with c ... correct?
<10> er... i typed too much ... but yeah
<11> i need help
<11> i tried much about still getting this error
<11> [root@LHR-PBX local]# /home/cron/ADMIN_area_code_populate.pl
<11> Access denied for user 'cron'@'localhost' (using p***word: YES) at /home/cron/ADMIN_area_code_populate.pl line 19
<11> i'm not sure what can i do : S
<12> most likely
<13> any debian guys here? im wondering if I may upgrade mysql on sarge from 4.0.24 to 4.1 without having to destroy everything
<12> Dr-Linux: problem with mysql p***word
<14> can anyone tell me where mysql stores it's databases on the filesystem and are they plain text?
<12> rufust. depends on table type
<15> the default is /var/lib/mysql/, and no
<12> if myisam then yes just plain text
<11> xxoxx: but i can login to mysql with same p***word?
<11> xxoxx: how can i verify?
<16> they are not plaintext.
<14> so if doesnt matter what kind of tables they are they wont be plain texT?
<16> is there a plaintext (csv, perhaps) 3rd party storage engine?
<14> cause i use myisam and im in /var/lib/mysql/mysql and none of the files here are plain text
<15> I believe that 5.1 (possibly 5.0) has a csv storage engine
<12> if the entire database is myisam, then yes they are just plain file, a backup of the /var/lib/mysql/mysql also backs up your entire database
<17> All databases are plain files, but they're not plain text.
<18> fsweetser: 5.0 has already
<19> how can i query the table names of a database
<12> of course the files might not be plain "text", i.e. they might be binary
<17> (Except the CSV engine, of course)
<15> is there any particular reason you'd want the storage files to be csv, as opposed to generating a csv as needed?
<12> rump "show tables"
<15> lsmith: okay, thought so but wasn't sure which manual I read it in
<19> but i need th results programmaticaly via php
<16> what do you mean by plain text? the records for string-stored data types are in plain text, of course, but the database as a whole isn't plain text
<11> xxoxx: that problem is solved now. but
<18> fsweetser: i guess the key point is integration with other tools
<14> okay so if i want to modify attributes in a database and i want to do it via a file is that possible?
<14> or should i just use an sql query?
<12> innodb, on the other hand, are not plain files. you can't simply backup the files to backup the database
<15> odds are you realy, realy want to use a sql query
<16> storing in plain text is inefficient
<14> okay thanks
<15> if you go behind mysqls back, you run into all sorts of risks of data corruption and race conditions - exactly the kind of stuff dbs are meant to handle
<11> xxoxx: but:
<11> [root@LHR-PBX local]# /home/cron/ADMIN_area_code_populate.pl
<11> can't execute query: |insert into vicidial_phone_codes VALUES ('code', 'country',
<11> what does it mean "can't execute query"
<20> does anyone have any insight into using mysql connector 1.07 with linux and mono?
<20> im trying to set up an asp.net server in linux
<21> Dr-Linux, check the table structure of vicidial_phone_codes
<21> and the data values you are trying to insert, also if you are using credentials related to cron via uid root, this may pose a problem.
<22> hi
<22> http://pastebin.com/631378
<22> can anyone check what's wrong with that function?
<22> 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 '' at line 9
<23> djoek: delimiter issue, perhaps?
<22> i set it to // like in the docs
<23> hmm
<22> once i set it it gives me the error
<22> doh
<22> end if is required
<23> oops.
<23> I might also use an elseif on the second case to both increase readability and possibly avoid an extra evaluation.
<22> good point
<22> this was just a first test
<23> ja
<20> does anyone use visual studio with mysql?
<24> hey all, I really need some help, I installed this rpm, and I can't find my /usr/bin/mysql at all
<24> it was a version of mysql 4.1
<24> does anybody have any clue?
<15> rpm 'rpm -q <name of rpm>' to see what files it installed
<15> er, run 'rpm...', that is
<17> mahakala: Which rpm did you install?
<17> Er, that doesn't do that
<17> Hrm, wait. Are you livejournal mahakala?
<24> is there a client tools rpm?
<24> nope, sorry mendel , different guy =)
<17> depending on the source of the rpms, things are packed up differently
<17> ah
<24> my source is mysql.com
<17> yeah, the mysql client is in the MySQL-client rpm
<24> thanks all, =)
<24> client rpm worked, I'm just not used to RPMS :P << gentoo user
<17> :)
<17> someone else compiles stuff for you -- it's like having staff!
<25> What method does mysql recommend for connecting apps like Access 2003 to mysql database running on x64 Windows? Since myodbc does not work.
<26> hello.
<27> SMaction: why does myodbc "not work"
<26> there's been a couple of articles on the planetmysql recently about MaxDB's Synchronization Manager and merging multiple sources into one database.
<26> I have an issue this seems to be able to solve but I need it implemented in MySQL for all boxes.
<4> you mean like federated tables?
<26> no not exactly.
<25> good question. I have asked over and over for help on this channel I have contacted mysql support and said if a solution can be worked out I would be happy to pay for the mysql network for a year. There is no response from mysql network and people on this channel just criticize windows. When I try to connect to the database from Access 2003 using myodbc either from the same (64 bit windows 2003 server) or a remote machine (win 200
<26> My company uses Legato which will log backup stats and failures into a database. For speed each of our datacenters has it's own logging database.
<20> how does one configure mysql to allow connections from remote computers?
<6> hirise, Error message?
<28> how do I tell which version I have installed?
<6> Linux distro?
<6> mattwestm, mysql --version?
<26> we want to merge the 4 sources London. Dallas, Herndon VA, and San Antonio into 1 database.
<6> Log in and it will tell you?
<20> yeah will
<6> hirise, I didn't ask a question that has "yeah" as a response...
<20> says connection from my machine (my laptop) not allowed
<6> !m hirise adding new user
<3> hirise: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<20> i have mysql administrator installed on my machines (if that helps)
<26> right now if a customer has servers in two datacenters we don't have a way to pull 1 report for all of their servers.
<6> Add a user that can connect.
<20> okay
<20> thanks
<20> '192.168.0.103' is not allowed to connect to this MySQL server
<6> You don't have a user that can connect from that IP
<20> okay
<20> thanks will
<4> TodoInTX: so basically you want federated + merge
<26> shabbs: I had thought about using federated tables but I don't want to have to do a bunch of queries over the internet.
<26> right.
<4> TodoInTX: you do the queries locally, which then goes and gets the data from the remote site
<25> myconid: any thoughts?
<6> TodoInTX, Does this have to be done at the DB level? Couldn't your application combine the data?
<26> I'm thinking I want to copy all the data locally then query it. The sync will be slow but the queries I run against it will be faster.
<6> What about other DB solutions, like PostgreSQL?
<26> the application would need to make calls out to 4-5 databases which are over the internet, not ideal to have the app merge the data.
<4> TodoInTX: but that's basically what you're talking about. merging the data first then querying it
<29> <?php
<29> mysql_connect("localhost", "root", "alOharow2") or die(mysql_error());
<29> echo "Connected to MySQL<br />";
<29> ?>
Return to
#mysql
or
Go to some related
logs:
#linux
ipcalc cygwin
linux interface_exists -php -PHP
#osdev
how big is kde?
#php
liquidglass screenshot
#debian
+-12263 +https +ubuntu
burn .dmg k3b
|
|