| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> and xml is the solution I tell ye!
<1> Vooloo, don't see the problem?
<2> http://pastebin.com/636801
<2> this outputs a very simple table, showing a joined table, then a form to add more rows, using INSERT queries
<3> with MySQL 5 and OSX 10.4.5
<2> but i keep getting this damned message:
<2> QueryName failed: 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 '1' at line 1
<2> i guess its line 22, but i cant see whats wrong
<4> CrazyTux: so like WHERE id=15 AND id=16 AND id=17?
<2> neither id fields are auto_incremented
<1> WHERE id IN (15, 16, 17)
<3> I was trying to set up my own wiki, and I couldn't do any sort of MySQL thing whatsoever
<4> CrazyTux: cool thanks
<1> Vooloo, np
<3> it isn't in the terminal,
<3> nothing
<3> It's almost as if I didn't install is
<3> but I did
<5> hi!
<5> can anyone help me to setup the mysql server?
<6> MEBE!
<5> i have installed the server...
<5> i've tried to configure but now my phpmyadmin says
<5> #1045 - Access denied for user: 'root@localhost' (Using p***word: NO)
<5> what shoul i do?
<6> IDUNO!
<6> er I mean
<6> you need to create a username and p***word
<6> and then configure phpmyadmin's config file with that u/p
<7> i can't believe how much progress i'm making today
<7> lol i've worked for like a whole month in 1 day
<5> Jax: can you heklp me to configure my mysql server?
<8> I need a c++ interface to MySQL. Any recommendations?
<8> I was thinking probably ODBC would be the way to go, but I'm really sure what to do
<8> *not really
<8> alecs: have you created any users for your database?
<7> alecs hm not sure, what's up ?
<9> how do I reset the root p***word in mysql on a linux machine?
<10> !m kury- reset root p***word
<11> kury-: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<9> infi, Thanks..
<12> what's a good strategy to fetch tree-structured data from an SQL database?
<12> i.e. i want to end up with company (item1, item2, item3), address, contact (name1, name2, name3)
<12> i could maybe try subqueries and concat_ws('\n' the subqueries?
<12> ultimately i want nested arrays of data in the host application language
<12> it's not a true tree, it's more like heirarchal joins
<12> alas, i wish i had a copy of joe celko's book handy
<12> i borrowed a copy but had to give it back
<5> can anyone help me to setup the mysql server?
<5> i've tried to configure but now my phpmyadmin says
<13> Hello
<5> #1045 - Access denied for user: 'root@localhost' (Using p***word: NO)
<13> alecs - I think that means your not using a p***word and access denied
<5> yes...
<13> obviously :P
<5> but i don't think i have the user tables...
<8> alecs: you should
<5> how can i meke it?
<5> or remake it
<8> http://dev.mysql.com/doc/refman/5.0/en/create-user.html
<12> alecs: ask your ISP
<8> give that a shot
<5> is on the localhost :D
<12> alecs: then marp's link should cover you
<8> alecs: can you get any kind of access to the database? mysql command line or something?
<5> muhoo, marp: is about the root user
<5> mysql command line...
<13> Is it better to have CREATE TABE type1,2,3...10 (val1 int, val2 int) or CREATE TABLE type (type int, val1 int, val2 int) where type is anywhere between 1 to 10 instead of 10 typeX tables?
<9> how come I can't seem to have a mysql root p***word unless I set it as ""
<9> ?
<5> malex: are you on?
<8> alecs: using mysql command line, type "connect mysql" then "select user, host from user;"
<8> that tells you what user can connect from which hosts
<14> hey all - "mysqladmin proc stat" is showing only 1 thread as running, but in my my.cnf I have 'thread_concurrency=8', why might that be?
<15> what is the USERS,frm for? im geting soime error on a friends server saying cant find the file exists and i guess this is on a new default install
<14> oh,ignore that - it is working ;)
<5> |No database selected|
<14> thread_concurrency is advised to be twice CPU's, if I'm using Xeon HT, is that 1 or 2 CPUs?
<8> alecs: try "select user, host from mysql.user;", maybe
<16> endlesshope: it is one of the grants tables. You may need to do mysql_install_db
<15> yea it sux cause im not exactly sure what was done b4 me
<5> yes... i saw... now i must create a sql to update the user table
<8> does anyone here use libodbc++?
<5> i have root user and root p***word
<5> how can i update the tablle?
<8> alecs: hmmm... what do you need to update?
<5> i need delete root p***word
<8> it sounds like myphpadmin isn't sending a p***word to the server when it tries to log in
<8> oh, ok
<5> *2 delete
<8> alecs: just set the p***word for root to an empty string on mysql.user
<5> yes... but i don't know the sintax ....
<5> UPDATE mysql.user (p***word="") WHERE user=root;?
<8> update mysql.user set p***word='' where user='root';
<8> I think
<17> SET P***WORD FOR root@localhost = P***WORD('myp***');
<18> in some situations you need to use OLD_P***WORD()
<8> can anyone point me at a good c++ odbc library?
<19> earlier on today i uploaded a *.sql using a phpMyAdmin interface. uploading gave an error on some syntax in a table, despite uploading using the phpMyAdmin and the same version of mysql on another machine without problem..
<19> i set it for MYSQL323 compatibility to get around this, and it uploaded fine.. but now i can't make new entries to the db in one case (articles) whereas i can everywhere else. is it possible that this compatibility precaution munged a part of my db?
<20> Greetings ppl!
<20> Can someone please take a look at: http://www.nomorepasting.com/paste.php?pasteID=60192 ? I'm kinda stuck here. any hint would be thankful!
<21> Cqence: I think the problem is that the shipment date is 100 years later than the invoice date, so the customer died
<19> peqe_: awful, such shoddy service.
<20> peqe_: but we dont care about that. the problem is somewhere else.
<21> Cquence: Maybe try a left join and then select for NULL
<5> how can i chhange the charset of the php myadmin?
<20> peqe_: Nope LEFT JOIN gives me the same result.
<22> !SQL clustering
<23> Cquence: You're confused. Post the LEFT JOIN query you attempted.
<20> Xgc: at the pastebin right?
<23> Cquence: The answer is (in fact) to use a LEFT JOIN.
<23> Cquence: Yes.
<5> why do i get the error message?
<5> #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 7
<5> on the following sql?
<5> CREATE TABLE `abonati` (
<5> `id` int(11) NOT NULL auto_increment,
<5> `numeri` varchar(50) NOT NULL default '',
<5> `email` varchar(20) NOT NULL default '',
<5> `statut` char(2) NOT NULL default '',
<5> PRIMARY KEY (`id`)
<23> Cquence: This is the same question (in form) that peqe_ asked in #sql a little while ago. It's solved the same way.
<5> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
<23> alecs: Don't do that in the channel.
<23> alecs: The /topic indicates where to post that type of information.
<20> Xgc: I tryed that aswell but it return me nothing becasue in fact i didn have any compared columns to be NULL
<5> Xgc: sorry ! it will not happen again
<20> Xgc: this is what i tryed without the IS NULL http://www.nomorepasting.com/paste.php?pasteID=60193
<23> Cquence: You didn't form the LEFT JOIN properly. The result CAN'T be the same as the INNER JOIN, since the criteria is also different.
<10> alecs: what version of mysql are you using?
<20> Xgc: can you locate my error pls. I'm kinda stack and i dont know where i'm wrong in this one.
<23> Cquence: Which table contains a subset of the BillOfLading numbers?
<23> Cquence: Ah. The shippingItem table. Right?
<20> Xgc: ContractItem
<23> Cquence: Hmmm?
<20> ??
<23> Cquence: Are you saying the shipping table contains the full set of lading numbers and the contract does not?
<20> No exactly the opposite
<23> Cquence: Right. Your answer should have been shipping table.
<20> hmm ok. My mistake here. but i think i state that correctly in the query .
<9> Anyone know why I can't ever get connected to my mysql server?? I've reset the p***word several times but every time I try and log in I get: ERROR 1045 (28000): Access denied for user 'root'@'localhost'
<23> Cquence: FROM contractItem LEFT JOIN shippingItem ON (same criteria) WHERE contractitem.ContractNo = 'R28' AND shippingItem.BillOfLading IS NULL
<23> Cquence: Your JOIN was in the wrong direction and you didn't check only for the NULL shipping entries.
<20> Xgc: Ohh my.... I dont know how to thank you man. You cant image how much time i'm trying to figure this out.
<23> Cquence: You're quite welcome.
<9> mysql help?
<23> kury-: If you're lucky. Do you feel lucky today? Well, do you?
<9> Xgc, Yes.. now may I get some help
Return to
#mysql
or
Go to some related
logs:
#web
#linux
#centos
g++ try catch finally
#php
#debian
8139too 1and1
xmms ubuntu wma hangs
zlib library not found ubuntu
sendmail smart relay host sendmail.cf aix
|
|